監(jiān)控mysql跟heartbeat的腳本

gyl4802959

寫得不好，大家拍磚

自己寫了個shell去監(jiān)控mysql跟ha的狀態(tài)……

前景：
很多公司的mysql服務(wù)器（假設(shè)2臺）之間都是用ha來做切換，可是ha只有在服務(wù)器down機跟ha 停掉的情況下才切換，而mysql down掉，服務(wù)器沒down掉的時候不去切換，所以我寫了這個腳本

說明：
msyql開啟的是tcp 3306端口，ha開啟的是udp 694端口

功能：
檢測mysql跟ha的狀態(tài)
1.當mysql 正常，ha正常，打印報告
2.當mysql正常，ha down掉，重啟ha，啟動成功，打印報告；啟動失敗發(fā)送郵件到管理員郵箱
3.當mysql down掉，而ha正常時，停掉ha，重啟mysql，并發(fā)送郵件給管理員，當mysql重啟成功，再啟動ha，并發(fā)送郵件給管理員報告啟動成功，重啟不成功發(fā)送郵件報告重啟失敗
4.當msyql和ha都down掉，重啟mysql跟ha，成功打印報告，失敗發(fā)送郵件給管理員報告mysql跟ha都down掉
5.sleep 10==》10秒鐘執(zhí)行一次

1. #!/bin/sh
   
2. cat << EOF
   
3. +-----------------------------------------------------------------------------+
   
4. |                      === Welcome to LinuxTone===                          |
   
5. |---------------------[url]http://www.linuxtone.org[/url]-------------------------|
   
6. +-------------------------------By:hamgua--------------------------------+
   
7. EOF
   
8. 
   
9. MYPORT=`netstat -na|grep "tcp"|grep "3306"|awk -F[:" "]+ '{print $5}'`
   
10. HAPORT=`netstat -na|grep "udp"|grep "694"|awk -F[:" "]+ '{print $5}'`
    
11. PING=`ping -c 5 [url]www.linuxtone.org[/url]|awk -F, '/packets/{print $3}'|cut -c 2-|awk '{print $1}'`
    
12. DB1IP=`ifconfig eth0|awk '/inet/{print $2}'|cut -c 6-`
    
13. #DB2IP is your next mysqlserver and haserver IP,According to it own IP to fill
    
14. 
    
15. while [ "$PING" != "100\%" ]
    
16. do
    
17.   touch /var/log/mysql_ha.log
    
18.   if [ "$MYPORT" == "3306"];then
    
19.      if [ "$HAPORT" == "694" ];then
    
20.         echo "$DB1IPmysql and ha is running......"
    
21.      else
    
22.          echo "$DB1IPmysql is running,but ha is down,start ha now"
    
23.          /etc/rc.d/init.d/heartbeat start
    
24.     if [ "$HAPORT" == "694"];then
    
25.       echo "$DB1IPha start successful,mysql and ha all running......"
    
26.     else
    
27.       echo "$DB1IPha is down,let (DB2IP) to take over mysql,please start ha now!" > /var/log/mysql_ha.log
    
28.       mail -s "mysql and ha warning!server: $DB1IP  ha is down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
    
29.         fi
    
30.      fi
    
31.   else
    
32.      if [ "$HAPORT" == "694" ];then
    
33.          echo "$DB1IP mysql is down,but ha is runing,now shutdown ha,let (DB2IP) to take over mysql,then restart mysql....." > /var/log/mysql_ha.log
    
34.      mail -s "mysql and ha warning!server: $DB1IP  mysql is down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
    
35.          /etc/rc.d/init.d/heartbeat stop
    
36.          /etc/rc.d/init.d/mysqld start
    
37.         if [ "$MYPORT" == "3306"];then
    
38.          /etc/rc.d/init.d/heartbeat start
    
39.      echo "$DB1IP$mysql restart successful,now mysql and ha all running......"
    
40.         fi
    
41.      else
    
42.          echo "$DB1IPmysql and ha all down,first restart msyql,when mysql is run,restart ha"
    
43.          /etc/rc.d/init.d/mysqld start
    
44.         if [ "$MYPORT" == "3306"];then
    
45.              /etc/rc.d/init.d/heartbeat start
    
46.           if [ "$HAPORT" == "694" ];then
    
47.             echo "$DB1IPmysql and ha all running......"
    
48.           else
    
49.             echo "$DB1IPmysql is running,ha is down,please restart ha" > /var/log/mysql_ha.log
    
50.             mail -s "mysql and ha warning!server: $DB1IP ha is down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
    
51.           fi
    
52.     else
    
53.          echo "$DB1IPmysql and ha all down,let (DB2IP) to take over mysql,please restart mysql" > /var/log/mysql_ha.log
    
54.          mail -s "mysql and ha warning!server: $DB1IP  mysql and ha all down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
    
55.         fi
    
56.      fi
    
57.    fi
    
58. sleep 10
    
59. done
    

復(fù)制代碼

[ 本帖最后由 gyl4802959 于 2009-4-24 16:11 編輯 ]

我是DBA

寫得很好，很強大。

gyl4802959

多謝抬舉，但我知道很繁瑣，剛學

jelver

不錯，呵呵，學習了

楓影誰用了

呵呵。用用ha crm方式。就不需要這個腳本了。

我是8戒

不錯，呵呵，學習了

shgxie

值得信賴的東西

xindi10631

不錯 就是還有些看不懂  正在努力中！

expert1

hehe

BangBull

回復(fù) 3# gyl4802959


    有個要說的是， 某些時候 mysql  的端口也是開著的，但服務(wù)是不可用的 ; 最好在腳本中加入 mysql 查詢，有正確返回結(jié)果，這樣才算是服務(wù)可用的，