Home Directory Plugins Databases MySQL check mysql slave sql running

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

Directory Tree

check mysql slave sql running

Rating
5 votes
Favoured:
0
Hits
106518
Files:
FileDescription
check_mysqlslavesqlrun.shcheck_mysqlslavesqlrun.sh
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.

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!
checks to see if mysql slave sql is running. written in a shell script, so its easily portable.
checks to see if mysql slave sql is running. written in a shell script, so its easily portable.
Reviews (4)
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.
I got the script to work.
the write left out the host part.
to fix this you need to answer line to:
answer=`$mysqlpath/mysql -u $user -p$pass -h $host -e 'show slave status\G' | /bin/grep Slave_SQL_Running | /usr/bin/cut -f2 -d:`
bytalonx, November 1, 2010
There's no support for a custom port. And the host parameter seems to be completely ignored.
byuneaqs, March 16, 2010
works very well, thank you!