MySQL：shell手动监控db存活及slave状态

1、所有db信息

all_db.txt

192.168.x.x     3306 S
192.168.x.x     3306 M

2、检查脚本

check_all_db.sh

#!/bin/bash

user='' 
password=''
errFile=/tmp/sms_mon_db.txt

call(){
for phone in 186xxxx
do
    curl "短信接口：{$ip}+{$port}+{$stat}"
    echo "[ `date +"%Y-%m-%d %H:%M:%S"` ] {$ip}+{$port}+{$stat}"| tee -a $errFile
done
}

dbcount=`cat /shell/all_db.txt |grep -v '^#'|grep -v '^$'| wc -l` 

#检查数据库是否存活
for((i=1;i<=$dbcount;i++))
do
  ip=`cat /shell/all_db.txt |grep -v '^#'|grep -v '^$'|awk -F" " '{print $1}'|sed -n "$i p"`
  port=`cat /shell/all_db.txt |grep -v '^#'|grep -v '^$'|awk -F" " '{print $2}'|sed -n "$i p"`
  dbstat=`/usr/local/mysql/bin/mysqladmin -u$user -p$password -h$ip -P$port ping |grep alive|wc -l`
  stat='down'

  if [ $dbstat -ne 1 ]
        then call
  fi
done

#检查slave状态
for((i=1;i<=$dbcount;i++))
do
  ip=`cat /shell/all_db.txt |grep -v '^#'|grep -v '^$'|awk -F" " '{print $1}'|sed -n "$i p"`
  port=`cat /shell/all_db.txt |grep -v '^#'|grep -v '^$'|awk -F" " '{print $2}'|sed -n "$i p"`
  is_slave=`cat /shell/all_db.txt |grep -v '^#'|grep -v '^$'|awk -F" " '{print $3}'|sed -n "$i p"`
  
  if [ $is_slave = 'S' ]
    then
      status_array=($(/usr/local/mysql/bin/mysql -u$user -p$password -h$ip -P$port -e "show slave status\G"|grep Running|awk -F : '{print $2}'))
      stat='slave+error'
  
      if [ "${status_array[0]}" != "Yes" ] || [ "${status_array[1]}" != "Yes" ]
      then call
      fi
  fi
done