Buy Percona ServicesBuy Now!

Join to cluster when have more than one directory mysq-data

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

  • Join to cluster when have more than one directory mysq-data

    Hello, All.
    I have database with tables that have several partitions. And some partitons placed into another volume.
    At runtime i can create partiton in different data-dirs, because node have identical data-paths. But when need node rejoin to cluster, appear a problem:

    1) SST-transfer clear mysql-data dir, but not clear other dir where was partitions. On stage innobackupex-move i have error "Destination file exists" and SST end with error. I can manually delete these files but have a second problem
    2) The entire database does not fit in one volume. And when SST in progress all tables placed into .sst dir inside mysql-data. In these volume not enough space for all data. SST will still fail.

    How to join these nodes?
Working...
X