论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2009-04-24 16:10 |只看该作者 |倒序浏览

写得不好，大家拍砖

自己写了个shell去监控mysql跟ha的状态……

前景：
很多公司的mysql服务器（假设2台）之间都是用ha来做切换，可是ha只有在服务器down机跟ha 停掉的情况下才切换，而mysql down掉，服务器没down掉的时候不去切换，所以我写了这个脚本

说明：
msyql开启的是tcp 3306端口，ha开启的是udp 694端口

功能：
检测mysql跟ha的状态
1.当mysql 正常，ha正常，打印报告
2.当mysql正常，ha down掉，重启ha，启动成功，打印报告；启动失败发送邮件到管理员邮箱
3.当mysql down掉，而ha正常时，停掉ha，重启mysql，并发送邮件给管理员，当mysql重启成功，再启动ha，并发送邮件给管理员报告启动成功，重启不成功发送邮件报告重启失败
4.当msyql和ha都down掉，重启mysql跟ha，成功打印报告，失败发送邮件给管理员报告mysql跟ha都down掉
5.sleep 10==》10秒钟执行一次

#!/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