Restore backup created by innobackupex

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

wsrep_provider_version | 2.2(r137)

Server version: 5.5.28-log Percona XtraDB Cluster (GPL), wsrep_23.7.r3821

Created a backup with innobackupex, including --galera-info

Please confirm these steps:

If I want to restore the backup,

  1. shut down all nodes within the cluster

  2. Restore backup
    innobackupex --copy-back /path/to/BACKUP-DIR

  3. check files permissions on/in data-dir (/var/lib/mysql), and change as necessary

  4. modify my.cnf file parameter wsrep_cluster_address to gcomm:// to re-initialize cluster

  5. restart mysql

  6. start other nodes in cluster, 1 by 1 - should see SST performed

Does that sound about right?

How does the xtrabackup_galera_info file come into play?

2

I you want to restore all the nodes like that, you can just ignore the galera_info, this is used to specifies the position in the replication to be able to perform IST instead of SST.
If you want to be sure that all your server will perform the SST, you can delete the file grastate.dat (in datadirectory) before starting mysql.

3

lefred -
thanks for the info, however, can you explain further how to restore using the galera_info?

Say I have a 3-node cluster, and I plan to restore to node 1. How would my steps be modified if I wanted IST for nodes 2 and 3?

Regards,
Scott