Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool designed for MySQL, PostgreSQL, MongoDB, and the servers they operate on. It provides a centralized view of node-to-single-query performance metrics across all databases. The Query Analytics feature helps users quickly identify costly and slow-running queries to resolve bottlenecks. Percona Advisors offers recommendations for performance, security, and configuration, ensuring databases perform optimally. Features such as alerting, backup, restore, and a built-in open source Private DBaaS are included to enhance IT team efficiency. PMM allows users to monitor database performance through customizable dashboards and real-time alerting. It enables detailed examination of database performance, from the node level down to individual queries, facilitating the identification and resolution of bottlenecks and slow queries using Query Analytics. The tool also provides automated insights and recommendations for security, configuration, and performance, helping to proactively address potential issues. Backup and restore capabilities allow for backing up critical data with minimal downtime and performance impact, including scheduling various backup types and restoring databases to a specific point in time. PMM supports a range of technologies and dashboards, including MySQL variants like Percona Server for MySQL, Percona XtraDB Cluster, Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, and MariaDB. It captures metrics and data for storage engines like InnoDB, XtraDB, and MyRocks, offering specialized dashboards for engine-specific details.

Features

• MySQL Monitoring
  • Optimize and troubleshoot MySQL performance.
• MongoDB Monitoring
  • Monitor MongoDB performance.
• PostgreSQL Monitoring
  • Monitor PostgreSQL performance.
• Percona Alerting
  • Real-time alerting for database performance.
• Query Analytics
  • Zoom in and drill down on database performance, from node to single-query levels. Quickly locate and fix bottlenecks and slow-running queries.
• Percona Advisors
  • Use automated insights and recommendations for security posture, configuration, and performance to uncover problems before they become larger issues.
• Backup & Restore
  • Back up critical data with zero downtime and minimal performance impact. Schedule various types of backups (hot, incremental, physical) and restore databases up to a specific moment with Point-in-Time Recovery.