The PMM platform is based on a client-server model that enables scalability. It includes the following modules:
The modules are packaged for easy installation and usage. It is assumed that the user should not need to understand what are the exact tools that make up each module and how they interact. However, if you want to leverage the full potential of PMM, the internal structure is important.
PMM is a collection of tools designed to seamlessly work together. Some are developed by Percona and some are third-party open-source tools.
The overall client-server model is not likely to change, but the set of tools that make up each component may evolve with the product.
The following diagram illustrates how PMM is currently structured:
Each PMM Client collects various data about general system and database performance, and sends this data to the corresponding PMM Server.
The PMM Client package consist of the following:
pmm-mysql-queries-0is a service that manages the QAN agent as it collects query performance data from MySQL and sends it to the QAN API on PMM Server.
pmm-mongodb-queries-0is a service that manages the QAN agent as it collects query performance data from MongoDB and sends it to QAN API on PMM Server.
PMM Server runs on the machine that will be your central monitoring host. It is distributed as an appliance via the following:
For more information, see Installing PMM Server.
PMM Server includes the following tools:
Query Analytics enables you to analyze MySQL query performance over periods of time. In addition to the client-side QAN agent, it includes the following:
Metrics Monitor provides a historical view of metrics that are critical to a MySQL or MongoDB server instance. It includes the following:
Grafana is a third-party dashboard and graph builder for visualizing data aggregated by Prometheus in an intuitive web interface. For more information, see Grafana Docs.
Orchestrator is a MySQL replication topology management and visualization tool. For more information, see: Orchestrator Manual.
All tools can be accessed from the PMM Server web interface (landing page). For more information, see Tools of PMM.
Orchestrator is a MySQL replication topology management and visualization
tool. If it is enabled, you can access it using the
/orchestrator URL after
PMM Server address. Alternatively, you can click the
MySQL Replication Topology Manager button on the PMM Server landing
To use it, create a MySQL user for Orchestrator on all managed instances:
GRANT SUPER, PROCESS, REPLICATION SLAVE, RELOAD ON *.* TO 'orc_client_user'@'%' IDENTIFIED BY 'orc_client_password’;
The credentials in the previous example are default. If you use a different user name or password, you have to pass them when running PMM Server using the ORCHESTRATOR_PASSWORD and ORCHESTRATOR_USER options.
$ docker run ... -e ORCHESTRATOR_ENABLED=true ORCHESTRATOR_USER=name -e ORCHESTRATOR_PASSWORD=pass ... percona/pmm-server:latest
Then you can use the Discover page in the Orchestrator web interface to add the instances to the topology.
Orchestrator is not enabled by default starting with PMM 1.3.0
Orchestrator was included into PMM for experimental purposes. It is a standalone tool, not integrated with PMM other than that you can access it from the landing page.
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.