mysql 主从复制的监控脚本

guzan

HOSTNAME=`hostname`

MYSQLPORT=`netstat -na | grep "LISTEN" | grep "3306"|cut -d: -f2|awk '{print $1}'`

MYSQLIP=`/sbin/ifconfig eth0 | grep "inet addr" | cut -d: -f2 | awk '{print $1}'`

STATUS=`/usr/local/mysql/bin/mysql -u root -pbxd123  -e "show slave status\G"| grep Running`

IO_env=`echo $STATUS | grep IO | awk -F " " '{print $2}'`

SQL_env=`echo $STATUS | grep IO | awk -F " " '{print $4}'`

IP=`/sbin/ifconfig eth0 | grep 'inet addr' | cut -d: -f2 | awk '{ print $1}'`

if [ "$MYSQLPORT" -eq "3306" ]

then

   echo "mysql is running"

else

   echo "mysql is down"

if [ "$IO_env" == "Yes" ] && [ "$SQL_env" == "Yes" ]

then

   echo "Slave is running!"

else

   echo "$DATA" >> /var/log/check_mysql_slave.log

   echo "Slave is not running!" >> /var/log/check_mysql_slave.log

devil20

为中华而努力读书!一包中华好多钱啊~~~

samdung

学习了，不错，讲的太有道理了

龍子

爱她，就请为她做无痛人流手术!

骞没蕴

男人靠的住，母猪能上树!

2004

有事秘书干，没事干秘书!

gaohan

俺从不写措字，但俺写通假字!