一个简单的mysql服务检测启动脚本

786yr

目的: 监测mysql的存活状态，一旦监测到mysql down掉，重新启动mysql.


脚本内容:

1 2 3 4 5 6 7

/usr/local/mysql/bin/mysqladmin -uroot -psharpower ping > /dev/null 2>&1 if [ $? -ne 0 ] then         /etc/init.d/mysql.server restart >/dev/null         echo "`/bin/date '+%Y%m%d %H:%M:%S'`  mysql is restart " >> /root/scripts/mysql_run.log fi

利用crontab定时任务来执行脚本:

1 2	[iyunv@Master_mysql scripts]# crontab -l */2 * * * * /bin/bash /root/scripts/mysql_ping.sh

手动模拟关闭msyql,然后间隔2分钟，查看cron执行日志"/var/log/cron"和脚本执行日
志"/root/scripts/mysql_run.log"

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

#cron执行日志 [iyunv@Master_mysql scripts]# tail -n 10 /var/log/cron Jul 22 16:27:01 Master_mysql crontab[5818]: (root) BEGIN EDIT (root) Jul 22 16:27:07 Master_mysql crontab[5818]: (root) REPLACE (root) Jul 22 16:27:07 Master_mysql crontab[5818]: (root) END EDIT (root) Jul 22 16:27:38 Master_mysql crontab[5849]: (root) LIST (root) Jul 22 16:28:01 Master_mysql crond[3103]: (root) RELOAD (cron/root) Jul 22 16:28:01 Master_mysql crond[5853]: (root) CMD (/bin/bash /root/scripts/mysql_ping.sh) Jul 22 16:29:59 Master_mysql crontab[6138]: (root) LIST (root) Jul 22 16:30:01 Master_mysql crond[6140]: (root) CMD (/bin/bash /root/scripts/mysql_ping.sh) Jul 22 16:32:01 Master_mysql crond[6394]: (root) CMD (/bin/bash /root/scripts/mysql_ping.sh) Jul 22 16:34:01 Master_mysql crond[6429]: (root) CMD (/bin/bash /root/scripts/mysql_ping.sh) #脚本执行日志 [iyunv@Master_mysql scripts]# cat mysql_run.log 20140722 16:28:14  mysql is restart 20140722 16:30:09  mysql is restart 20140722 16:34:08  mysql is restart

这样就可以实现mysql停服时自动启动了.