Mysql master-slave Replication Monitoring script

Mysql master-slave Replication Monitoring script,
Monitor IO and SQL threads. If the problem. Send a mail alert.

#!/bin/bash
#write by Lijun
#Date 2014-08-12
#Description Monitor the master pass the data to the slave
#=====================
mail= "Email Address"

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

#获取slave the status of the IO process and the SQL process

b= "' Mysql-uroot-p$a-e" show slave status\g; "| Grep-e ' Slave_io_running| Slave_sql_running ' |awk-f: ' {print $ {} ' |grep-v ' ^$ ' "

#判断两个进程是否开启

if [b = = "Yes"]
Then
echo "IO thread and SQL thread is ' yes '"
Else
Yum Install mail*-y &>>/dev/null
/ETC/INIT.D/HTTPD restart
Echo
echo "' Date +%f-%t ' master-slave copy error, please check." | Mail-s "IO and SQL is wrong" $mail
Echo
If [$?-eq 0]
Then
echo "Send mail OK"
Else
echo "Send mail failed ..."
Echo
Fi
Fi