Versions Compared

Old Version 3

changes.mady.by.user MS

Saved on

compared with

New Version 4

changes.mady.by.user MS

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Check Galera cluster leader 

To stop or start the Galera cluster you should first identify the leader node.

  1. On the datanodes, check the state of Galera:

    Code Block
    [root@datanodes0 /]# cd /var/lib/mysql/
[root@datanodes0 mysql]# cat grastate.dat 
# GALERA saved state
version: 2.1
uuid:    c0e2c5f4-e045-11e9-988e-d6d16254ad99
seqno:   -1
safe_to_bootstrap: 0

    If there is a node with safe_to_bootstrap=1, you should start the cluster on this node
    If no node is marked as safe_to_bootstrap, force it (using the virt IP).

Stop Galera cluster

To stop the Galera cluster, start with the nodes that are NOT the, and leader stop the database on all nodes, .

Code Block
systemctl stop mariadb


Start Galera cluster

To start the Galera cluster, log in to the leader node.

...

Tip

Helpful commands to check cluster status:

Code Block
[root@datanodes1 mysql]# maxadmin show servers
[root@datanodes1 mysql]# maxadmin list servers




RabbitMQ Cluster check and rejoin

On each node do these commands.

...