Promoting slave into PXC without SST

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

Let’s say I have a cluster already deployed. This cluster has one slave server replicating from it (on regular Percona Server). If I’m certain this slave is up to date with the master (cluster), is there a way to join this server as a node without doing the lengthy SST?

Thanks!

2

In that case, you need to update related wsrep* related parameters in my.cnf and restart that slave node to join as cluster node without SST if all data already synchronized. There is post exits too which describes to take backup and restore to node to bypass SST [url]https://www.percona.com/blog/2012/08/02/avoiding-sst-when-adding-new-percona-xtradb-cluster-node/[/url]