首页 > 数据库技术 > 详细

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

时间:2016-09-21 23:29:08      阅读:237      评论:0      收藏:0      [点我收藏+]

检查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


本文出自 “Dave-技术博客” 博客,请务必保留此出处http://davewang.blog.51cto.com/6974997/1855106

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

原文:http://davewang.blog.51cto.com/6974997/1855106

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!