Home Directory Plugins Databases MySQL check_mysql_slavestatus

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

check_mysql_slavestatus

Rating
0 votes
Favoured:
0
Current Version
0.1.1
Last Release Date
2012-12-10
Owner
License
GPL
Hits
42017
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
check_mysql_slavestatus.sh

Usage: $CMDNAME [-H HOST] [-u MySQLUser] [-p MySQLPassword] [-L BehindMasterLimit(sec)]
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$