view counter

Avoiding SST when adding new Percona XtraDB Cluster node

Thanks to Peter Zaitsev for this story

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).

view counter

So to be able to use a backup for this purpose, we have 3 prerequisites:

Read the entire article at its source

view counter