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

Percona build of ProxySQL 3.0.1 and ProxySQL admin tools (2025-09-17)

Download Percona’s build of ProxySQL
Install
View the GitHub repository for Percona’s build of ProxySQL

ProxySQL is a high-performance proxy for MySQL and MySQL-compatible database servers such as Percona Server for MySQL and MariaDB. It acts as an intermediary for client requests seeking resources from the database. ProxySQL was created for the database administrator to solve complex replication topology issues. Percona distributes ProxySQL as a repackaged version of the upstream release, without making any code modifications.

You can download the original ProxySQL from GitHub. The ProxySQL documentation provides information on installing and running ProxySQL.

The ProxySQL Admin (proxysql-admin) tool simplifies the configuration of Percona XtraDB Cluster nodes with ProxySQL. ProxySQL Admin supports Percona XtraDB Cluster without custom scripts.

The pxc_scheduler_handler tool can automatically perform a failover due to node failures, service degradation, or maintenance. This tool has features and capabilities that differ from the ProxySQL admin tool, so you should not use options from one tool in the other, as that may cause unintended results.

Release highlights

This release introduces the Percona build of ProxySQL 3.0.1, incorporating the latest upstream features and improvements. This version includes all enhancements and bug fixes from upstream ProxySQL 3.0.1.

  • Dual-password support: Enables use of two passwords for seamless rotation.

  • Enhanced logging (from v2.7.2): Real-time query/event logging using a circular buffer and SQLite. View logs in stats_mysql_query_events, history_mysql_query_events, and Prometheus.

  • Prepared statement logging (#4895, #4922): Logs actual parameter values. Supports binary and JSON. Controlled by mysql-eventslog_stmt_parameters (disabled by default).

  • New event: PROXYSQL_METADATA (#4922): Logged when a new binary log file is created. Includes version metadata.

  • DNS cache improvements (#4745): Spreads out resolution attempts to avoid bursts and queue congestion.

OpenSSL library

ProxySQL now uses a dynamically linked version of the system’s OpenSSL library instead of a statically linked one. This change allows ProxySQL to more easily use the most up-to-date and secure versions of OpenSSL already present on the host system.

Additionally, ProxySQL now logs a warning message if it detects a problematic or outdated OpenSSL version, alerting administrators to potential security risks.

See the Packaging Notes for unsupported distributions.

Note

ProxySQL 3.0.1 contains a PostgreSQL module in beta. The Percona build of ProxySQL is only tested with Percona Server for MySQL.

Bug fixes

PSQLADM-564: If a password hash difference is detected, the syncusers command deletes and recreates the users, but this operation does not preserve the default_schema property. Thanks to George Mess for reporting this issue and contributing a patch.

Known issues

In an MySQL 8.4 or Percona Server for MySQL 8.4 environment, you may have the following issues:

  • ProxySQL contains counters that have not been updated to use the new terminology. Unexpected results may occur
  • The binlog reader errors out during initialization due to the use of the old terminology, such as SHOW MASTER STATUS command.

Packaging notes

ProxySQL 3 removed support for the following distributions (#4749) due to two key reasons: they are either officially past their end-of-life or they lack native support for OpenSSL 3.0, a library required for modern security features:

Distribution Reason for Removal EOL Date / Notes
CentOS 8 Past official EOL December 31, 2021
Debian 10 (Buster) Does not ship with OpenSSL 3.0 LTS ended June 30, 2024
Debian 11 (Bullseye) Does not include OpenSSL 3.0 Currently in LTS until Aug 2026
Ubuntu 18.04 (Bionic Beaver) EOL and does not support OpenSSL 3.0 EOL May 2023
Ubuntu 20.04 (Focal Fossa) Does not ship with OpenSSL 3.0 EOL April 2025

Additional resources

Last update: 2025-09-17