mysql主从同步脚本监控脚本

21232asa

脚本很简单，一看就明白：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

[iyunv@localhost files]# cat libexec/slave.sh #!/bin/bash ##slave.sh ##YES ---- 1 ##NO  ---- 0 export MYSQL_PWD=xxxxxx xstats () { STATS=$(/usr/local/mysql/bin/mysql -h127.0.0.1 -uUser_name  -P$1 -e "show slave status\G" | grep "\<$2\>" |awk '{print $2}') if [ "${STATS}" = "Yes" ]; then   echo 1 else   echo 0 fi } if [ "$2" != "Seconds_Behind_Master" ];then xstats $1 $2 else result=$(/usr/local/mysql/bin/mysql -h127.0.0.1 -umonitor  -P$1 -e "show slave status\G" | grep "Seconds_Behind_Master" |awk '{print $NF}') echo $result fi

这样定义键值：

1	UserParameter=mysql_slave_status ,/usr/local/zabbix/libexec/slave.sh $1 $2

模板里这样写：

1 2 3

mysql_slave_status[{#MYSQLPORT},Seconds_Behind_Master] mysql_slave_status[{#MYSQLPORT},Slave_IO_Running] mysql_slave_status[{#MYSQLPORT},Slave_SQL_Running]