MySQL

MySQL Replication Lag Time

Write a Review

Description:

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

Current Version

Last Release Date

May 28, 2009

Compatible With

Owner

Nagios Exchange

Website

http://www.sheeri.com/

Copy Page Link Recommend Login to Add to Favorites
Project Files
FileDescription
check_mysqlrep.sh

check_mysqlrep.sh

Project Notes
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) Add a Review
Built into check_mysql
by nkadel, February 28, 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
by jakob, July 31, 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!


Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
3.5 (2)
Favorites
0
Views
101,090