Backup/Restore with HyperDB

  • I’ve been trying to find documentation on how best to coordinate backups and restores when using HyperDB with tables split between different MySQL hosts.

    Anyone have any suggestions on how to approach this? I suspect the wp-cli db export could be used but haven’t found any documentation confirming it will work as expected.

Viewing 1 replies (of 1 total)

  • Hi @mdpdmichael,

    mysqldump works pretty well. If you have a large amount of data per instance you can take a look xtrabackup.

    Anyone have any suggestions on how to approach this? I suspect the wp-cli db export could be used but haven’t found any documentation confirming it will work as expected.

    It runs mysqldump utility too, but if you are splitting tables across the different hosts, it doesn’t look the ideal way.

    My advice, don’t split tables unless it required. You can use master/slave approach for load balancing (split read and write requests first) and you can easily run mysqldump utility on the one of slave host.

Viewing 1 replies (of 1 total)
  • The topic ‘Backup/Restore with HyperDB’ is closed to new replies.