客户端配置监控mysql
数据库授权
mysql> grant usage on *.* to "zabbix-monitor"@"%" identified by '123134';
mysql> flush privileges;
数据库需要用到的key
[root@localhost etc]# cp /data/zabbix-2.4.6/conf/zabbix_agentd/userparameter_mysql.conf /usr/local/zabbix-2.4.6/etc/zabbix_agentd.conf.d/
vim /usr/local/zabbix-2.4.6/etc/zabbix_agentd.conf
# Include=/usr/local/etc/zabbix_agentd.conf.d/*.conf
建立数据库和zabbix的链接关系
[root@localhost ~]# vim /usr/local/zabbix-2.4.6/etc/.my.cnf
#Zabbix Agent
[mysql]
host=localhost
user=zabbix-monitor
password=123456
socket= /tmp/mysql.sock
[mysqladmin]
host=localhost
user=zabbix-monitor
password=123456
socket= /tmp/mysql.sock
vim /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf
将HOME=/var/lib/zabbix全部改成HOME=/usr/local/zabbix/etc/
检索mysql信息时发现sh: mysql: command not found
这一般是路径不对。修改文件zabbix_agentd.conf.d/userparameter_mysql.conf
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/usr/local/zabbix/etc /usr/local/mysql/bin/mysql -N | awk '{print $$2}'
zabbix和mysql,都要用绝对路径,其中zabbix给到./my.cnf的家目录即可。
ps可以自己修改获取到正确的参数例如:UserParameter=mysql.version,/usr/local/mysql/bin/mysql -V|awk '{print $2,$3,$4,$5}'
客户端zabbix_agentd.conf文件修改重启后,信息还没更新过来,此时重启一下服务端就ok了。