Home Directory Plugins Databases MySQL check_mysql_slave 2010

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

Directory Tree

check_mysql_slave 2010

Rating
0 votes
Favoured:
1
Current Version
2.0
Last Release Date
2010-03-10
Compatible With
  • Nagios 3.x
Hits
98325
Files:
FileDescription
check_mysql_slave.plcheck_mysql_slave.pl
Nagios CSP

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!
Monitor MySQL Slave and replication status.

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