Skip to main content
Needs Votes

database::mysql::plugin - new mode to monitor MySQL Galera Cluster status

Related products:Infra Monitoring - Connectors
  • June 5, 2024
  • 2 replies
  • 62 views

Forum|alt.badge.img+7

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

2 replies

rchauvel
Centreonian
Forum|alt.badge.img+18
  • Centreonian
  • June 14, 2024
NewNeeds Votes

Forum|alt.badge.img+8
  • Steward **
  • July 17, 2024

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