Zabbix-监控mysql

环境：
linux-node1.example.com CentOS release 6.7 zabbix-sender-3.0.31-1.el6.x86_64
linux-node1.example.com CentOS release 6.7

一 自定义监控mysql

检测存活
[root@linux-node2 ~]# mysqladmin -u root -pzabbix ping |grep -c alive
1

修改配置文件
[root@linux-node2 zabbix_agentd.d]# vim userparameter_mysql.conf
UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin -u root -pzabbix ping | grep -c alive

[root@linux-node2 zabbix_agentd.d]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]

[root@linux-node2 lib]# service zabbix-agent restart
Shutting down Zabbix agent: [ OK ]
Starting Zabbix agent: [ OK ]

[root@linux-node2 ~]# zabbix_get -s 10.0.0.16 -k mysql.ping
1

二 使用percona插件监控

工具下载地址
https://www.percona.com/downloads/percona-monitoring-plugins/

[root@linux-node2 ~]# rpm -ivh percona-zabbix-templates-1.1.8-1.noarch.rpm
[root@linux-node2 scripts]# ll
total 64
-rwxr-xr-x 1 root root 1251 Jan 10 2018 get_mysql_stats_wrapper.sh
-rwxr-xr-x 1 root root 60679 Jan 10 2018 ss_get_mysql_stats.php

[root@linux-node2 templates]# pwd
/var/lib/zabbix/percona/templates
[root@linux-node2 templates]# cp userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/

[root@linux-node2 percona]# cd scripts/
[root@linux-node2 scripts]# pwd
/var/lib/zabbix/percona/scripts
[root@linux-node2 scripts]# ls
get_mysql_stats_wrapper.sh ss_get_mysql_stats.php
[root@linux-node2 scripts]# vim ss_get_mysql_stats.php.cnf ----写个密码文件

<?php
$mysql_user='root';
$mysql_pass='zabbix';

[root@linux-node2 scripts]# ./get_mysql_stats_wrapper.sh gg
0

自己把模版导出来，在导入进页面

把导出的模版，导入进去。

[root@linux-node2 zabbix_agentd.d]# service zabbix-agent restart
Shutting down Zabbix agent: [ OK ]
Starting Zabbix agent: [ OK ]