mysql shell 状态_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" ]; then

echo '${list[0]}' "is ${list[0]}"

echo '${list[1]}' "is ${list[1]}"

echo '${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