Linux下检查MySQL的Slave是否正常

写了一个在Linux下检查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/binRESULT=`./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
fi2、脚本2通过MYSQL命令 show slave statusG来实现#！/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/binRESULT=`./mysql -u$USERNAME -p$PASSWD -e "show slave statusG" -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
fi3、测试一下[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！ weblogic在Linux系统下配置数据源Ubuntu下MySQL的手工安装相关资讯 linux mysql

Linux下MySQL的简单操作笔记（08/12/2015 10:50:28）
Linux下MySQL报Table "xxx" doesn" （11/22/2014 07:37:47）
Linux下解决MySQL无法远程连接问题（11/14/2013 07:18:33）

Linux开启MySQL远程连接（11/22/2014 07:40:48）
Linux系统MySQL数据库远程设置（01/10/2014 09:35:35）
Linux网站架构系列之MySQL----部署（11/06/2013 20:21:28）

本文评论查看全部评论（0）