检查MySQL的Slave是否正常

cyc1111

下午写了一个的检查MySQL REPLICATION的SLAVE是否正常的脚本，比较简单。　　如果想和CRONTAB一块运行，去掉Read部分即可。
　　1、脚本1通过MYSQL 命令 show status 来查看
　　[root@localhost ~]# cat slave_is_running
　　#!/bin/sh
　　#
　　# Created by david yeung
　　#
　　# To determine whether slave is running or not.
　　echo "Enter your Username"
　　read USERNAME
　　echo "Enter your password"
　　stty -echo
　　read PASSWD
　　stty echo
　　cd /usr/local/mysql/bin
　　RESULT=`./mysql -u$USERNAME -p$PASSWD -e 'show status like "Slave_running"' -ss | awk '{print $2}'`
　　if [ "$RESULT" == 'ON' ]
　　then
　　echo "Slave is running!" > /var/log/mysql_slave.log
　　else
　　echo "Slave is not running!"> /var/log/mysql_slave.log
　　fi
　　2、脚本2通过MYSQL命令 show slave status\G来实现
　　#!/bin/sh
　　#
　　# Created by david yeung
　　#
　　# To determine whether slave is running or not.
　　echo "Enter your Username"
　　read USERNAME
　　echo "Enter your password"
　　stty -echo
　　read PASSWD
　　stty echo
　　cd /usr/local/mysql/bin
　　RESULT=`./mysql -u$USERNAME -p$PASSWD -e 'show slave status\G' -ss| awk '{print $2}' | head -n 13 | tail -n2`
　　if [ "$RESULT" == 'Yes Yes' ]
　　then
　　echo "Slave is running!" > /var/log/mysql_slave.log
　　else
　　echo "Slave is not running!"> /var/log/mysql_slave.log
　　fi
　　3、测试一下
　　[root@localhost ~]# ./slave_is_running
　　Enter your Username
　　root
　　Enter your password
　　[root@localhost ~]# cat /var/log/mysql_slave.log
　　Slave is running!
　　我停掉SLAVE。
　　[root@localhost ~]# cat /var/log/mysql_slave.log
　　Slave is not running!