Not the answer you need?
Register and ask your own question!

Percona XtraDB Cluster Operator - mount additional storage (INFILE)

sakacjakubsakacjakub EntrantCurrent User Role Novice
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](https://www.percona.com/doc/kubernetes-operator-for-pxc/kubernetes.html)

Configuration files:
[cr.yaml](https://pastebin.com/VKY4J8qF)
[operator.yaml](https://pastebin.com/u15Qu8dU)

Thanks all.

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.