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 |
+---------------------------+---------------------------+