check_mysql_slavestatus

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$

You must be logged in to submit a review.

Your review has been submitted and is pending approval.

Your recommendation has been sent.

Project Overview Project Notes Reviews