监控mysql主从状态邮件报警脚本

#!/bin/bash
#define mysql variable
mysql_user="root"
mysql_pass=“123456"
email_addr="tuzi@163.com"
    
mysql_status=`netstat -nl | awk 'NR>2{if ($4 ~ /.*:3306/) {print "666";exit 0}}'`
if [ "$mysql_status" == "666" ]; then
            slave_status=`mysql -u${mysql_user} -p${mysql_pass} -e"show slave status\G" | grep "Running" | awk '{if ($2 != "Yes") {print "No";exit 1}}'`
            if [ "$slave_status" == "No" ];then
                    echo "slave is not working!"
                    echo "Slave is not working!" | mail -s "Warn!MySQL Slave is not working" ${email_addr}
                    #touch /tmp/slave
            else
                    echo "slave is working."
                    #[ -f "/tmp/slave" ] && rm -f /tmp/slave
            fi
           # [ -f "/tmp/mysql_down" ] && rm -f /tmp/mysql_down
    else
             echo "Mysql Server is down!" | mail -s "Warn!MySQL server is down!" ${email_addr}
           # touch /tmp/mysql_down

    fi

如果把#注释掉，这个脚本只发一次邮件报警。