Percona Monitoring and Management for Databases
PERCONA MONITORING AND MANAGEMENT
With over 62,000+ downloads, Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance.
You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL, MariaDB® and MongoDB servers to ensure that your data works as efficiently as possible.
Note: Percona Monitoring and Management (PMM) employs a client/server model. You must download and install both the client and server applications. The directions for doing this are in the PMM Documentation.
QUERY ANALYTICS AND METRICS ARE A VITAL PART OF ANY DEPLOYMENT
Query Analytics (QAN) helps you optimize database performance by making sure that MySQL and MongoDB queries are executed as expected and within the shortest time possible. In case of problems, you can see which queries may be the cause and get detailed metrics for them.
The Metrics Monitor tool provides a historical view of metrics that are critical to a database server. Time-based graphs are separated into dashboards by themes: some are related to MySQL or MongoDB, others provide general system metrics.
Point-in-time visibility and historical trending of database performance
Data from the Performance Schema and MySQL slow query log
Specific Amazon RDS and Amazon Aurora metrics dashboards for AWS-specific monitoring
Data from the MongoDB query profiler
Specialized MongoDB and MariaDB dashboards for graphing MMAPv1, InMemory, MyRocks and Aria storage engines
A historical view of metrics that are critical to a database server
Query metrics, including bytes sent, lock time, rows sent, and more
Best-of-breed tools, including Grafana, Prometheus, and Consul, as well as Percona-developed query analytics, administration, API, agent and exporter components
A single, easy to manage virtual appliance
PMM BUILT-IN TECHNOLOGY AND SOFTWARE SUPPORT
Percona Monitoring and Management monitors and provides actionable performance data for MySQL variants, including Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, Percona Server for MySQL, and MariaDB.
It captures metrics and data for the InnoDB, XtraDB and MyRocks storage engines, with specialized screens that show specific engine details.
- MySQL InnoDB Metrics / Advanced Metrics
- MySQL MyISAM Metrics
- MySQL MyRocks Metrics
- MySQL Performance Schema
- MySQL Replication
- MySQL Table Statistics
- MySQL User Statistics
Percona Monitoring and Management monitors and provides actionable performance data for MongoDB variants, including MongoDB Community Server, MongoDB Enterprise Server and Percona Server for MongoDB.
It includes specialized MongoDB and MariaDB dashboards for graphing MMAPv1, InMemory, MyRocks and Aria storage engines.
- MongoDB Cluster Summary
- MongoDB InMemory
- MongoDB MMAPv1
- MongoDB Overview
- MongoDB ReplSet
- MongoDB RocksDB
- MongoDB WiredTiger
Percona XtraDB Cluster
Percona XtraDB Cluster is an active/active high availability and high scalability open source solution for MySQL clustering. It integrates Percona Server and Percona XtraBackup with the Codership Galera library of MySQL high availability solutions in a single package that enables you to create a cost-effective MySQL high availability cluster.
- Percona XtraDB Cluster / Galera Cluster Overview
- Percona XtraDB Cluster / Galera Graphs
Amazon RDS MySQL and Amazon Aurora MySQL
Percona Monitoring and Management is designed to work with Amazon RDS MySQL and Amazon Aurora MySQL. PMM has a specific dashboard for monitoring Amazon RDS MySQL and Amazon Aurora MySQL using Cloudwatch and direct sampling of MySQL metrics.
- Amazon RDS Metrics
- Aurora MySQL Metrics
Percona Monitoring and Management is designed to work with ProxySQL. ProxySQL is a high-performance SQL proxy. ProxySQL runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime.
With PMM, you can gather metrics for ProxySQL and its interactions with the database and applications.
- ProxySQL Overview
PERCONA MONITORING AND MANAGEMENT BENEFITS
- Provides query and metric information that enables administrators to optimize database performance
- Displays current queries and highlights potential query issues to enable faster issue resolution
- Maps queries against metrics to help make informed decisions about crucial database resources: platform needs, system growth, team focus and the most important database activities