MySQL定時檢查是否宕機並郵件通知

標籤：

我們有時候需要一些檢查MySQL是否宕機，如果宕機了應自動重新啟動應用並通知營運人員！
此指令碼用來簡單的實現MySQL宕機後自動重啟並郵件通知營運，此為SHELL指令碼，當然也有一些朋友喜歡用Python之類的實現，其原理是一樣的！
這兒主要用到的是命令是mysqladmin ping

#!/bin/bash# result=`/usr/bin/mysqladmin -u user -ppassword ping`result=`/usr/bin/mysqladmin ping`expected=‘mysqld is alive‘if [[ "$result" != "$expected" ]]thenecho "It‘s dead - restart mysql"# email subjectSUBJECT="[MYSQL ERROR] - Attempting to restart service"# Email To ?EMAIL="[email protected]"# Email text/messageEMAILMESSAGE="/tmp/emailmessage.txt"echo "$result was received"> $EMAILMESSAGEecho "when we were expected $expected" >>$EMAILMESSAGE# send an email using /bin/mailmail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGEsudo /etc/init.d/mysql restartfi

mysqladmin ping 如果mysql配置了有密碼，就用 mysqladmin -u user -ppassword
然後定時執行這個指令碼

*/5 * * * * /<path_to>/scripts/mysql.sh

MySQL定時檢查是否宕機並郵件通知