we have a small problem with the percona monitoring plugins for nagios.
We use for a MySQL Galera Cluster several checks with pmp-check-mysql-status.
pmp-check-mysql-status -x wsrep_cluster_status -C ‘==’ -T str -c non-Primary -L local
pmp-check-mysql-status -x wsrep_local_state_comment -C ‘!=’ -T str -w Synced -L local
pmp-check-mysql-status -x wsrep_cluster_size -C “<=” -w 2 -c 1 -L local
pmp-check-mysql-status -x wsrep_flow_control_paused -w 0.1 -c 0.9 -L local
The Problem is if the database offline or not reachable or the login is wrong, the check change it state to unkown. But we want for this case an critical if the check cannot be processed.
So i could modify the script itself but it’s a very dirty solution and i didn’t find another solution at the moment.
What would be the best practice way?