Shutting down MariaDB Galera Cluster

There can be a time when we want to shut down our entire cluster; maybe for a move to a different facility, or because we are replacing it completely. Whatever the reason, this recipe outlines the preferred way to do so.

Getting ready

Create MariaDB Galera Cluster as described in the Installing MariaDB Galera Cluster recipe earlier in this chapter.

How to do it...

1. Ensure that any applications using the cluster are shut down.

2. On db03, run the following command to check whether the node is up to date:

   mysql -e "SHOW STATUS LIKE 'wsrep_local_state_comment'"
   

3. If the value is synced, run the following command to shut down the node:

   sudo service mysql shutdown
   

4. On db02 and db01, repeat the same steps, first on db02, and then on db01.

How it works...

Shutting down MariaDB Galera Cluster is just like shutting down MariaDB. To be careful, we should make sure that the applications which use the cluster are shut down so that the cluster is idle.

Then, it is just a simple...