Build precise queries to find exactly what you need
Press ESC to close
Your review has been submitted and is pending approval.
check_mysql_slavestatus.sh Usage: $CMDNAME [-H HOST] [-u MySQLUser] [-p MySQLPassword] [-L BehindMasterLimit(sec)]
Current Version
0.1.1
Last Release Date
2012-12-10
Owner
TakayukiSaito
Website
https://github.com/taka3110
Download URL
https://gist.github.com/4248669/
License
GPL
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.
To:
From:
We’ve completely redesigned the world’s largest repository of Nagios plugins and monitoring tools. Join thousands of users sharing monitoring solutions for servers, applications, and everything in between.
Due to our redesign, all existing accounts require a password reset to access your account again.
Ready to explore 6,100+ projects and contribute to the community?
Reset Password Create Account
Happy Monitoring!