D
D
Dr. Robert Ford2019-09-15 20:31:32
MySQL
Dr. Robert Ford, 2019-09-15 20:31:32

How to properly restore a backup for a MySQL cluster (Percona Xtradb Cluster)?

There is a PXC cluster consisting of 5 nodes. How can I create backups and restore them?
Innobackupex is not suitable because it does not allow you to restore individual databases. Accordingly, the following backup algorithm is formed:
1) Desynchronize (wsrep_desync) one of the cluster nodes
2) Using mysqldump, create a backup on this node
3) Synchronize our node with the cluster
Recovery:
1) Stop all cluster nodes (or desynchronize them) for except for one
2) Upload the dump to the remaining node gunzip < all_databases.gz | mysql -u root
3) Run all cluster nodes
Is the algorithm correct?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question