shell 检测mysql 主从状态

在从上执行：

[root@master ~]# cat check_master_slave_status.sh
#!/bin/bash
check(){
list=($(mysql -uroot -p123456 -S /tmp/mysql.sock2 -e “show slave status\G;” 2>/dev/null |egrep “Running|Behind” |head -n3|awk -F ‘:’ ‘{print $2}’))
#echo ${list[@]}
if [ ${list[0]} == “Yes” -a ${list[1]} == “Yes” -a $list[2]!="NULL"];thenech{o}^{\prime }${list[0]}’ "is $list[0]"ech{o}^{\prime }${list[1]}’ "is $list[1]"ech{o}^{\prime }${list[2]}’ “is ${list[2]}”
echo “mysql slave is ok!”
else
#echo “”
mail -s “mysql slave is not ok” hehe@163.com
fi
}
while :
do
check
sleep 3
done
yum -y install mailx 安装mail客户端

vim /etc/mail.rc
set from=34xx@qq.com #对方收到邮件时显示的发件人
set smtp=smtp.qq.com
set smtp-auth-user=34xx@qq.com #发邮件的用户名
set smtp-auth-password=jponzubigyxxbiaj #这是授权码！不是密码！
set smtp-auth=login

mail -s “你的邮件主题” 1111@qq.com < /tmp/result.txt (邮件内容)

echo “hehe”|mail -s ‘主题’ 11@qq.com