mysql主从监控
#脚本如下，截取主从关键字
|
1
2
3
4
5
6
7
8
9
10
11
12
|
cat check_mysql_slave.sh
#!/bin/bash# declare -a 定义数组，slave_is 会被视为数组declare -a slave_is
slave_is=($(/data/mysql/bin/mysql -e "show slave status\G"|grep -E "Slave_IO_Running|Slave_SQL_Running:"|awk '{print $2}'))
if [ "${slave_is[0]}" = "Yes" -a "${slave_is[1]}" = "Yes" ];then
echo "ok -slave is running"
exit 0
else echo "down -slave is not running"
exit 2
fi |
#zabbix_agentd.conf文件的配置如下：
|
1
|