zabbix获取主从同步状态的shell

#!/bin/sh
#Desc：用于获取主从同步信息，判断主从是否出现异常，然后提交给zabbix
#Date: 2017-07-08
#by：LYM

USER="user"
PASSWD="passwd"
NAME=$1

function IO {
    Slave_IO_Running=`mysql -u $USER -p$PASSWD -e "show slave status\G;" 2> /dev/null |grep Slave_IO_Running |awk '{print $2}'`
    if [ $Slave_IO_Running == "Yes" ];then
        echo 0
    else
        echo 1
    fi
}

function SQL {
    Slave_SQL_Running=`mysql -u $USER -p$PASSWD -e "show slave status\G;" 2> /dev/null |grep Slave_SQL_Running: |awk '{print $2}'`
    if [ $Slave_SQL_Running == "Yes" ];then
        echo 0
    else
        echo 1
    fi

}

case $NAME in
   io)
       IO
   ;;
   sql)
       SQL
   ;;
   *)
        echo -e "Usage: $0 [io | sql]"
esac

 

 

 

cat userparmeter_mysql_slave_status.conf
UserParameter=mysql.slave[*],/data/zabbix/zabbix_agent/scripts/mysql_slave_status.sh $1