Buy Percona ServicesBuy Now!

Percona XtraDB Cluster Operator - mount additional storage (INFILE)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Percona XtraDB Cluster Operator - mount additional storage (INFILE)

    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:
    Code:
    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:
    Code:
    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/kubernet...ubernetes.html)

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

    Thanks all.

  • #2
    *bump*, anyone?

    Comment

    Working...
    X