Convert from 3 node cluster, to singleton node?

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hi,

I have a 3 node cluster, is it possible to “convert it” into just a single server node? or will it some how mess up data?

2

Hello @Simon_Karberg,
Yes, you can convert. Simply stop node3, gracefully. Then stop node2, gracefully. Now you have a cluster of 1 node. Stop this node, gracefully. Then edit the my.cnf and remove all wsrep_ parameters and start MySQL. You’ll have a “standard” MySQL without any clustering components.

3

awesome, sounds easy :slight_smile: