ProxySQL¶
Use the proxysql alias to enable ProxySQL performance metrics monitoring.
USAGE¶
pmm-admin add proxysql --username=pmm --password=pmm
where username and password are credentials for the administration interface of the monitored ProxySQL instance.
You should configure a read-only account for monitoring using the admin-stats_credentials variable in ProxySQL
Additionally, two positional arguments can be appended to the command line flags: a service name to be used by PMM, and a service address. If not specified, they are substituted automatically as <node>-proxysql and 127.0.0.1:6032.
The output of this command may look as follows:
pmm-admin add proxysql --username=pmm --password=pmm
ProxySQL Service added.
Service ID : /service_id/f69df379-6584-4db5-a896-f35ae8c97573
Service name: ubuntu-proxysql
Beside positional arguments shown above you can specify service name and
service address with the following flags: --service-name, and --host (the
hostname or IP address of the service) and --port (the port number of the
service), or --socket (the UNIX socket path). If both flag and positional argument are present, flag gains higher
priority. Here is the previous example modified to use these flags for both host/port or socket connections:
pmm-admin add proxysql --username=pmm --password=pmm --service-name=my-new-proxysql --host=127.0.0.1 --port=6032
pmm-admin add proxysql --username=pmm --password=pmm --service-name=my-new-proxysql --socket=/tmp/proxysql_admin.sock
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.