检查mysql主从同步结构（一主一从）中的从数据库服务器的状态 

        （ip授权、从服务器和IO是否正常、从mysql进程是否正常）

主mysql: 192.168.1.10

从mysql: 192.168.1.20


[root@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