MariaDB Galera cluster slow SST sync

clustergaleramariadbrsync

I have a MariaDB Galera cluster with 3 nodes and I configured the SST transfer as

wsrep_sst_method = rsync

When I have to stop and restart a single node, the synchronization is very slow even if the node remained stopped only for 1 hour: it takes about 2 hours to sync.

Is there a way to speed up the synchronization time?

Thanks!

Best Answer

You could change SST method to xtrabackup-v2(here simple documentation) and configure MySQL as described in this article in Percona blog. May be it could be helpful for you.

Related Topic