Skip to content

Instantly share code, notes, and snippets.

@jayjanssen
Created June 3, 2013 16:25
Show Gist options
  • Select an option

  • Save jayjanssen/5699348 to your computer and use it in GitHub Desktop.

Select an option

Save jayjanssen/5699348 to your computer and use it in GitHub Desktop.
PMP nagios with Galera (Credit to Roman Vynar)
# Note status (similar to what clustercheck does)
[root@civic ~]# /usr/lib64/nagios/plugins/pmp-check-mysql-status -x wsrep_local_state -C '!=' -w 4
OK wsrep_local_state = 4 | wsrep_local_state=4;4;;0;
# Cluster size (warn when it's lower than 3)
[root@civic ~]# /usr/lib64/nagios/plugins/pmp-check-mysql-status -x wsrep_cluster_size -C '<' -w 3
WARN wsrep_cluster_size = 1 | wsrep_cluster_size=1;3;;0;
# Checking replication health
[root@civic ~]# /usr/lib64/nagios/plugins/pmp-check-mysql-status -x wsrep_flow_control_paused -C '>=' -w 0.5 -c 1
OK wsrep_flow_control_paused = 0.2 | wsrep_flow_control_paused=0.2;0.5;1;0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment