Convert from 3 node cluster, to singleton node?


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?

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.

awesome, sounds easy :slight_smile: