[root@idc-d-1545 hbmon]# cat mon.sh
#!/bin/bash
trap 'echo PROGRAM INTERRUPTED; exit 1' INT
username=hbuser
password=hbuserpwd
n=0
echo >mysqlmon.log
while true;
do
if /usr/local/mysql/bin/mysql -u$username -p$password -e "use test" >&/dev/null;
then
echo `date +"%Y-%m-%d %H:%M:%S"` mysqld is alive! >>mysqlmon.log
n=0
else
echo `date +"%Y-%m-%d %H:%M:%S"` mysqld cannot be connected! >>mysqlmon.log
n=$[n + 1]
if [ $n -eq 3 ] ; then
service heartbeat stop
echo `date +"%Y-%m-%d %H:%M:%S"` mysqld switched to backup! >>mysqlmon.log
break
fi
fi
sleep 10
done
[root@idc-d-1545 hbmon]#
#!/bin/bash
trap 'echo PROGRAM INTERRUPTED; exit 1' INT
username=hbuser
password=hbuserpwd
n=0
echo >mysqlmon.log
while true;
do
if /usr/local/mysql/bin/mysql -u$username -p$password -e "use test" >&/dev/null;
then
echo `date +"%Y-%m-%d %H:%M:%S"` mysqld is alive! >>mysqlmon.log
n=0
else
echo `date +"%Y-%m-%d %H:%M:%S"` mysqld cannot be connected! >>mysqlmon.log
n=$[n + 1]
if [ $n -eq 3 ] ; then
service heartbeat stop
echo `date +"%Y-%m-%d %H:%M:%S"` mysqld switched to backup! >>mysqlmon.log
break
fi
fi
sleep 10
done
[root@idc-d-1545 hbmon]#
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-675708/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-675708/