Monitoring PostgreSQL with Percona Monitoring and Management (PMM)

了解如何使用PMM(Percona监控和管理)监控PostgreSQL,以便:
提高性能和瓶颈的可视性PostgreSQL 将PostgreSQL服务器整合到您已经用于MySQL和MongoDB的相同监控平台中
*在严重性1问题中更快、更高效地作出响应
我们将展示如何使用PMM的外部导出器功能,您可以在几分钟内集成PostgreSQL!

展开查看详情

1. Monitoring PostgreSQL with Percona Monitoring and Management (PMM) Michael Coburn Percona 1 © 2019 Percona

2.Michael Coburn ▪ Product Manager for PMM (as well as for Percona Toolkit). ▪ At Percona for 6 years across multiple MySQL roles Principal Architect, Managing Consultant, Technical Account Manager 2 © 2019 Percona

3.What is PMM ▪ Free, Open Source database troubleshooting and performance optimization platform for MySQL, MongoDB, and PostgreSQL ▪ We also support: ProxySQL Amazon RDS MySQL & Aurora MySQL Remote MySQL & PostgreSQL instances ▪ Runs in your secure environment (this is not a SaaS product!) and on your equipment ▪ Secured with SSL between client and server 3 © 2019 Percona

4.Amazon RDS and Aurora PostgreSQL 4 © 2019 Percona

5.Add Instances 5 © 2019 Percona

6.List Instances 6 © 2019 Percona

7.Remote PostgreSQL For when you don't have shell, or run an unsupported platform (eg. PostgreSQL on Windows) 7 © 2019 Percona

8.Add Remote Instances 8 © 2019 Percona

9.Command Line 9 © 2019 Percona

10.Command Line ▪ yum -y install pmm-client ▪ pmm-admin config --server 1.2.3.4 ▪ pmm-admin add postgresql linux:metrics postgresql:metrics 10 © 2019 Percona

11.Dashboards 11 © 2019 Percona

12.PostgreSQL Overview 12 © 2019 Percona

13.Using Grafana Alerting 13 © 2019 Percona

14.Grafana Alerting ▪ Rules are added to graphs that react based on defined thresholds ▪ Alerts are sent to pre-defined Notification Channels You can have multiple channels defined 14 © 2019 Percona

15.Grafana Alerting 15 © 2019 Percona

16.Grafana Notification Channels ▪ Defines how you will learn about new alerts ▪ Over a dozen are available: Email Slack PagerDuty AlertManager ... 16 © 2019 Percona

17.What's on the Roadmap ▪ PostgreSQL Query Analytics ▪ Vacuum statistics ▪ Replica metrics 17 © 2019 Percona