MySQL Replication Lag Time

Submit review Recommend Print Visit

Rating

2 votes

Favoured:

Owner

nagiosexchange

Website

www.sheeri.com/

Hits

101068

Files:

File	Description
check_mysqlrep.sh	check_mysqlrep.sh

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.

Download Now

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!

A shell script (/bin/sh) that connects to a specified MySQL slave database and checks the replication lag time.

Required parameters: host, user, password. Optional parameters: seconds to warn at, and seconds to be critical at. The default is to warn if replication falls more than 30 seconds behind, and go critical if replication falls more than 60 seconds behind. Also goes critical if the slave is not running, and therefore the lag time is NULL.

Suggestions welcome.

Reviews (2)

Built into check_mysql

bynkadel, February 2, 2015

This is redundant: it's built into the nagios-plugins published 'check_mysql' package, which is tested and maintained. Use 'check_mysql -S' and review the options desired.

Works well after some rework

byjakob, July 14, 2011

Only needs the mysql command line client, which is nice.

Needed some rework to work well, new version here:
http://pastebin.com/jkzC8pDe (full)
http://pastebin.com/dybGAjzg (diff)

Problems fixed are:
- Connection failure not handled at all
- Error messages from mysql not captured
- Garbage output when called without command line arguments
- Does not work at all because of use of "==" bashish, despite calling /bin/sh
- cut is in /usr/bin, not /bin, at least on Debian/Ubuntu

Thanks for the plugin!

Nagios, the Nagios logo, and Nagios graphics are the servicemarks, trademarks, or registered trademarks owned by Nagios Enterprises. All other servicemarks and trademarks are the property of their respective owner. The files and information on this site are the property of their respective owner(s). Nagios Enterprises makes no claims or warranties as to the fitness of any file or information on this website, for any purpose whatsoever. In fact, we officially disclaim all liability. We do, however, think these community contributions are pretty damn cool. Website Copyright © 2009-2024 Nagios Enterprises, LLC. All rights reserved.