Awesome PMM

A curated list of awesome Percona Monitoring and Management (PMM) free and open-source software, libraries and resources.

Percona Monitoring and Management (PMM) is a single pane of glass to help manage complex database environments in public, private or on-premises environments.

Designed to help DBAs and developers gain deep insight into their applications and databases, PMM is used by thousands of organizations around the globe to manage complex database environments.

This list accepts and encourages pull requests. See CONTRIBUTING

Content

• Resources
  • Videos
  • Community Blogs
• Dashboards
  • Resources
  • Community Dashboards
• Exporters
  • Resources
  • Percona
  • Community Exporters

Resources

• Official website - Landing page
• Demo - pmmdemo.percona.com. — PMM Contributions Overview – Learn how to become an active contributor within the PMM community.
• Jira - issue tracker. Use JIRA to suggest improvements or to report a bug. You can select a task and solve it to become a PMM contributor.
• FAQ - answers to the most popular questions.
• Blog - news, cases, lessons, webinars and articles.
• Forum - the best place for non-Customers looking for free PMM Help.
• User manual - Download PDF. Operations Manual is 200 pages of easily referenced documentation in PDF format.
• Documentation - excellent online documentation. How to install, configure and use.
• Download - download Percona Monitoring and Management
• Installation - Percona Monitoring and Management (PMM) employs a client/server model. You must download and install both the client and server applications.
• GitHub - the main repository. You can find links to other PMM repositories.
• Docker - Docker images of PMM Server.

Contribute to PMM

• Google Summer of Code GSoC 2020 - PMM is participating* in the GSoC 2020, and sees it as an excellent opportunity for students to participate in the active and vibrant open source community.
• How To Contribute to PMM Documentation - PMM documentation contribution guide.

Videos

• What is new in PMM2? – by Michael Coburn (Percona). Official website.
• Monitoring MongoDB with Percona Monitoring and Management (PMM) – by Doug Duncan (Percona), Adamo Tonete (Percona). Official website.
• Automate PMM Deployment with Ansible – by Max Bubenick (Percona). Official website.

Community Blogs

• Setting up a High Availability for PMM – by Mydbops IT Solutions.
• Add your blog here

Dashboards

PMM Server uses Grafana Dashboards.

Resources

• Grafana Dashboards by Percona - This is a set of Grafana dashboards for database and system monitoring using Prometheus datasource.
• Grafana Marketplace – community built dashboards.

Community dashboards

• MySQL InnoDB Mutex - by Daniel Guzman-Burgos. Configuration article.
• System Processes Metrics - by chaudhryfaisal. Show Linux Process information as captured by process-exporter.
• Clickhouse Grafana Dashboard – by Yegor Andreenko for Clickhouse Exporter for Prometheus.
• MySQL InnoDB Cluster Group Replication - by Valentin Traen. Custom Queries example

Exporters

PMM Client uses Prometheus exporters. Applications store their metrics in arbitrary formats, and Prometheus exporters collect them and produce (or export to) a consistent format of key-value pairs.

Resources

• Official Percona Exporters - Percona has developed Prometheus exporters for popular open-source databases.
• Prometheus exporters - you can plug in Prometheus exporters for technologies not directly provided by Percona.
• Examples of use - Does Percona Monitoring and Management (PMM) Support External Monitoring Services? Yes It Does!
• Textfile collector - Expose statistics read from local disk. How to extend the list of available metrics without modifying the node_exporter code. It’s based on the textfile collector.

Percona

• Percona Node Exporter - Prometheus exporter for hardware and OS metrics exposed by *NIX kernels, written in Go with pluggable metric collectors.
• Percona MySQL Exporter - Prometheus exporter for MySQL server metrics.
• Percona MongoDB Exporter - Based on MongoDB Exporter by David Cuadrado
• PostgreSQL Server Exporter - Prometheus exporter for PostgreSQL server metrics.
• Percona ProxySQL Exporter - Prometheus exporter for ProxySQL performance data.
• Percona RDS Exporter - An AWS RDS exporter for Prometheus. It gets metrics from both basic CloudWatch Metrics and RDS Enhanced Monitoring via CloudWatch Logs.

Community Exporters

• Clickhouse Exporter for Prometheus – by Yegor Andreenko. Clickhouse Grafana Dashboard could be a start for inspiration.
• Redis Metrics Exporter – Prometheus exporter for Redis metrics. Instructions in the section "Example 2: Adding a Redis Monitoring Service" in the article.