1, Introduction to PMM
Previously published an article on Prometheus+Grafana, the link is: [DB treasure 36] use Docker to build a beautiful prometheus+grafana monitoring system every minute Today, let's introduce another monitoring tool: PMM.
PMM (Percona Monitoring and Management) is a free open source platform for managing and monitoring database performance, which can be run in docker environment. It can actively manage and monitor MySQL (AWS RDS MySQL, Aurora MySQL, user built MySQL instances), MariaDB, MongoDB, PostgreSQL and other databases, as well as ProxySQL middleware, and provides many indicators and various alarm methods.
Percona Monitoring and Management (PMM) is an open-source platform for managing and monitoring the performance of MySQL and MongoDB. The DB monitoring data collected through the PMM client is illustrated by the third-party software Grafana.
PMM provides the monitoring of MyISAM, InnoDB, TokuDB and PXC/Glarera. In addition, it also provides the function of Query Analytics to view which SQL instructions are executed and optimize the syntax with poor execution efficiency. In addition, MySQL replication topology structure is supported in the new version. Demo official website: http://pmmdemo.percona.com
PMM also provides monitoring of hard disk, network, CPU and RAM for the operating system. In particular, it provides monitoring of context switches, Processes and interrupts. Context switches can see the status of CPU up and down switching files, and Processes can easily understand how many programs in the system are waiting for I/O.
It's a professional product for MySQL and Mongo, and it's very simple for the overall deployment of PMM. After 2.0, the performance of the underlying persistent database has been greatly improved after being replaced from Mysql to PG.
The architecture of PMM is as follows:
2, Installation and use
https://www.percona.com/software/pmm/quickstart
https://www.percona.com/doc/percona-monitoring-and-management/2.x/
https://hub.docker.com/r/percona/pmm-server/tags docker pull percona/pmm-server:latest -- Pull image docker pull percona/pmm-server:2.14 -- establish PMM Data container docker rm lhr-pmm-data docker create --name lhr-pmm-data \ -v /pmmdata \ percona/pmm-server:2.14 /bin/true -- establish PMM Server container docker rm -f lhr-pmm-server docker run -d --name lhr-pmm-server -h lhr-pmm-server \ -p 280:80 -p 2443:443 \ --volumes-from lhr-pmm-data \ -e SERVER_USER=lhr \ -e SERVER_PASSWORD=lhr \ -e ORCHESTRATOR_ENABLED=true \ -e METRICS_RETENTION=48h \ --restart always \ percona/pmm-server:2.14 -- visit web Interface http://192.168.66.35:280 https://192.168.66.35:2443 admin/admin -- get into PMM The server docker exec -it lhr-pmm-server bash -- connection to PMM The server pmm-admin config --server-insecure-tls --server-url=https://admin:admin@127.0.0.1:443 pmm-admin list
It can be accessed using http or https, with different port numbers.
After logging in, you can see the following information:
[root@lhr-pmm-server opt]# pmm-admin config --server-insecure-tls --server-url=https://admin:admin@127.0.0.1:443 Checking local pmm-agent status... pmm-agent is running. Registering pmm-agent on PMM Server... Registered. Configuration file /usr/local/percona/pmm2/config/pmm-agent.yaml updated. Reloading pmm-agent configuration... Configuration reloaded. Checking local pmm-agent status... pmm-agent is running. [root@lhr-pmm-server opt]# pmm-admin list Service type Service name Address and port Service ID Agent type Status Metrics Mode Agent ID Service ID pmm_agent Connected /agent_id/57124a26-ea3e-4240-b39d-ec91af80e559 node_exporter Running push /agent_id/fed6ce91-c926-49d1-8bcb-17a8e3225f78 vmagent Running push /agent_id/cbd8515c-d655-4467-a6bd-42c9db580ff2
3, Monitoring MySQL database
You can add multiple monitored instances and execute the following process:
[root@lhr-pmm-server opt]# pmm-admin add mysql --query-source=perfschema --username=root --password=lhr --host=192.168.66.35 --port=3317 --service-name=mysql-192.168.66.35-3317 MySQL Service added. Service ID : /service_id/28cd296f-597a-4043-8c87-792308b31d37 Service name: mysql-192.168.66.35-3317 Table statistics collection enabled (the limit is 1000, the actual table count is 535). [root@lhr-pmm-server opt]# pmm-admin add mysql --query-source=perfschema --username=root --password=lhr --host=192.168.66.35 --port=3318 --service-name=mysql-192.168.66.35-3318 MySQL Service added. Service ID : /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 Service name: mysql-192.168.66.35-3318 Table statistics collection disabled (the limit is 1000, the actual table count is 1042). [root@lhr-pmm-server opt]# pmm-admin list Service type Service name Address and port Service ID MySQL mysql-192.168.66.35-3317 192.168.66.35:3317 /service_id/28cd296f-597a-4043-8c87-792308b31d37 MySQL mysql-192.168.66.35-3318 192.168.66.35:3318 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 Agent type Status Metrics Mode Agent ID Service ID pmm_agent Connected /agent_id/57124a26-ea3e-4240-b39d-ec91af80e559 node_exporter Running push /agent_id/fed6ce91-c926-49d1-8bcb-17a8e3225f78 mysqld_exporter Running push /agent_id/5a8f8a51-c342-4108-8f94-1779e00ed118 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 mysqld_exporter Running push /agent_id/b8342bd9-0c20-40d6-a666-b6b79903f5e8 /service_id/28cd296f-597a-4043-8c87-792308b31d37 mysql_perfschema_agent Running /agent_id/908ad693-b9a2-43a9-abd2-f0d06ca1ca09 /service_id/28cd296f-597a-4043-8c87-792308b31d37 mysql_perfschema_agent Running /agent_id/f965b782-76eb-49e8-874c-df52d47c7cb7 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 vmagent Running push /agent_id/cbd8515c-d655-4467-a6bd-42c9db580ff2
PMM monitoring interface:
MySQL slow query analysis
PMM can monitor and analyze slow queries:
4, Monitoring PG database
The back-end metadata storage of PMM server uses PG database, so we can directly monitor the database:
[root@lhr-pmm-server opt]# pmm-admin add postgresql --username=pmm-managed --password=pmm-managed --host=127.0.0.1 --port=5432 --service-name=PG-127.0.0.1-5432 PostgreSQL Service added. Service ID : /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b Service name: PG-127.0.0.1-5432 [root@lhr-pmm-server opt]# pmm-admin list Service type Service name Address and port Service ID MySQL mysql-192.168.66.35-3317 192.168.66.35:3317 /service_id/28cd296f-597a-4043-8c87-792308b31d37 MySQL mysql-192.168.66.35-3318 192.168.66.35:3318 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 PostgreSQL PG-127.0.0.1-5432 127.0.0.1:5432 /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b Agent type Status Metrics Mode Agent ID Service ID pmm_agent Connected /agent_id/57124a26-ea3e-4240-b39d-ec91af80e559 node_exporter Running push /agent_id/fed6ce91-c926-49d1-8bcb-17a8e3225f78 mysqld_exporter Running push /agent_id/5a8f8a51-c342-4108-8f94-1779e00ed118 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 mysqld_exporter Running push /agent_id/b8342bd9-0c20-40d6-a666-b6b79903f5e8 /service_id/28cd296f-597a-4043-8c87-792308b31d37 postgres_exporter Running push /agent_id/28bfba92-4872-4cd9-b3a1-5273670a44a2 /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b mysql_perfschema_agent Running /agent_id/908ad693-b9a2-43a9-abd2-f0d06ca1ca09 /service_id/28cd296f-597a-4043-8c87-792308b31d37 mysql_perfschema_agent Running /agent_id/f965b782-76eb-49e8-874c-df52d47c7cb7 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 postgresql_pgstatements_agent Running /agent_id/5cf99a1b-b474-48a9-94ad-acc6bdc77efb /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b vmagent Running push /agent_id/cbd8515c-d655-4467-a6bd-42c9db580ff2
PMM monitoring interface:
5, Monitor MongoDB database
When using PMM to monitor a cluster, you should use the PMM admin add command to enable monitoring of each instance, including replica sets, mongos, and all configuration servers in a fragmented cluster.
-- No password pmm-admin add mongodb --host=192.168.66.35 --port=27017 --service-name=mongodb-192.168.66.35-27017 -- Have password pmm-admin add mongodb --username=root --password=lhr mongodb-192.168.66.35-37017 192.168.66.35:37017 pmm-admin add mongodb --username=root --password=lhr --host=192.168.66.35 --port=37017 --service-name=mongodb-192.168.66.35-37017 -- Cluster, replication set pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr --host=192.168.66.35 --port=37020 --service-name=mongodb-192.168.66.35-37020-lhr_rep pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr --host=192.168.66.35 --port=37021 --service-name=mongodb-192.168.66.35-37021-lhr_rep pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr --host=192.168.66.35 --port=37022 --service-name=mongodb-192.168.66.35-37022-lhr_rep pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr --host=192.168.66.35 --port=37023 --service-name=mongodb-192.168.66.35-37023-lhr_rep pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr --host=192.168.66.35 --port=37024 --service-name=mongodb-192.168.66.35-37024-lhr_rep -- query pmm-admin list
After adding:
[root@lhr-pmm-server opt]# pmm-admin list Service type Service name Address and port Service ID MySQL mysql-192.168.66.35-3317 192.168.66.35:3317 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 MySQL mysql-192.168.66.35-3316 192.168.66.35:3316 /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 MySQL mysql-192.168.66.35-3315 192.168.66.35:3315 /service_id/5318af15-e338-4628-a7ba-19e2f510239d MySQL mysql-192.168.66.35-3318 192.168.66.35:3318 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 MongoDB mongodb-192.168.66.35-37024-lhr_rep 192.168.66.35:37024 /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 MongoDB mongodb-192.168.66.35-27017 192.168.66.35:27017 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 MongoDB mongodb-192.168.66.35-37021-lhr_rep 192.168.66.35:37021 /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf MongoDB mongodb-192.168.66.35-37020-lhr_rep 192.168.66.35:37020 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 MongoDB mongodb-192.168.66.35-37022-lhr_rep 192.168.66.35:37022 /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a MongoDB mongodb-192.168.66.35-37017 192.168.66.35:37017 /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda MongoDB mongodb-192.168.66.35-37023-lhr_rep 192.168.66.35:37023 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 PostgreSQL PG-127.0.0.1-5432 127.0.0.1:5432 /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 Agent type Status Metrics Mode Agent ID Service ID pmm_agent Connected /agent_id/f304147a-43a6-484b-9d32-d8f3c721cb63 node_exporter Running push /agent_id/89311eaa-bf62-4730-8f3b-ebddb9ddfe57 mysqld_exporter Running push /agent_id/13bca963-69be-4313-b6b4-ed4234c0abb5 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 mysqld_exporter Running push /agent_id/29177549-d624-43dd-ae28-f29e913587d0 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 mysqld_exporter Running push /agent_id/ee281335-8d7b-47fd-91a9-873062beff2d /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 mysqld_exporter Running push /agent_id/fc3fad17-4dd1-4ae7-aa4e-22cce69dfe02 /service_id/5318af15-e338-4628-a7ba-19e2f510239d mongodb_exporter Running push /agent_id/690ab339-5838-43c5-978e-73bb188d434a /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a mongodb_exporter Running push /agent_id/69905494-247a-41d1-b45f-a8e31639baf9 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 mongodb_exporter Running push /agent_id/7d97045e-afae-4e05-8216-5fbf5f28a74b /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda mongodb_exporter Running push /agent_id/860ed641-3599-4fdc-9f57-8137d45f06b8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 mongodb_exporter Running push /agent_id/87be410e-dd68-4ce2-80fa-05d7827b5300 /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf mongodb_exporter Running push /agent_id/c5f4b04a-3520-4355-aca5-7e41646883c5 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 mongodb_exporter Running push /agent_id/c78247a4-1a66-410d-bb18-7032f9fa016b /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 postgres_exporter Running push /agent_id/e6f7e9f2-2657-48ac-9fb0-ef7e4bd5a547 /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 mysql_perfschema_agent Waiting /agent_id/100d98c1-3b3d-4dee-8bc1-843495ed529a /service_id/5318af15-e338-4628-a7ba-19e2f510239d mysql_perfschema_agent Running /agent_id/9827db00-7a69-4d05-9295-85c06fb2ebc3 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 mysql_perfschema_agent Running /agent_id/e3e3890c-cbbd-4e05-8e23-ba4e624f78a5 /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 mysql_perfschema_agent Running /agent_id/fa3201ca-b5d8-46aa-9e04-f1b5102e6336 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 mongodb_profiler_agent Running /agent_id/4887dbdf-e603-45d7-af74-a9067cbe56c8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 mongodb_profiler_agent Running /agent_id/4e51521d-ea16-4dd5-a3e2-940c717a3e53 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 mongodb_profiler_agent Running /agent_id/5cd5dee9-e158-43a0-9511-ad4c7b2d9e47 /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a mongodb_profiler_agent Running /agent_id/807b4342-735c-4816-b491-e3cbbf4170bd /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf mongodb_profiler_agent Running /agent_id/c2737dd5-7ec4-47fe-aa66-68209d4f3225 /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda mongodb_profiler_agent Running /agent_id/c8511980-db30-476a-8776-7aa14a32eebf /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 mongodb_profiler_agent Running /agent_id/fc4a0fa5-9fb4-4ba3-99d9-3d9c30d443e3 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 postgresql_pgstatements_agent Running /agent_id/e00bddb3-ef8e-4f74-9c9b-98e6b274769d /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 vmagent Running push /agent_id/4b564af7-7775-4337-86cf-950daeabb354
PMM monitoring interface:
There are many monitoring contents, which can be viewed by clicking:
6, Monitoring ProxySQL Middleware
[root@lhr-pmm-server opt]# pmm-admin add proxysql --username=root --password=lhr --host=192.168.66.35 --port=16032 --service-name=proxysql-192.168.66.35-16032 ProxySQL Service added. Service ID : /service_id/84d87f04-e701-4480-abc9-bde170bfd478 Service name: proxysql-192.168.66.35-16032 [root@lhr-pmm-server opt]# pmm-admin list Service type Service name Address and port Service ID MySQL mysql-192.168.66.35-3317 192.168.66.35:3317 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 MySQL mysql-192.168.66.35-3316 192.168.66.35:3316 /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 MySQL mysql-192.168.66.35-3315 192.168.66.35:3315 /service_id/5318af15-e338-4628-a7ba-19e2f510239d MySQL mysql-192.168.66.35-3318 192.168.66.35:3318 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 MongoDB mongodb-192.168.66.35-37024-lhr_rep 192.168.66.35:37024 /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 MongoDB mongodb-192.168.66.35-27017 192.168.66.35:27017 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 MongoDB mongodb-192.168.66.35-37021-lhr_rep 192.168.66.35:37021 /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf MongoDB mongodb-192.168.66.35-37020-lhr_rep 192.168.66.35:37020 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 MongoDB mongodb-192.168.66.35-37022-lhr_rep 192.168.66.35:37022 /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a MongoDB mongodb-192.168.66.35-37017 192.168.66.35:37017 /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda MongoDB mongodb-192.168.66.35-37023-lhr_rep 192.168.66.35:37023 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 PostgreSQL PG-127.0.0.1-5432 127.0.0.1:5432 /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 ProxySQL proxysql-192.168.66.35-16032 192.168.66.35:16032 /service_id/f43ada33-f77d-4cbf-9c98-331b7ba2310e Agent type Status Metrics Mode Agent ID Service ID pmm_agent Connected /agent_id/f304147a-43a6-484b-9d32-d8f3c721cb63 node_exporter Running push /agent_id/89311eaa-bf62-4730-8f3b-ebddb9ddfe57 mysqld_exporter Running push /agent_id/13bca963-69be-4313-b6b4-ed4234c0abb5 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 mysqld_exporter Running push /agent_id/29177549-d624-43dd-ae28-f29e913587d0 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 mysqld_exporter Running push /agent_id/ee281335-8d7b-47fd-91a9-873062beff2d /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 mysqld_exporter Running push /agent_id/fc3fad17-4dd1-4ae7-aa4e-22cce69dfe02 /service_id/5318af15-e338-4628-a7ba-19e2f510239d mongodb_exporter Running push /agent_id/690ab339-5838-43c5-978e-73bb188d434a /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a mongodb_exporter Running push /agent_id/69905494-247a-41d1-b45f-a8e31639baf9 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 mongodb_exporter Running push /agent_id/7d97045e-afae-4e05-8216-5fbf5f28a74b /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda mongodb_exporter Running push /agent_id/860ed641-3599-4fdc-9f57-8137d45f06b8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 mongodb_exporter Running push /agent_id/87be410e-dd68-4ce2-80fa-05d7827b5300 /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf mongodb_exporter Running push /agent_id/c5f4b04a-3520-4355-aca5-7e41646883c5 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 mongodb_exporter Running push /agent_id/c78247a4-1a66-410d-bb18-7032f9fa016b /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 postgres_exporter Running push /agent_id/e6f7e9f2-2657-48ac-9fb0-ef7e4bd5a547 /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 proxysql_exporter Running push /agent_id/86664e69-156a-487d-aaa0-9ab585befb99 /service_id/f43ada33-f77d-4cbf-9c98-331b7ba2310e mysql_perfschema_agent Waiting /agent_id/100d98c1-3b3d-4dee-8bc1-843495ed529a /service_id/5318af15-e338-4628-a7ba-19e2f510239d mysql_perfschema_agent Running /agent_id/9827db00-7a69-4d05-9295-85c06fb2ebc3 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 mysql_perfschema_agent Running /agent_id/e3e3890c-cbbd-4e05-8e23-ba4e624f78a5 /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 mysql_perfschema_agent Running /agent_id/fa3201ca-b5d8-46aa-9e04-f1b5102e6336 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 mongodb_profiler_agent Running /agent_id/4887dbdf-e603-45d7-af74-a9067cbe56c8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 mongodb_profiler_agent Running /agent_id/4e51521d-ea16-4dd5-a3e2-940c717a3e53 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 mongodb_profiler_agent Running /agent_id/5cd5dee9-e158-43a0-9511-ad4c7b2d9e47 /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a mongodb_profiler_agent Running /agent_id/807b4342-735c-4816-b491-e3cbbf4170bd /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf mongodb_profiler_agent Running /agent_id/c2737dd5-7ec4-47fe-aa66-68209d4f3225 /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda mongodb_profiler_agent Running /agent_id/c8511980-db30-476a-8776-7aa14a32eebf /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 mongodb_profiler_agent Running /agent_id/fc4a0fa5-9fb4-4ba3-99d9-3d9c30d443e3 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 postgresql_pgstatements_agent Running /agent_id/e00bddb3-ef8e-4f74-9c9b-98e6b274769d /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 vmagent Running push /agent_id/4b564af7-7775-4337-86cf-950daeabb354
PMM does not have ProxySQL monitoring template by default. We need to download it ourselves: https://github.com/percona/grafana-dashboards/blob/master/dashboards/ProxySQL_Overview.json
After downloading, upload it to the PMM monitoring interface.
Interface after monitoring:
About Me
● the author of this article: wheat seedling. Some contents are sorted out from the network. If there is infringement, please contact wheat seedling to delete
This is the personal WeChat official account. DB treasure )Sync updates on
● QQ group number: 230161599, 618766405, wechat group private chat
● personal QQ number (646634621), micro signal (db_bao), indicating the reason for adding
● completed in Xi'an in March 2021
● latest revision date: March 2021
● all rights reserved. Welcome to share this article. Please keep the source for reprint
● micro store of wheat seedlings: https://weidian.com/?userid=793741433
● database series published by wheat seedlings: http://blog.itpub.net/26736162/viewspace-2142121/
● wheat seedling OCP, OCM, high availability, DBA classes (Oracle, MySQL, NoSQL): http://blog.itpub.net/26736162/viewspace-2148098/
● database written interview question bank and answers: https://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w
Use WeChat client to scan the following two-dimensional code to focus on the WeChat official account of wheat seedlings. DB treasure )And QQ group (DBA treasure), add wheat seedling wechat, and learn the most practical database technology.
