标签归档:Slave Status

Check Replication Slave Status

This script produces no output when replication slave is running normally. If either IO or SQL threads are not running it will print a message indicating so and the “Last Error:” I typically set it up on a 2minute cron. It has some logic in place to avoid repeat e-mailing from CRON when down status is found. It will wait 15 minutes before producing the next message. You can also disable the scripts checking by changing the “active” variable to “no”. This allows users without direct access to cron to controll the script. This script assumes that a ~/.my.cnf will be in place for authentication. 继续阅读