原 【DB宝41】监控利器PMM的使用--监控MySQL、PG、MongoDB、ProxySQL等
Tags: 原创PGMySQLDocker监控GrafanaMongoDBOrchestratorPMM
四、监控PG数据库
PMM服务器的后端元数据存储用的是PG数据库,所以,我们可以直接监控该库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | [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监控界面: