Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
check_mysql_slavestatus
Current Version
0.1.1
Last Release Date
2012-12-10
Owner
Website
Download URL
License
GPL
Hits
46387
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$
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$
Reviews (0)
Be the first to review this listing!
