zabbix 3.4监控mysql_使用zabbix3.4监控mysql5.6

01. 概述

通过zabbix自带模板监控mysql5.6。

02. 配置

2.1 配置zabbix-agent

$ egrep -v "^$|^#" /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/etc/zabbix mysql -N | awk '{print $2}'

UserParameter=mysql.size[*],bash -c 'echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from information_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema=\"$1\"")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name=\"$2\"");" | HOME=/etc/zabbix mysql -N'

UserParameter=mysql.ping,HOME=/etc/zabbix mysqladmin ping | grep -c alive

UserParameter=mysql.version,mysql -V

2.2 配置无密码登录数据库

创建一个用户：

mysql> grant select,process,replication client on *.* to zabbix@'%' identified by '123456';

.my.cnf文件对应上面的HOME=/etc/zabbix目录，可配置其他的目录

$ cat /etc/zabbix/.my.cnf

# Zabbix Agent

[mysql]

host=127.0.0.1

port=3306

user=zabbix

password='123456'

#socket=/usr/local/mysql/mysql.sock

[mysqladmin]

host=127.0.0.1

port=3306

user=zabbix

password='123456'

#socket=/usr/local/mysql/mysql.sock

03. 测试

3.1 服务器端获取监控agent端的数据

$ zabbix_get -s 10.46.67.42 -p 10050 -k mysql.ping

1

$ zabbix_get -s 10.46.67.42 -p 10050 -k mysql.version

mysql Ver 14.14 Distrib 5.6.16, for debian-linux-gnu (x86_64) using EditLine wrapper

3.2 zabbix-web端展示

需要增加zabbix自带模板，zabbix自带有mysql模板