shell脚本检测mysql主从复制异常

#!/bin/bash
user="sgd"  ##用为mysql主从复制时授权的用户
password="123" ##授权用户是设立的密码
host='192.168.163.128' 主机地址
mycmd="mysql -u$user -p$password -h $host"
chkdb(){
list=(`$mycmd  -e"show slavestatus\G"|egrep"Running|Behind"|awk -F : '{print$2}'`)
if [ ${list[0]} = "Yes" -a ${list[1]} = "Yes" -a ${list[2]} -lt 120 ]
then
        echo "主从复制正常"
else
         echo "主从复制异常"
fi
}
chkdb
~                                                                                                                                                                         
~