Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
MySQL Replication Deadlock Recovery
Current Version
1.0
Last Release Date
2012-02-06
Owner
Website
License
BSD
Hits
76409
Files:
File | Description |
---|---|
MySQL-Replication-DeadLock-Recovery.sh | MySQL Replication Deadlock Recovery Plugin |
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.
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)
byhasegeli, February 7, 2012
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
[1] http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_slave-skip-errors