mysql 结果发送邮件_监控mysql状态发送邮件

*/10 * * * *  /shell/mysql_status.sh > /dev/null 2>&1

#!/bin/bash

port55=`/usr/sbin/lsof -i:3355 | wc -l`

if test $port55 != 0

then

echo "$(date +%F-%T) xxx.xxx.xxx.xxx mysql status runing!!" >> /shell/mysql_status.log

else

echo "$(date +%F-%T) xxx.xxx.xxx.xxx mysql status stop" >> /shell/mysql_status.log

echo "$(date +%F-%T) xxx.xxx.xxx.xxx mysql status stop" > /shell/mysql_status_err.log

/bin/mail -s "mysql55" xxxxx@qq.com < /shell/mysql_status_err.log

fi

declare -a sync55

sync55=($(/usr/local/mysql5/bin/mysql -S /tmp/mysql55.sock -uroot -xxxxx -e 'show slave status\G' | grep "Running" | awk '{print $2}'))

if [ "${sync55[0]}" = "Yes" -a "${sync55[1]}" = "Yes" ]

then

echo "$(date +%F-%T) xxx.xxx.xxx.xxx msyql synchronous security" >> /shell/mysql_status.log

else

echo "$(date +%F-%T) xxx.xxx.xxx.xxx msyql synchronous failure" >> /shell/mysql_status.log

echo "$(date +%F-%T) xxx.xxx.xxx.xxx msyql synchronous failure" > /shell/mysql_status_err.log

/bin/mail -s "mysql55" xxxxx@qq.com < /shell/mysql_status_err.log

fi

for i in 31 32 33 36;

do

port=`/usr/sbin/lsof -i:33$i | wc -l`

if test $port != 0

then

echo "$(date +%F-%T) 192.168.180.$i mysql status runing!!" >> /shell/mysql_status.log

else

echo "$(date +%F-%T) 192.168.180.$i mysql status stop" >> /shell/mysql_status.log

echo "$(date +%F-%T) 192.168.180.$i mysql status stop" > /shell/mysql_status_err.log

/bin/mail -s "mysql$i" xxxxxxxxx@qq.com < /shell/mysql_status_err.log

fi

declare -a sync

sync=($(/usr/local/mysql5/bin/mysql -S /tmp/mysql$i.sock -e 'show slave status\G' | grep "Running" | awk '{print $2}'))

if [ "${sync[0]}" = "Yes" -a "${sync[1]}" = "Yes" ]

then

echo "$(date +%F-%T) 192.168.180.$i msyql synchronous security" >> /shell/mysql_status.log

else

echo "$(date +%F-%T) 192.168.180.$i msyql synchronous failure" >> /shell/mysql_status.log

echo "$(date +%F-%T) 192.168.180.$i msyql synchronous failure" > /shell/mysql_status_err.log

/bin/mail -s "mysql$i" xxxxxx@qq.com < /shell/mysql_status_err.log          fi done