首页 > 数据库技术 > 详细

epmmm zabbix mysql 多实例 监控 模版

时间:2018-08-09 15:38:32      阅读:175      评论:0      收藏:0      [点我收藏+]
epmmm performance monitor for mysql and mariadb on zabbix 2.x and zabbix 3.x

link:

https://github.com/earl86/epmmm

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

epmmm zabbix mysql 多实例 监控 模版

原文:http://blog.51cto.com/1460758/2156787

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!