Home Directory Plugins Databases MySQL MySQL Replication Deadlock Recovery

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

MySQL Replication Deadlock Recovery

Current Version
1.0
Last Release Date
2012-02-06
License
BSD
Hits
77045
Files:
FileDescription
MySQL-Replication-DeadLock-Recovery.shMySQL Replication Deadlock Recovery Plugin
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!
A shell script (/bin/sh) that connects to a specified MySQL slave database, check the replication status for Deadlock errors (Error 'Deadlock found when trying to get lock: try restarting transaction') + Automatically recover from the state by performing "SLAVE STOP; SLAVE START;"

Required parameters: host, user, password.
If no Deadlock is detected, "OK" is returned
O/w, a message is printed and Warning state is returned.

Suggestions are welcome,
Moshe Kaplan
The best practice to handle deadlocks (after eliminating them from the code) is recovering from them.
Unfortunately, MySQL Replication does not recover automatically from these cases.
Therefore, we decided to implement this Nagios plugin. The plugin detects the deadlock and recover from it by restart the slave ("STOP SLAVE; START SLAVE;").

Fast, Simple and very effective.
Reviews (1)
MySQL mysqld_slave-skip-errors option [1] is a better solution.

[1] http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_slave-skip-errors