Zabbix using Percona plugin to monitor MySQL

Source: Internet
Author: User
Tags install php percona

Monitor MySQL with Percona plugin

We used to monitor MySQL or mariadb status by customizing the monitoring items, but if we need more detailed types of monitoring or do not want to create a series of monitoring projects ourselves, we can use the monitoring items in the Percona plugin to realize MySQL monitoring. This saves us a lot of manual operation.

Install the PHP environment and Percona plugin:

Yum Install PHP PHP-MYSQL–YRPM-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

After the plug-in installation is complete, you will be prompted as follows:

Scripts is installed to/var/lib/zabbix/percona/scriptstemplates is installed To/var/lib/zabbix/percona/templates

There will be two files in the templates directory:

[[email protected] ~]# cd/var/lib/zabbix/percona/templates[[email protected] templates]# lltotal 284-rw-r--r--1 root ro OT 18866 Dec userparameter_percona_mysql.conf-rw-r--r--1 root root 269258 Dec zabbix_agent_template_pe Rcona_mysql_server_ht_2.0.9-sver1.1.7.xml

Where the Userparameter file requires us to copy to the directory specified in the corresponding ZABBX agent configuration. Default is/etc/zabbix/zabbix_agentd.d/

The template file needs to be imported into the Zabbix template, which defines all the monitoring rules.

In scripts, there are also two files:

[Email protected] scripts]# lltotal 64-rwxr-xr-x 1 root root 1251 Dec get_mysql_stats_wrapper.sh-rwxr-xr-x 1 ro OT root 59998 Nov 15:55 ss_get_mysql_stats.php

Here you need to modify the PHP file specified in the database account, password and sock file path, the default is a null value, pointing to the/var/lib/mysql/mysql.sock, if not the default, you need to modify:

$mysql _user = ' root '; $mysql _pass = ' 123456 '; $mysql _port = 3306; $mysql _socket = '/data/mariadata/mysql/mysql.sock ';

Test commands are available:

[Email protected] scripts]#/get_mysql_stats_wrapper.sh gg48

Web Interface import template, if too many monitoring items can delete unwanted monitoring items. Attach the monitor template http://down.51cto.com/data/2340474.


This article is from the "Trying" blog, make sure to keep this source http://tryingstuff.blog.51cto.com/4603492/1981296

Zabbix using Percona plugin to monitor MySQL

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.