在工作中需要关注mysql主从是否同步,如果利用脚本来实现呢?mysql版本mysql5.7

#!/bin/bash
#create by chenzm
mysql_cmd=`/usr/local/mysql/bin/mysql -uroot -pmima -hlocalhost -e'show slave status\G;' | egrep 'Running:'`
time=`date +"%Y-%m-%d %H:%M:%S"`
echo $mysql_cmd
Slave_IO_Running=`echo $mysql_cmd | awk '{print $2}'`
Slave_SQL_Running=`echo $mysql_cmd | awk '{print $4}'`
echo ${Slave_IO_Running}
echo ${Slave_SQL_Running}
flag=1
if [ "${Slave_IO_Running}" = "Yes" ] && [ "${Slave_SQL_Running}" = "Yes" ];then
echo "$time mysql slave is ok" >> /opt/mysqljc-ok.log
flag=1
else
echo "$time mysql slave hava some problem." >> /opt/mysqljc-error.log
flag=0
fi
echo $flag > /opt/flag.log