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.