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_slave 2010
Current Version
2.0
Last Release Date
2010-03-10
Compatible With
- Nagios 3.x
Owner
Hits
98354
Files:
| File | Description |
|---|---|
| check_mysql_slave.pl | check_mysql_slave.pl |
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!
check mysql replication lag from master
check mysql slave io running
check mysql slave sql running
This script basically combines three key checks for MySQL Slaves: 1. Binlog master vs. exec posistion to determine lag. 2. Slave IO. 3. Slave SQL.
If you don't monitor all three, you may not see lag if there is little activity. Because of how I've structured (written) this rewritten version of check_mysql_repl, you can easily add checks based on output of check slave statusG. For example, it would be easy to add check for "seconds behind master".
Why did I do this all in one script? To reduce number of mysql connections.. I wanted 1 connect to get all the slave status info.
Note, you need command section like:
define command {
command_name check_mysql_slave
command_line $USER1$/check_mysql_slave.pl --master $ARG1$
--slave $ARG2$ --dbuser=$USER3$ --dbpass=$USER4$
--port=$ARG3$ --warn=$ARG4$ --crit=$ARG5$
}
And then you need to put username and password in resources.cfg file, makeing sure to use unique USERn variables... and make sure the n(s) you choose reflect the command section above.
Joe DeCello
If you don't monitor all three, you may not see lag if there is little activity. Because of how I've structured (written) this rewritten version of check_mysql_repl, you can easily add checks based on output of check slave statusG. For example, it would be easy to add check for "seconds behind master".
Why did I do this all in one script? To reduce number of mysql connections.. I wanted 1 connect to get all the slave status info.
Note, you need command section like:
define command {
command_name check_mysql_slave
command_line $USER1$/check_mysql_slave.pl --master $ARG1$
--slave $ARG2$ --dbuser=$USER3$ --dbpass=$USER4$
--port=$ARG3$ --warn=$ARG4$ --crit=$ARG5$
}
And then you need to put username and password in resources.cfg file, makeing sure to use unique USERn variables... and make sure the n(s) you choose reflect the command section above.
Joe DeCello
Reviews (0)
Be the first to review this listing!
