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
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?