Skip to main content

Could you add a new mode to check Galera Cluster: https://galeracluster.com/library/training/tutorials/galera-monitoring.html

There are different "SHOW GLOBAL STATUS" that allows to now:

  • Node/Cluster status
  • Replication health
SELECT * FROM information_schema.global_status WHERE variable_name IN ('WSREP_CLUSTER_STATUS','WSREP_LOCAL_STATE_COMMENT','WSREP_CLUSTER_SIZE','WSREP_READY');
+---------------------------+---------------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+---------------------------+---------------------------+
| WSREP_LOCAL_STATE_COMMENT | Synced |
| WSREP_CLUSTER_SIZE | 3 |
| WSREP_CLUSTER_STATUS | Primary |
| WSREP_READY | ON |
+---------------------------+---------------------------+
NewNeeds Votes

Hi ,

I will add wsrep_local_state :

SELECT * FROM information_schema.global_status WHERE variable_name IN ('WSREP_CLUSTER_STATUS','WSREP_LOCAL_STATE_COMMENT','WSREP_CLUSTER_SIZE','WSREP_READY','wsrep_local_state');

 

+---------------------------+----------------+
| VARIABLE_NAME             | VARIABLE_VALUE |
+---------------------------+----------------+
| WSREP_CLUSTER_SIZE        | 2              |
| WSREP_CLUSTER_STATUS      | Primary        |
| WSREP_LOCAL_STATE         | 4              |
| WSREP_LOCAL_STATE_COMMENT | Synced         |
| WSREP_READY               | ON             |
+---------------------------+----------------+