Set up PMM Server¶
Check system requirements.
Approximately 1 GB of storage per monitored database node with data retention set to one week. By default, retention is 30 days.
Disable table statistics to decrease the VictoriaMetrics database size.
A minimum of 2 GB per monitored database node. The increase in memory usage is not proportional to the number of nodes. For example, data from 20 nodes should be easily handled with 16 GB.
Your CPU must support the
SSE4.2instruction set, a requirement of ClickHouse, a third-party column-oriented database used by Query Analytics. If your CPU is lacking this instruction set you won’t be able to use Query Analytics. Additionally, since PMM 2.38.0, your CPU and any virtualization layer in use must support x86-64-v2 or your container may not start.
Configure your network.
Decide how you want to run PMM Server. Choose from:
Authenticating using API keys.
While adding clients to the PMM server, you use the
adminuser. However, if you change the password for the admin user from the PMM UI, then the clients will not be able to access PMM. Also, due to multiple unsuccessful login attempts Grafana will lock out the
adminuser. The solution is to use API key for authentication. You can use API keys as a replacement for basic authentication.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.