Script To Check If MySQL Master Master Replication Is Working Correctly
Do you like HowtoForge? Please consider to support us by becoming a subscriber.
Script To Check If MySQL Master Master Replication Is Working CorrectlyThis short article explains how you can use a short script to check whether your MySQL master master replication is working as expected or not. First add a user named "check" with the following mysql queries: CREATE USER 'check'@'localhost' IDENTIFIED BY 'YOURPASSWORD'; GRANT SUPER , REPLICATION CLIENT ON * . * TO 'check'@'localhost' IDENTIFIED BY 'YOURPASSWORD' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; Then add this bash script to your /root directory. Add it to your crontab if needed : #!/bin/bash PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin ###check if already notified### cd /root if [ -f slave_problem.txt ]; then exit 1; fi ###Check if slave running### ( echo "show slave status \G;" ) | mysql -u check -pYOURPASSWORD 2>&1 | grep "Slave_IO_Running: No" if [ "$?" -ne "1" ]; then echo "Replication failed" > /root/slave_problem.txt fi ###Send notification if replication down### cd /root if [ -f slave_problem.txt ]; then mail -s "Replication problem" admin@example.com < /root/slave_problem.txt fi
|
Sponsored Links: Request a Novell/Microsoft migration






Recent comments
19 hours 1 min ago
19 hours 59 min ago
20 hours 11 min ago
1 day 2 hours ago
1 day 4 hours ago
1 day 5 hours ago
1 day 9 hours ago
1 day 10 hours ago
1 day 11 hours ago
1 day 13 hours ago