利用shell监控mysql

 
  一 监控MysqL主从复制状态图 
 

 
  二 监控MysqL主从复制状态 
 

   1、搭建主从复制环境 
 

   2、基于MysqL客户端连接，获取主从复制状态 
 

   MysqL>show slave status\G; 
 

   Slave_IO_Running-IO：线程是否有连接到主服务器上 
 

   Seconds_Behind_Master：主从同步的延时时间 
 

 
  三 MysqL主从复制状态函数编写 
 

   1 ############################################################# 
 

   2 # File Name: check_server.sh 
 

   3 # Author:cakin 
 

   4 # mail:cakin@qq.com 
 

   5 # Created Time: Sat 12 Aug 2017 12:40:07 PM CST 
 

   6 #============================================== 
 

   7 #!/bin/bash 
 

   8 Resettem=$(tput sgr0) 
 

   9 Nginxserver='http://192.168.0.107/Nginx_status' 
 

   10 MysqL_Slave_Server='192.168.0.107' 
 

   11 MysqL_User='rep' 
 

   12 MysqL_Pass='imooc' 
 

13

   14 Check_Nginx_Server() 
 

   15 { 
 

   16 Status_code=$(curl -m 5 -s -w %{http_code} ${Nginxserver} -o /dev/null) 
 

   17 if [ $Status_code -eq 000 -o $Status_code -gt 500 ];then 
 

   18 echo -e '\E[32m' "check http server error! Response status code is $" $Resettem $Status_code 
 

   19 else 
 

   20 Http_content=$(curl -s ${Nginxserver}) 
 

   21 echo -e '\E[32m' "check http server OK! \n" $Resettem $Http_content 
 

   22 fi 
 

   23 } 
 

   24 Check_MysqL_Server() 
 

   25 { 
 

   26 nc -w2 ${MysqL_Slave_Server} 3306 &>/dev/null 
 

   27 if [ $? -eq 0 ];then 
 

   28 MysqL -u$(MysqL_User) -p$(MysqL_Pass) -h$(MysqL_Slave_Server) -e "show slave status\G"|grep "Slave_IO_Running"|awk '{if($2!="YES"){print "Slave thread n ot running!";exit 1}}' 
 

   29 if [ $? -eq 0];then 
 

   30 MysqL -u$(MysqL_User) -p$(MysqL_Pass) -h$(MysqL_Slave_Server) -e "show slave status\G"|grep "Seconds_Behind_Master" 
 

   31 fi 
 

   32 else 
 

   33 echo "Connect ${MysqL_Slace_Server} is no OK!" 
 

   34 fi 
 

   35 } 
 

   36 Check_Nginx_Server 
 

   37 Check_MysqL_Server 
 

 
  四 运行结果 
 

原文链接：https://www.f2er.com/bash/390337.html

猜你在找的Bash相关文章