*/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
