zabbix_MySQL监控

zabbix_MySQL监控

[root@linux-node2 zabbix_agentd.d]# pwd
/etc/zabbix/zabbix_agentd.d
[root@linux-node2 zabbix_agentd.d]# ll
total 8
-rw-r--r-- 1 root root 1547 Dec  1 07:36 userparameter_mysql.conf
-rw-r--r-- 1 root root  159 Nov 30 16:27 zabbix_nginx.conf
[root@linux-node2 ~]# mysqladmin -uroot -p123456 ping 
mysqld is alive
[root@linux-node2 ~]# mysqladmin -uroot -p123456 ping | grep -c alive
1
[root@linux-node2 ~]# zabbix_get -s 192.168.56.12 -k mysql.ping
1

创建一个新的应用集

创建监控项

写好描述

过滤

 创建触发器

 

 使用插件监控mysql

[root@linux-node2 ~]# yum -y install php php-mysql   安装插件

[root@linux-node2 ~]# rpm -ivh https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpm

[root@linux-node2 ~]# rpm -ql percona-zabbix-templates   脚本存放的路径
/var/lib/zabbix/percona
/var/lib/zabbix/percona/scripts
/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
/var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
/var/lib/zabbix/percona/templates
/var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf
/var/lib/zabbix/percona/templates/zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.7.xml

[root@linux-node2 ~]# cd /var/lib/zabbix/percona/scripts/
[root@linux-node2 scripts]# ll
total 64
-rwxr-xr-x 1 root root  1251 Dec 10  2016 get_mysql_stats_wrapper.sh   脚本
-rwxr-xr-x 1 root root 59976 Dec 10  2016 ss_get_mysql_stats.php       php脚本

[root@linux-node2 scripts]# cd ../templates/
[root@linux-node2 templates]# ll
total 284
-rw-r--r-- 1 root root  18866 Dec 10  2016 userparameter_percona_mysql.conf
-rw-r--r-- 1 root root 269258 Dec 10  2016 zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.7.xml

[root@linux-node2 templates]# cp userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/
[root@linux-node2 templates]# ll /etc/zabbix/zabbix_agentd.d/
total 28
-rw-r--r-- 1 root root  1547 Dec  1 07:36 userparameter_mysql.conf
-rw-r--r-- 1 root root 18866 Dec  1 19:34 userparameter_percona_mysql.conf
-rw-r--r-- 1 root root   159 Nov 30 16:27 zabbix_nginx.conf

[root@linux-node2 scripts]# cat ss_get_mysql_stats.php.cnf  做密钥认证
<?php
$mysql_user='root';
$mysql_pass='123456';
[root@linux-node2 scripts]# ./get_mysql_stats_wrapper.sh gg  有值认证成功
19


[root@linux-node2 scripts]# vim get_mysql_stats_wrapper.sh  多实例修改的地方
RES=`HOME=~zabbix mysql -e 'SHOW SLAVE STATUS\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\n' ','`

连接模版