mysql_slave_check_multimaster

Project Notes

-- Description --

A MySQL slave check written in php that reports on all channels with Multi Master slave replication available as of MySQL 5.7. The plugin also work with previous version or mysql where there's only one slave thread.

---Usage---

/usr/bin/php mysql_slave_check_multimaster.php -c critical_delay -w warning_delay [-h mysqlserver[:port]] [-u user] [-p password]

---Parameters---
-h mysql server [localhost[:port]]
-u mysql account that has access to show processlist and show slave status [root]
-p password to the mysql account []
-c raise critical delay if replication delay is greater then pecificed value
-w raise warning delay if replication delay is greater then specificed value

---Example---

/usr/bin/php /usr/local/nagios-custom-checks/mysql_slave_check_multimaster.php -h host.name:7309 -u mysqluser -p password -w 500 -c 2000

NOTE: The port number can be appended (or omitted) after the host name separated by a semicolumn.