check_mysql_slavestatus

Project Notes

This is MySQL Replication check.

There are 3 checkpoints.

1. Seconds_Behind_Master
2. Slave_IO_Running
3. Slave_SQL_Running

Check the difference between Master and Slave on MySQL.
When "Seconds_Behind_Master" exceed the limit value, or either slave's status of "Slave_IO_Running" or "Slave_SQL_Running" is "No", Nagios's "current status" will change to "Critical".

How to use:
This script use SQL "show slave status".
Please add a user with execute authority to MySQL.
Download this script and you change the file permission to "chmod + x".
Please add on your nagios's plugins directory.
exam) /usr/lib64/nagios/plugins

Usage: $CMDNAME [-H HOST] [-u MySQLUser] [-p MySQLPassword] [-L BehindMasterLimit(sec)]

command_line:
$USER1$/check_mysql_slavestatus.sh -H $HOSTADDRESS$ -u $ARG1$ -p $ARG2$ -L $ARG3$