Linux下监听mysql是否宕机

监听mysql是否挂掉

1. 监听脚本 listenMysql.sh
   

    
   
       pgrep mysqld &> /software/mysql/null 
   
       if [ $? -gt 0 ] 
   
       then 
   
       echo "date mysql is stop" >> /software/mysql/listenMysql.log 
   
       service mysql start 
   
       else 
   
       echo "date mysql running" >> /software/mysql/listenMysql.log 
   
       fi 
   
   

2. 安装crontab定时启动
3. 设置crontab开机启动ntsysv chkconfig –level 35 crond on
4. yum install -y ntsysv

5. 添加定时脚本crontab -e

   
       SHELL=/bin/bash
       PATH=/sbin:/bin:/usr/sbin:/usr/bin
       MAILTO=root
       HOME=/
   
   */1 * * * * /software/mysql/listenMysql.sh
   
   
   

6. 查看定时任务crontab -l
7. 重启定时service crond restart