Connect ProxySQL databases to PMM¶

Monitor your ProxySQL instances with Percona Monitoring and Management (PMM) to track performance metrics and gain insights into query routing behavior.

Prerequisites¶

Before adding a ProxySQL instance to PMM:

ensure PMM Server is running and accessible
verify PMM Client is installed on the host running ProxySQL
configure a dedicated read-only user in ProxySQL for monitoring purposes

Use the proxysql alias to enable ProxySQL performance metrics monitoring.

Add ProxySQL service¶

Add your ProxySQL instance to PMM using the proxysql service type:

Basic usage¶

pmm-admin add proxysql --username=pmm --password=pmm

Replace pmm with the credentials for your ProxySQL administration interface. For security, configure a dedicated read-only monitoring account using the admin-stats_credentials variable in ProxySQL.

You can append two optional positional arguments: a service name and a service address. If omitted, PMM uses <node>-proxysql and 127.0.0.1:6032 as defaults.

Example output¶

The output of this command may look as follows:

pmm-admin add proxysql --username=pmm --password=pmm

ProxySQL Service added.
Service ID  : f69df379-6584-4db5-a896-f35ae8c97573
Service name: ubuntu-proxysql

Configuration options¶

You can customize the ProxySQL service configuration using command-line flags. These flags provide more control than positional arguments and take higher priority when both are specified.

Service identification flags¶

--service-name: Custom name for the ProxySQL service in PMM
--host: Hostname or IP address of the ProxySQL instance
--port: Port number for ProxySQL admin interface
--socket: UNIX socket path (alternative to host/port)

Connection examples¶

TCP connection with custom service name: ```sh pmm-admin add proxysql \ –username=pmm \ –password=pmm \ –service-name=my-new-proxysql \ –host=127.0.0.1 \ –port=6032