Add '!=' comparison operator to pmp-check-mysql-status

[Roman Vynar]

pmp-check-mysql-status supports operators with the -C option, which accepts the arithmetic comparison operators ==, >, >=, <, and <=. But there is no inequality operator '!=' that also might be useful.

For example, to ensure that PXC node is ok you need to verify that the MySQL variable "wsrep_local_state" equals 4 and no other. BTW, it could equal to from 0 to 6 (http://www.codership.com/wiki/doku.php?id=galera_node_fsm). Without the inequality operator it is difficult to achieve this.

When I modify the script slightly I could achieve the necessary result. For example:

[root@centos6 ~]# /opt/percona-nagios-plugins/pmp-check-mysql-status -x wsrep_local_state -C '!=' -w 4
OK wsrep_local_state = 4

[root@centos6 ~]# /opt/percona-nagios-plugins/pmp-check-mysql-status -x wsrep_local_state -C '!=' -w 4
WARN wsrep_local_state = 0

[root@centos6 ~]# /opt/percona-nagios-plugins/pmp-check-mysql-status -x wsrep_local_state -C '!=' -c 4
CRIT wsrep_local_state = 0

Please add '!=' as the comparison operator. It may be useful for other strict-value-variable checks.

[Fabio Marconi (fabiomarconi)]

close ubuntu tag
---
Ubuntu Bug Squad volunteer triager
http://wiki.ubuntu.com/BugSquad