[MySQL] 巧用手机邮件来设置报警短信息

很早之前就喜欢用移动的139的手机邮件来设置nagios报警邮件，当时联通的手机邮件短信功能还不是特别成熟，我尝试了如下的一些用法，感觉还是非常方便的；139的手机邮配置比较简单，而且短信报警很快，曾经系统组的同事为这个问题投拆过，在这里我以用了5年多的邮通号为例，这个其实在http://mail.wo.com.cn/smsmail/index.html的“邮件到达通知”一项，我们按照如下图示设置：

#!/bin/bash
while :
do
status=`curl -s --head http://www.1paituan.com/index.jsp | awk '/HTTP/ {print $2}'`
if [ "$status" == "200" ]
then
   :
else
  echo "1paituan.com is critical" | mail -s "1paituan.com is critical.please check " 1309889xxxx@wo.com.cn
fi
sleep 5
done

nohup sh /root/monitor.sh &

#crontab time 00:10
#!/bin/bash
#check MySQL_Slave Status
#crontab time 00:10
MYSQLPORT=`netstat -na|grep "LISTEN"|grep "3306"|awk -F[:" "]+ '{print $4}'`
MYSQLIP=`ifconfig eth0|grep "inet addr" | awk -F[:" "]+ '{print $4}'`
IO_env=`echo $STATUS | grep IO | awk  ' {print $2}'`
SQL_env=`echo $STATUS | grep SQL | awk  '{print $2}'`
DATA=`date +"%y-%m-%d %H:%M:%S"`
if [ "$MYSQLPORT" == "3306" ]
then
  echo "mysql is running"
else
  echo $MYSQLIP mysql is down" | mail -s "warn!server: $MYSQLIP mysql is down" 1309889xxxx@wo.com.cn
fi
if [ "$IO_env" = "Yes" -a "$SQL_env" = "Yes" ]
then
  echo "Slave is running!"
else
echo "Slave is not running!" | mail -s "warn! $DATA $MYSQLIP MySQL Slave is not running" 1309889xxxx@wo.com.cn
fi

*/10 * * * * root sh /root/mysql_slave.sh