检测 MySQL 是否宕掉，如果宕掉则启动（转）

taony76

如果你的 MySQL 经常宕机，可以用这个脚本来实现宕机后自动启动，把它加到 crontab 里执行即可。
详细介绍请看 http://www.codeproject.com/Artic ... Uptime-Check-Script

mysql.sh

1. #!/bin/bash
   
2. 
   
3. result=`/usr/bin/mysqladmin ping`
   
4. expected='mysqld is alive'
   
5. 
   
6. if [[ "$result" != "$expected" ]]
   
7. then
   
8. echo "It's dead - restart mysql"
   
9. 
   
10. # email subject
    
11. SUBJECT="[MYSQL ERROR] - Attempting to restart service"
    
12. 
    
13. # Email To ?
    
14. EMAIL="info@endyourif.com"
    
15. 
    
16. # Email text/message
    
17. EMAILMESSAGE="/tmp/emailmessage.txt"
    
18. echo "$result was received"> $EMAILMESSAGE
    
19. echo "when we were expected $expected" >>$EMAILMESSAGE
    
20. # send an email using /bin/mail
    
21. mail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE
    
22. 
    
23. sudo /etc/init.d/mysql restart
    
24. fi

复制代码

seesea2517

感觉mysqld_safe有点这个功能的样子。