Shulou(Shulou.com)06/01 Report--

The following content mainly brings you the monitoring and management platform installation of MySQL and MongoDB provided by Percona Company. The knowledge mentioned is slightly different from books. It is summed up by professional and technical personnel in the process of contact with users, and has a certain experience sharing value. I hope to bring help to the majority of readers.

PMM is a monitoring and management platform for MySQL and MongoDB provided by percona. PMM has two parts, PMM Client and PMM Server.

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

. Pmm-admin:pmm client management tool to add or delete database instances that need to be monitored

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

. Node_exporter: used to collect commonly used system metrics

. Mysqld_exporter: used to collect MySQL performance metrics

. Mongodb_export: used to collect MongoDB performance metrics

. Proxysql_export: used to collect proxySQL performance metrics

PMMServer: collect and analyze data transferred from various databases, including the following components

. Query Analytics (QAN): query MySQL performance by time period. Qan agent communication with the client consists of two components. Qan api and qan web app

. Metrics Monitor (MM): provides a historical view of MySQL and mongo performance

One, download and install

= = PMM Server==

Currently, PMM Server can only be used in docker,virtualBox or Amazon Machine Image. The following is used in docker to explain how to install

Step 1:

$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 2:

$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

= monitored CVM = =

$pmm-admin config-- server 172.17.0.4

Where 172.17.0.4 is the server where pmm Server resides, and 80 is the port number.

$pmm-admin add mysql-user dba_monitor-password 123456

Add mysql monitoring

$pmm-admin add mongodb

Add mongodb monitoring

$pmm-admin list

View monitoring items

= PMM Server==

MySQL course recommendation

MySQL performance Management and Architecture Design

High performance Extensible MySQL Database Design and Architecture Optimization of E-commerce Project

For the above monitoring and management platform installation of MySQL and MongoDB provided by Percona, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.