zabbix mysql监控报错_zabbix监控mysql

这里可以采用zabbix自带的mysql模版，但是也需要在mysql服务器上准备获取mysql status的脚本chk_mysql.sh，zabbix通过调用这个脚本来获取mysql的运行信息。

在配置文件zabbix_agentd.conf里面添加mysql监控信息：

# vim /etc/zabbix/zabbix_agentd.conf

UserParameter=mysql.version,mysql -V

UserParameter=mysql.status[*],/usr/local/zabbix/scripts/chk_mysql.sh $1

UserParameter=mysql.ping,mysqladmin -uzabbix -pys_ipowerlong0418 -P3306 -h127.0.0.1  ping | grep -c alive

添加mysql帐号：

GRANT PROCESS,SUPER,REPLICATION CLIENT ON *.* TO zabbix@'127.0.0.1' IDENTIFIED BY 'ys_ipowerlong0418';

添加check脚本权限：

chmod u+x /usr/local/zabbix/chk_mysql.sh

chown -R zabbix.zabbix /usr/local/zabbix/chk_mysql.sh

去zabbix服务器上面检查基本mysql服务器信息是否能正常获取到，zabbix_get -s 192.168.1..62 -p10050 -k"system.cpu.load[all,avg15]";：

[root@hch_test_121_12 html]# zabbix_get -s 192.168.1..62 -p10050 -k "system.cpu.load[all,avg15]";

0.050000

[root@hch_test_121_12 html]#

接下来准备mysql的运行信息监控，需要准备新的mysql监控脚本chk_mysql.sh,/usr/local/zabbix/chk_mysql.sh：

#!/bin/sh

# -------------------------------------------------------------------------------

# FileName:    check_mysql.sh

# Revision:    1.0

# Date:        2016/04/22

# Author:      tim

# Email:       mchdba@sohu.com

MYSQL_SOCK="/usr/local/mysql/mysql.sock"

MYSQL_USER='zabbix'

MYSQL_PWD='ys_ipowerlong0418'

MYSQL_HOST='127.0.0.1'

MYSQL_PORT='3306'

ARGS=1

if [ $# -ne "$ARGS" ];then

echo "Please input one arguement:"

fi

case $1 in

Uptime)

result=`/usr/local/mysql/bin/mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -p${MYSQL_PWD} -S $MYSQL_SOCK status|cut -f2 -d":"|cut -f1 -d"T"`

echo $result

;;

Com_update)

result=`/usr/local/mysql/bin/mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep -w "Com_update"|cut -d"|" -f3`

echo $result

;;

Slow_queries)

result=`/usr/local/mysql/bin/mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -p${MYSQL_PWD} -S $MYSQL_SOCK status |cut -f5 -d":"|cut