shell脚本检测mysql主从是否正常运行

vim aa.sh
#!/bin/bash
user="root"                       #mysql用户
password="123"	             #mysql登陆密码

function masterslave() {
list=(`mysql -u$user -p$password -e "show slave status \G"|egrep "Running|Behind"|awk -F: '{print $2}'`)     #显示IO ，SQL, 延时参数
if [ ${list[0]} = "Yes" -a ${list[1]} = "Yes" -a ${list[2]} -lt 30 ]
then echo "主从复制正常"
else echo "主从复制异常"
fi
}

function zong() {    #死循环
while true
do
   masterslave
   sleep 3   #延时3秒
done
}
zong