哥的处男作shell

判断MYSQL ab是否活着并且能否保持通信

 #!/bin/bash

a=`(mysql -e "show slave status \G" | grep "IO_Running" | awk -F: '{print $2}')`

b=`(mysql -e "show slave status \G" | grep "SQL_Running" | awk -F: '{print $2}')`

if [ $a != $b  ] ;then

 

       echo "mysql err"

        exit 2

  else

       echo "mysql ok"

        exit 0

   fi

 

 

转载于:https://blog.51cto.com/6241792/1085906