We have Percona XtraDB Cluster Operator setup on Kubernetes. In main configuration of cluster we have set persistentVolumeClaim option for pxc and proxysql.

This is the query, we would like to execute on our Percona Cluster:

LOAD DATA LOCAL INFILE '/cloud/percona-data/test.csv' 
INTO TABLE testTable
FIELDS TERMINATED BY ';'
ENCLOSED BY '\"'
IGNORE 1 LINES
(id, testcolumn);

File '/cloud/percona-data/test.csv' has to be available via local storage.

We tried hostPath option, but it seems to be not active, because persistentVolume is configured (is that true or my configuration is not valid?).

This is the part of cluster configuration:

volumeSpec:
  hostPath:
    path: /cloud/percona-data
    type: Directory
  persistentVolumeClaim:
    resources:
      requests:
        storage: 6Gi

Is there any way to mount additional storage to all pxc and proxysql pods?

Install guide Percona XtraDB Cluster

Configuration files: cr.yaml operator.yaml

Thanks all.