Installation and configuration of MySQL monitoring tool PMM provided by Percona Company

PMM is a monitoring and management platform provided by Percona company for MySQL and MongoDB. PMM has two components PMM client and PMM Server

PMM Client: Installed in each database host that needs to be monitored, including the following tools

 . PMM-ADMIN:PMM client Tools for adding or removing database instances that need to be monitored

. Percona-qan-agent: Used to collect database performance data

 . Node_exporter: Used to collect commonly used system indicators

    . Mysqld_exporter: Used to collect MySQL performance metrics

    . Mongodb_export: Used to collect MongoDB performance indicators

    . Proxysql_export: Used to collect Proxysql performance indicators

Pmmserver: Collect and analyze data transferred from each database, including the following components

. Query Analytics (QAN): Queries MySQL performance on a time-period basis, with the client's QAN agent communication consisting of two components. QAN API and QAN web App

. Metrics Monitor (MM): Provides a historical view of the performance of MySQL and MONGO

One, download the installation

================================PMM server=============================

PMM Server is currently available only in Docker,virtualbox or Amazon machine image. The following is used in Docker to illustrate how to install

Step One:

$ docker Create \

-v/opt/prometheus/data \

-v/opt/consul-data \

-v/var/lib/mysql \

-v/var/lib/grafana \

--name pmm-data \

Percona/pmm-server:1.1.1/bin/true

Step Two:

$ Docker run-d \

-P 80:80 \

--volumes-from pmm-data \

--name pmm-server \

--restart always \

percona/pmm-server:1.1.1

================================PMM client=============================

$ wget https://www.percona.com/downloads/pmm-client/pmm-client-1.1.1/binary/tarball/pmm-client-1.1.1.tar.gz

$ tar zxf pmm-client-1.1.1.tar.gz

$ CD pmm-client-1.1.1

$./install

Second, increase monitoring

========================= is monitored by the server ==============================

$ pmm-admin Config--server 172.17.0.4:80

Where 172.17.0.4 is the server where PMM server is located, 80 is the port number

$PMM-admin add MySQL--user dba_monitor--password 123456

Increased MySQL monitoring

$PMM-admin Add MongoDB

Increased MongoDB monitoring

$PMM-admin List

View Monitoring Items

=====================PMM server==============================

650) this.width=650; "Src=" Https://s3.51cto.com/oss/201710/24/38b83e3419028676eeb31ac71dc228bb.png-wh_500x0-wm_3 -wmp_4-s_3851069520.png "alt=" 192.168.100.1 for Pmm-server Server "title=" Pmm.png "/>

MySQL Course recommendations

   mysql performance management and architecture design

high-performance extensible MySQL Database design and Architecture Optimization e-commerce project   

This article is from the "DBA Log" blog, reproduced please contact the author!

Installation and configuration of MySQL monitoring tool PMM provided by Percona Company