Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Google Cloud Platform icon

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.

Google Cloud Platform icon

Path Info

Clock icon Intermediate
Clock icon 15m
Clock icon Jul 23, 2020

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. Challenge

    Stop All Nodes

    The MariaDB server needs to be stopped on all nodes:

    sudo systemctl stop mariadb.service
  2. 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
  3. 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/:


    Start the node:

    sudo systemctl stop mariadb.service
  4. 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:


    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:


    Start the node:

    sudo systemctl start mariadb.service

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Start learning by doing today

View Plans