Transform Galera cluster into single node mariadb server

clustergaleramariadbmysql-cluster

We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower than our previous single node setup was. Is it possible to just remove two of the nodes and run the single node as a standalone mariadb server or are there repercussions that would justify the time and cost to set up a new database server and transfer all the databases onto the new one? The database currently holds about 150GB of data, so I would like to avoid that, if there are no drawbacks…

Best Answer

It's easy. You should gracefully stop all nodes. After this remove all Galera configuration from my.cnf and start MySQL. Better to do it on latest stopped node, to prevent dataloss.

Related Topic