MySQL

在被监控的 MySQL 中创建巡检用户

mysql> create user 'dbcheck'@'localhost' identified by 'xxxxxx';
mysql> grant PROCESS, REPLICATION CLIENT ON *.* TO 'dbcheck'@'localhost';

会有 warning，忽略

配置 MySQL 检查脚本的运行环境

# usermod -a -G mysql zabbix
# mkdir -p /var/lib/zabbix
# echo '[mysql]' > /var/lib/zabbix/.my.cnf
# echo 'user=dbcheck' >> /var/lib/zabbix/.my.cnf
# echo 'password=xxxxxx' >> /var/lib/zabbix/.my.cnf
# echo 'socket=/tmp/mysql.sock' >> /var/lib/zabbix/.my.cnf
# chown zabbix.root /var/lib/zabbix/.my.cnf
# chmod 440 /var/lib/zabbix/.my.cnf

MySQL 监控脚本示例

# cat /opt/zabbix/mysql_chk_db_status.sh
export ROOTDIR=/opt/zabbix
source $ROOTDIR/mysql.profile

dbstat=`mysql -e "select 'OK';" 2> /dev/null | grep OK | wc -l`
if [ $dbstat -eq 2 ]; then
    echo 0
else
    echo 1
fi

PROFILE 文件示例

# cat /opt/zabbix/mysql.profile 
export PATH=/usr/local/mysql/bin:$PATH