mysql监控通用接口_linxu中shell脚本监控mysql主从并调用webservice接口发送短信（粘贴即可使用，亲测）...

一、具体操作如下

1.首先在桌面新建.sh文件使用Notepad++打开

里面内容如下：

#!/bin/bash

echo "===================mysql从库监控发送短信脚本start======================="

MYSQLPORT=`netstat -na|grep "LISTEN"|grep "3306"|awk -F[:" "]+ '{print $4}'`

STATUS=$(mysql -uroot -proot -S /var/lib/mysql/mysql.sock -e "show slave status\G" | grep -i "running")

IO_state=`echo $STATUS | grep Slave_IO_Running | awk '{print $2}'`

SQL_state=`echo $STATUS | grep Slave_SQL_Running: | awk '{print $4}'`

DATA=`date +"%y-%m-%d %H:%M:%S"`

function checkMysqlStatus(){

if [ "$MYSQLPORT" == "3306" ]

then

mysql -uroot -proot --connect_timeout=5 -e "show databases;" &>/dev/null 2>&1

if [ $? -ne 0 ]

then

echo "MySQL_Slave_从库ip is down"

curl -H 'Content-type: application/xml' -d '此处填写webservice报文' webservice地址

else

echo "MySQL_Slave is running!"

curl -H 'Content-type: application/xml' -d '此处填写webservice报文' webservice地址

fi

else

echo "MySQL_SLAVE_从库ip

标签：STATUS,shell,Slave,webservice,echo,mysql,grep

来源： https://blog.csdn.net/zhaoydzhaoyd/article/details/97773320