Stop or Suspend a percona cluster

MySQL & MariaDB
,
1

Hi,

We have a percona cluster with 3 mysql server nodes part of it. We want to break or suspend this cluster. We want to run these mysql servers individually. So by removing the below changes in my.cnf of all nodes and restart them, would that be enough to stop or suspend the cluster?

wsrep_cluster_address=gcomm://172.20.2.211,172.20.2.212,172.20.2.213
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_provider_options=“gcache.size=4G”
wsrep_sst_method=xtrabackup-v2
wsrep_node_name=ip-172-20-2-212
wsrep_slave_threads=24
wsrep_slave_FK_checks=0
wsrep_retry_autocommit=100
wsrep_sst_auth=SST_Snapshot:xxxxxxxxxxx

Thanks and Regards,
Manohar.

2

There is a big difference between ‘break’ and ‘suspend’. The first is permanent and the second is temporary. Once you break PXC and change the data you can no longer resume the cluster. ‘Suspend’ means to temporarily stop the cluster and resume it again in the future.

But yes, if you remove all those parameters, you will turn off all the clustering.

1 Like
3

Thanks @matthewb this is what we need!

1 Like