Build precise queries to find exactly what you need
Press ESC to close
Your review has been submitted and is pending approval.
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
Current Version
1.0
Last Release Date
2012-02-06
Owner
Moshe Kaplan
Website
http://top-performance.blogspot.com
Download URL
http://www.brightaqua.com/MySQL-Replication-DeadLock-Recovery.sh
License
BSD
MySQL Replication Deadlock Recovery Plugin
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.
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
You must be logged in to submit a review.
To:
From:
We’ve completely redesigned the world’s largest repository of Nagios plugins and monitoring tools. Join thousands of users sharing monitoring solutions for servers, applications, and everything in between.
Due to our redesign, all existing accounts require a password reset to access your account again.
Ready to explore 6,100+ projects and contribute to the community?
Reset Password Create Account
Happy Monitoring!