Restart This Running MariaDB Galera Cluster

Libraries: If you want this lab, consider one of these libraries.
Cloud

Restart This Running MariaDB Galera Cluster

In this activity you are working as a DBA and have been tasked with stopping and restarting a running MariaDB Galera Cluster, to allow for data center maintenance.

Get started Contact sales

Lab Info

Level

Intermediate

Last updated

Sep 18, 2025

Duration

15m

Challenge

Stop All Nodes
The MariaDB server needs to be stopped on all nodes:
```
sudo systemctl stop mariadb.service
```
Challenge

Determine Most Advanced Node
The grastate.dat file needs to be examined on each node, to determine which is most advanced:
```
sudo cat /var/lib/mysql/grastate.dat
```
Challenge

Bootstrap the Most Advanced Node
The following commands will be run only on the most advanced, node as determined in the previous step.

Edit node configuration in /etc/my.cnf.d/:
```
wsrep_cluster_address=gcomm://
```
Start the node:
```
sudo systemctl stop mariadb.service
```
Challenge

Check Status and Add Nodes to the Cluster
Now we can connect to the server using using the mysql client on the node we bootstrapped in the previous step:
```
mysql
```
Once connected, we can run the following SQL statement to confirm the cluster is running:
```
SHOW GLOBAL STATUS WHERE Variable_name IN ('wsrep_ready', 'wsrep_cluster_size', 'wsrep_cluster_status', 'wsrep_connected');
```
A cluster size of 1 means only one node is connected.

To join the other node to the cluster, we need to edit its configuration in /etc/my.cnf.d/. Be certain to use the private IP of the already running node for the cluster address:
```
wsrep_cluster_address=gcom://10.0.1.110
```
Start the node:
```
sudo systemctl start mariadb.service
```

About the author

Pluralsight Skills

Pluralsight Skills gives leaders confidence they have the skills needed to execute technology strategy. Technology teams can benchmark expertise across roles, speed up release cycles and build reliable, secure products. By leveraging our expert content, skill assessments and one-of-a-kind analytics, keep up with the pace of change, put the right people on the right projects and boost productivity. It's the most effective path to developing tech skills at scale.

Real skill practice before real-world application

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Learn by doing

Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.

Follow your guide

All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.

Turn time into mastery

On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.