亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区
Chinaunix
標(biāo)題:
監(jiān)控mysql跟heartbeat的腳本
[打印本頁(yè)]
作者:
gyl4802959
時(shí)間:
2009-04-24 16:10
標(biāo)題:
監(jiān)控mysql跟heartbeat的腳本
寫(xiě)得不好,大家拍磚
自己寫(xiě)了個(gè)shell去監(jiān)控mysql跟ha的狀態(tài)……
前景:
很多公司的mysql服務(wù)器(假設(shè)2臺(tái))之間都是用ha來(lái)做切換,可是ha只有在服務(wù)器down機(jī)跟ha 停掉的情況下才切換,而mysql down掉,服務(wù)器沒(méi)down掉的時(shí)候不去切換,所以我寫(xiě)了這個(gè)腳本
說(shuō)明:
msyql開(kāi)啟的是tcp 3306端口,ha開(kāi)啟的是udp 694端口
功能:
檢測(cè)mysql跟ha的狀態(tài)
1.當(dāng)mysql 正常,ha正常,打印報(bào)告
2.當(dāng)mysql正常,ha down掉,重啟ha,啟動(dòng)成功,打印報(bào)告;啟動(dòng)失敗發(fā)送郵件到管理員郵箱
3.當(dāng)mysql down掉,而ha正常時(shí),停掉ha,重啟mysql,并發(fā)送郵件給管理員,當(dāng)mysql重啟成功,再啟動(dòng)ha,并發(fā)送郵件給管理員報(bào)告啟動(dòng)成功,重啟不成功發(fā)送郵件報(bào)告重啟失敗
4.當(dāng)msyql和ha都down掉,重啟mysql跟ha,成功打印報(bào)告,失敗發(fā)送郵件給管理員報(bào)告mysql跟ha都down掉
5.sleep 10==》10秒鐘執(zhí)行一次
#!/bin/sh
cat << EOF
+-----------------------------------------------------------------------------+
| === Welcome to LinuxTone=== |
|---------------------[url]http://www.linuxtone.org[/url]-------------------------|
+-------------------------------By:hamgua--------------------------------+
EOF
MYPORT=`netstat -na|grep "tcp"|grep "3306"|awk -F[:" "]+ '{print $5}'`
HAPORT=`netstat -na|grep "udp"|grep "694"|awk -F[:" "]+ '{print $5}'`
PING=`ping -c 5 [url]www.linuxtone.org[/url]|awk -F, '/packets/{print $3}'|cut -c 2-|awk '{print $1}'`
DB1IP=`ifconfig eth0|awk '/inet/{print $2}'|cut -c 6-`
#DB2IP is your next mysqlserver and haserver IP,According to it own IP to fill
while [ "$PING" != "100\%" ]
do
touch /var/log/mysql_ha.log
if [ "$MYPORT" == "3306"];then
if [ "$HAPORT" == "694" ];then
echo "$DB1IPmysql and ha is running......"
else
echo "$DB1IPmysql is running,but ha is down,start ha now"
/etc/rc.d/init.d/heartbeat start
if [ "$HAPORT" == "694"];then
echo "$DB1IPha start successful,mysql and ha all running......"
else
echo "$DB1IPha is down,let (DB2IP) to take over mysql,please start ha now!" > /var/log/mysql_ha.log
mail -s "mysql and ha warning!server: $DB1IP ha is down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
fi
fi
else
if [ "$HAPORT" == "694" ];then
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
mail -s "mysql and ha warning!server: $DB1IP mysql is down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
/etc/rc.d/init.d/heartbeat stop
/etc/rc.d/init.d/mysqld start
if [ "$MYPORT" == "3306"];then
/etc/rc.d/init.d/heartbeat start
echo "$DB1IP$mysql restart successful,now mysql and ha all running......"
fi
else
echo "$DB1IPmysql and ha all down,first restart msyql,when mysql is run,restart ha"
/etc/rc.d/init.d/mysqld start
if [ "$MYPORT" == "3306"];then
/etc/rc.d/init.d/heartbeat start
if [ "$HAPORT" == "694" ];then
echo "$DB1IPmysql and ha all running......"
else
echo "$DB1IPmysql is running,ha is down,please restart ha" > /var/log/mysql_ha.log
mail -s "mysql and ha warning!server: $DB1IP ha is down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
fi
else
echo "$DB1IPmysql and ha all down,let (DB2IP) to take over mysql,please restart mysql" > /var/log/mysql_ha.log
mail -s "mysql and ha warning!server: $DB1IP mysql and ha all down" [email]hamgua@gmail.com[/email] < /var/log/mysql_ha.log
fi
fi
fi
sleep 10
done
復(fù)制代碼
[
本帖最后由 gyl4802959 于 2009-4-24 16:11 編輯
]
作者:
我是DBA
時(shí)間:
2009-04-24 16:12
標(biāo)題:
回復(fù) #1 gyl4802959 的帖子
寫(xiě)得很好,很強(qiáng)大。
作者:
gyl4802959
時(shí)間:
2009-04-24 16:16
標(biāo)題:
回復(fù) #2 我是DBA 的帖子
多謝抬舉,但我知道很繁瑣,剛學(xué)
作者:
jelver
時(shí)間:
2009-04-24 18:03
不錯(cuò),呵呵,學(xué)習(xí)了
作者:
楓影誰(shuí)用了
時(shí)間:
2009-06-09 11:56
呵呵。用用ha crm方式。就不需要這個(gè)腳本了。
作者:
我是8戒
時(shí)間:
2009-06-09 13:06
標(biāo)題:
不錯(cuò),呵呵,學(xué)習(xí)了
不錯(cuò),呵呵,學(xué)習(xí)了
作者:
shgxie
時(shí)間:
2010-09-27 14:56
值得信賴(lài)的東西
作者:
xindi10631
時(shí)間:
2010-09-27 15:22
不錯(cuò) 就是還有些看不懂 正在努力中!
作者:
expert1
時(shí)間:
2010-09-27 15:30
hehe
作者:
BangBull
時(shí)間:
2010-09-27 16:27
回復(fù)
3#
gyl4802959
有個(gè)要說(shuō)的是, 某些時(shí)候 mysql 的端口也是開(kāi)著的,但服務(wù)是不可用的 ; 最好在腳本中加入 mysql 查詢(xún),有正確返回結(jié)果,這樣才算是服務(wù)可用的,
作者:
expert1
時(shí)間:
2010-09-27 16:37
三輪哥正解,哈哈
歡迎光臨 Chinaunix (http://www.72891.cn/)
Powered by Discuz! X3.2