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

There is a PXC cluster composed of 5 nodes. How you can create backups and restore them?
Innobackupex is not suitable, because it is not possible to restore individual databases. Accordingly, one gets an algorithm backup:
1) Desychronization (wsrep_desync) one of the node cluster
2) use mysqldump to create a backup on this node
3) Sync up our node to the cluster
Recovery:
1) Stop all nodes in the cluster(or desynchronizing them) except for one
2) Fill the dump on the remaining node gunzip < all_databases.gz | mysql -u root
3) start all cluster nodes
The correct algorithm?
March 29th 20 at 23:46
0 answer

Find more questions by tags clustersPerconaBacking upMySQL