检查mysql主从同步结构中的从数据库服务器的状态-脚本shell

544323

主mysql: 192.168.1.10
从mysql: 192.168.1.20

[iyunv@ser2 ~]# vi check_slave.sh
#!/bin/bash
master=192.168.1.10
i=1
service mysqld status &>/dev/null
while [ true ]
do
echo $i
service mysqld status &>/dev/null
  if[ $? -ne 0 ];then
     echo "slave server is down!"
     exit
  fi
ping -c 3 $master &>/dev/null
  if[ $? -ne 0 ];then
      echo "physical link is disconnected!"
      exit
else
      grant=`mysql -h$master -uslave -ptarena -Bse 'show grants forslave@192.168.1.20'`
      grant_1="GRANT REPLICATION SLAVE ON *.* TO 'slave'@'192.168.1.20'IDENTIFIED BY PASSWORD '3907ff810e745021'"
       if [ "$grant" !="$grant_1" ];then
          echo "There is no grant for slave server!"
          exit
      fi
      stat_1=`mysql -Bse 'show slave status\G' | grep Slave_IO_Running | awk -F ":" '{ print $2}'`
      stat_2=`mysql -Bse 'show slave status\G' | grep Slave_SQL_Running | awk -F ":" '{ print $2}'`
      if [ $stat_1 != "Yes" ];then
         echo "IO progress has something wrong!"
         exit
      fi
      if [ $stat_2 != "Yes" ];then
         echo "SQL progress has something wrong !"
      exit
  fi
  leti++
done