Some people want to use a backup to prepare a new Percona XtraDB Cluster node. They want this to avoid State Snapshot Transfer that could slow down the donor (depending of the SST method you are using, the donor can be blocked. I will cover this in a future blog post). As backup are generally performed during non-peak time, the effect should be reduced, and this avoid the need of performing 2 backups: the usual backup and the SST).
So to be able to use a backup for this purpose, we have 3 prerequisites:
- use XtraBackup >= 2.0.1
- the backup needs to be performed with –galera-info (option for innobackupex)
- have a gcache big enough to store all the changes from the time of the backup until the restore to be able to perform the