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
46835
Meet The New Nagios Core Services Platform
Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.
Monitoring Made Magically Better
- Nagios Core on Overdrive
- Powerful Monitoring Dashboards
- Time-Saving Configuration Wizards
- Open Source Powered Monitoring On Steroids
- And So Much More!
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!
