Skip to content
Percona Software for MySQL Documentation

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

ProxySQL, proxysql-admin, and percona-scheduler-admin documentation

This documentation is for the latest release: Percona ProxySQL admin tools 2.7.3 (Release notes).

ProxySQL acts as a proxy between Percona XtraDB Cluster and your client application. It manages a connection pool, caching connections and keeping them open for future requests. ProxySQL runs continuously without needing a restart.

Without a connection pool, each SQL request opens a new connection to the remote node and closes it after completion. ProxySQL keeps certain connections open and reuses them or closes them if not reused within a specific time. You connect to the proxy, and it forwards your requests to the cluster.

ProxySQL operates as a daemon monitored by a process that can restart it in case of an unexpected exit, minimizing downtime. The daemon accepts traffic from MySQL clients and forwards it to backend MySQL servers.

Configuration options include runtime parameters, server grouping, and traffic-related parameters, many of which can be set at runtime using SQL-like queries.

The ProxySQL 2 documentation provides details on installation, running ProxySQL, and using the ProxySQL admin tools. The maintained releases are listed on ProxySQL Installation.

You can download ProxySQL 2.x.x. Note that version 1 is no longer actively maintained.

ProxySQL 2.x.x downloads include:

In a MySQL 8.4 or Percona Server for MySQL 8.4 environment, you may face these issues:

  • ProxySQL contains counters that have not been updated to use the new terminology, leading to unexpected results.

  • The binlog reader errors out during initialization due to the use of old terminology, such as the the SHOW MASTER STATUS command

Last update: 2025-04-22