Verify a Galera cluster status¶

You can verify the status of a MySQL Galera cluster either manually from the Salt Master node or automatically using Jenkins.

To verify a MySQL Galera cluster status, select from the following options:

• Verify the Galera cluster status automatically using the Verify and Restore Galera cluster Jenkins pipeline as desribed in Restore a Galera cluster and database automatically.

• Verify the Galera cluster status manually:

  1. Log in to the Salt Master node.

  2. Apply the following state:

     salt -C 'I@galera:master' mysql.status | \
     grep -EA1 'wsrep_(local_state_c|incoming_a|cluster_size)'
     

     Example of system response:

     wsrep_cluster_size:
         3
     
     wsrep_incoming_addresses:
         192.168.2.52:3306,192.168.2.53:3306,192.168.2.51:3306
     
     wsrep_local_state_comment:
         Synced