Mysql 主從複製監控指令碼

標籤：監控 主從複製 發郵件 io和sql線程

Mysql 主從複製監控指令碼，
監控IO和SQL線程。如果問題。發送郵件警示。

#!/bin/bash
#write by lijun
#Date 2014-08-12
#Description monitor the master pass the data to the slave
#=====================
mail="郵件地址"

#===================

#擷取slave io 進程和sql進程的狀態

b="`mysql -uroot -p$a -e "show slave status\G;"|grep -E ‘Slave_IO_Running|Slave_SQL_Running‘|awk -F: ‘{print $2}‘|grep -v ‘^$‘`"

#判斷兩個進程是否開啟

if [ b == "yes" ]
    then
        echo "IO thread and SQL thread are ‘yes‘"
    else
        yum install mail* -y  &>>/dev/null
        /etc/init.d/httpd restart
        echo
        echo "`date +%F-%T`主從複製錯誤，請進行檢查."|mail -s "IO and SQL are wrong" $mail
        echo
     if [ $? -eq 0 ]
         then
             echo "send mail ok"
         else
             echo "send mail failed..."
             echo
     fi
fi