MySQL

check_mysql_slavestatus

Write a Review

Description:

check_mysql_slavestatus.sh

Usage: $CMDNAME [-H HOST] [-u MySQLUser] [-p MySQLPassword] [-L BehindMasterLimit(sec)]

Current Version

0.1.1

Last Release Date

2012-12-10

Compatible With

Owner

TakayukiSaito

Website

https://github.com/taka3110

Download URL

https://gist.github.com/4248669/

License

GPL

Copy Page Link Recommend Login to Add to Favorites Login to Claim
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.

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!
Project Notes
This is MySQL Replication check. There are 3 checkpoints. 1. Seconds_Behind_Master 2. Slave_IO_Running 3. Slave_SQL_Running Check the difference between Master and Slave on MySQL. When "Seconds_Behind_Master" exceed the limit value, or either slave's status of "Slave_IO_Running" or "Slave_SQL_Running" is "No", Nagios's "current status" will change to "Critical". How to use: This script use SQL "show slave status". Please add a user with execute authority to MySQL. Download this script and you change the file permission to "chmod + x". Please add on your nagios's plugins directory. exam) /usr/lib64/nagios/plugins Usage: $CMDNAME [-H HOST] [-u MySQLUser] [-p MySQLPassword] [-L BehindMasterLimit(sec)] command_line: $USER1$/check_mysql_slavestatus.sh -H $HOSTADDRESS$ -u $ARG1$ -p $ARG2$ -L $ARG3$
Reviews (0) Add a Review
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 Notes Reviews
Project Stats
Rating
0 (0)
Favorites
0
Views
46,909