mysql mon 的一个监控脚本，监控heartbeat

#!/bin/bash
trap 'echo  PROGRAM INTERRUPTED; exit 1'  INT
username=username
password=password
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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-681664/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/90618/viewspace-681664/