Percona Monitoring and Management (PMM)

Percona Monitoring and Management (PMM) is an open-source database monitoring, observability, and management platform designed to provide comprehensive visibility into database performance and infrastructure health. PMM enables organizations to monitor MySQL, PostgreSQL, MongoDB, Redis, and Valkey environments through real-time metrics, Query Analytics, customizable dashboards, and alerting capabilities. It helps database administrators and operations teams identify performance bottlenecks, troubleshoot issues faster, optimize queries, and improve overall database reliability across on-premises, cloud, and hybrid deployments.

Key Features of Percona Monitoring and Management (PMM):

• Open-source database monitoring and observability platform.
• Supports MySQL, PostgreSQL, MongoDB, Redis, and Valkey databases.
• Real-time monitoring of database and infrastructure performance.
• Query Analytics (QAN) for SQL query performance optimization.
• Customizable Grafana-based dashboards and visualizations.
• Centralized monitoring across multiple servers and environments.
• Historical performance analysis and capacity planning.
• Alerting and notifications for performance and availability issues.
• Agent-based and agentless monitoring options.
• Cloud-ready deployment using Docker, Kubernetes, and virtual machines.
• Secure monitoring with role-based access controls and encrypted communication.
• Enterprise-grade scalability for production database environments.

Percona Monitoring and Management (PMM) Usage:

$ sudo su

# Check Running PMM Container
$ docker ps

# Check Installed PMM Server Image
$ docker inspect pmm-server --format='{{.Config.Image}}'

# View PMM Server Logs
$ docker logs pmm-server --tail 50

# Verify PMM Server Version
$ cdocker exec -it pmm-server bash -c 'cat /usr/share/percona-dashboards/VERSION'

# Check PMM Client Version
$ pmm-admin --version

# Verify PMM Client Status
$ pmm-admin status

# List Monitored Services
$ pmm-admin list

# Add MySQL Monitoring
$ pmm-admin add mysql \
  --username=pmm \
  --password='your_password'

# Add PostgreSQL Monitoring
$ pmm-admin add postgresql \
  --username=pmm \
  --password='your_password'

# Add MongoDB Monitoring
$ pmm-admin add mongodb \
  --username=pmm \
  --password='your_password'

# Open PMM Web Interface
http://YOUR-IP

# Get Login Credentials:
$ cat /var/percona/credentials.txt

  

Disclaimer:
Percona Monitoring and Management (PMM) is an open-source software project developed and maintained by Percona LLC. Percona, PMM, and related trademarks belong to their respective owners. This software is not affiliated with or endorsed by any third-party database vendor, cloud provider, operating system vendor, or technology platform referenced for compatibility, integration, or deployment purposes. PMM provides monitoring, observability, and management capabilities for supported database platforms, while additional enterprise services and support offerings may be available separately from Percona.