Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
MySQL Replication Lag Time
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!
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.
Suggestions welcome.
Reviews (2)
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.
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!
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!