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

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
94430
Files:
FileDescription
check_mysql_slave.plcheck_mysql_slave.pl
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
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