mysql 多实例监控,epmmm zabbix mysql 多实例 监控 模版

epmmm performance monitor for mysql and mariadb on zabbix 2.x and zabbix 3.x

link：

The wrapper for zabbix python script.

It runs the script every 10 seconds. and parses the cache file on each following run.

Test the script using:

zabbix_get -s 192.168.0.1 -p 10050 -k "epmmm.mysql.check[zabbixmysql,192.168.0.1,3306,check]"

python epmmm_get_mysql_stats.py --servicehostname SERVICEHOSTNAME --servicehost SERVICEHOST --serviceport SERVICEPORT --username USERNAME --password PASSWORD

The script need zabbix_sender and Python Running Environment

The default monitor mysql port is 3306, if you need to monitor other port, you need to add the Inherited and host macros:{$MYSQL_PORT}=xxxx on the monitor Host

Remember to change the USERNAME PASSWORD ZABBIXSERVER for your‘s.

Authors: earl86

info:the scripts only tested on python 2.6 and python 2.7. It not tested on python 3

using:

install python and pip

pip install MySQL-python

pip install argparse

you may be need to link file:

ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18

import the template into zabbix

put the following three scripts on zhe mysql server which has zabbix agent

/etc/zabbix/zabbix_agentd.d/userparameter_epmmm_mysql.conf

/etc/zabbix/scripts/epmmm_get_mysql_stats_wrapper.sh

/etc/zabbix/scripts/epmmm_get_mysql_stats.py

restart the zabbix agent service

add the mysqlservice and mysqlhost on zabbix web

Enjoy it