ProxySQL 3.1.7 Release Notes

Release date: 2026-04-07

ProxySQL 3.1.7 is a maintenance release for the Innovative Tier, incorporating all improvements from ProxySQL 3.0.7 while adding significant enhancements to the Fast Forward Traffic Observer (FFTO) and Time-Series Database (TSDB) subsystems. This version is built using PROXYSQL31=1.

Release commit: d7a26b79e936557e2d198148ce6d09111210d651

Highlights (Innovative Tier)

• FFTO Error Recording: FFTO now records MySQL and PostgreSQL errors from fast-forwarded traffic into stats_mysql_errors and stats_pgsql_errors, providing full error visibility for previously invisible traffic.
• FFTO Default Changed: FFTO is now disabled by default in 3.1.x for stability, with opt-in activation. It remains enabled by default in 4.0.x.
• Comprehensive FFTO Testing: Added extensive E2E tests for FFTO covering MySQL and PostgreSQL protocols, including pipelining, transactions, error handling, and large result sets.
• TSDB Test Fixes: Fixed TSDB TAP tests for Docker-based CI infrastructure reliability.

New Features (3.1.x)

FFTO Error Recording

MySQL Fast-Forward Error Visibility (c3df4ee, #5539)
FFTO now captures and records MySQL errors that occur during fast-forwarded sessions into the existing stats_mysql_errors table. This includes a new mysql_parse_err_packet() helper that identifies error packets in the MySQL wire protocol stream, enabling administrators to monitor and alert on errors in fast-forwarded traffic that was previously invisible to ProxySQL's statistics subsystem.

PostgreSQL Fast-Forward Error Visibility (c6f442b, #5539)
Similarly, PostgreSQL errors from fast-forwarded sessions are now recorded in stats_pgsql_errors. The pgsql_parse_error_response() helper parses PostgreSQL ErrorResponse messages to extract error severity, code, and message fields. Both helpers include comprehensive unit tests validating correct parsing across protocol versions.

FFTO Default Behavior Change

FFTO Disabled by Default in 3.1.x (61fc7a1, #5539)
FFTO is now disabled by default in the 3.1.x Innovative Tier. Administrators who wish to use FFTO must explicitly enable it via the mysql-enable_ffto or pgsql-enable_ffto variables. This change prioritizes stability for the broader user base while keeping FFTO available for users who need deep traffic observability. FFTO remains enabled by default in 4.0.x.

FFTO E2E Testing

Comprehensive FFTO E2E Test Suite (#5516, #5517)
Added a comprehensive suite of E2E TAP tests for FFTO covering both MySQL and PostgreSQL protocols:

• MySQL FFTO Tests (#5516): Concurrent sessions, transaction patterns, mixed text/binary protocol, large queries, bypass recovery, and session isolation.
• PostgreSQL FFTO Tests (#5517): Extended query pipelining, statement/portal management, mixed simple + extended protocol, concurrent sessions, error handling, CommandComplete tag varieties, and large result sets.

These tests validate FFTO's correctness across a wide range of protocol interactions and edge cases.

TSDB Improvements

TSDB Test Infrastructure (ca40936, 809878c)
Fixed TSDB TAP tests to work correctly in Docker-based CI environments, ensuring reliable test execution across different infrastructure configurations.

Features Inherited from v3.0.7 (Stable Tier)

ProxySQL 3.1.7 includes all features, bug fixes, and improvements from the v3.0.7 release, including:

• Protocol Safety: Hardened MySQL protocol handling for COM_CHANGE_USER, HandshakeResponse, and PROXY protocol v1 (#5556).
• zstd Compression: Native zstd compression support for the MySQL protocol.
• TLS Observability: stats_tls_certificates table and stats_proxysql_global table for TLS certificate tracking and global metrics.
• SHOW WARNINGS Fix: Correct warning_count handling for statements with inline comments (#5306).
• REST API: Configuration-based route loading and hardened config handling.
• Security: Admin credential redaction in logs and Dependabot alert remediation.

For a detailed list of these core improvements, please refer to the ProxySQL 3.0.7 Release Notes.

Contributors

ProxySQL is a community-driven project, and we are grateful to all the contributors who helped make this release possible. A special thank you to:

• @rahim-kanji for PostgreSQL protocol hardening and FFTO error recording.
• @YujiHatakeyama for the SHOW WARNINGS fix with inline comments (#5306).

We also thank everyone who reported bugs, tested experimental features, and provided feedback during this release cycle.

Hashes

The release commit is: d7a26b79e936557e2d198148ce6d09111210d651

SHA256s:

a0af6f0f306c3621b95e0e160bdebd8feeccd934f13ad95af675ff56c00b8f1b  proxysql-3.1.7-1-almalinux10-clang.x86_64.rpm
a3a9424e3dae9f6d92c1566230898a573eca97ee6871d2537114be2c66ccc28a  proxysql-3.1.7-1-almalinux10.aarch64.rpm
c25772b9e2eff169d234867e0d51e65ad77a11c352237d63a2386a315e764460  proxysql-3.1.7-1-almalinux10.x86_64.rpm
a8ce2154ce5ee302e6d022fcc0860f61f4a7d4a974602a0c9032e89ae744d78a  proxysql-3.1.7-1-almalinux8-clang.x86_64.rpm
31a7dbdee5bfcf816e3d7f7c3632dd90297c7cc9591c4740d0dcf87ee2b0f47c  proxysql-3.1.7-1-almalinux8.aarch64.rpm
fbcf29c98a3fe4f5c1501f48f5d13b32efae89a14859c4710697daaa5e585995  proxysql-3.1.7-1-almalinux8.x86_64.rpm
cd9026c618a7a724fcc275e755314bfbba791947c95ecdb276a2ba74e1ccd1fa  proxysql-3.1.7-1-almalinux9-clang.x86_64.rpm
4f9f253563b54b6badbfb539f02ee6be5444fb27c41d495a14c336a7b47072a3  proxysql-3.1.7-1-almalinux9.aarch64.rpm
e3356b054b93e428071b111a3521dbf3df9f4b1476887227d9e90215d600c8cd  proxysql-3.1.7-1-almalinux9.x86_64.rpm
28d29cb1b523c15c8421272aff2431eb5482bef2a19c5bddbdac9a9d77636c5c  proxysql-3.1.7-1-centos10-clang.x86_64.rpm
1b801050025bd27b6232bc56fa612aed986de2f2b1a24b4dc69f98f01e398e7c  proxysql-3.1.7-1-centos10.aarch64.rpm
7249c9692b84044ce886e60e2b0c71bdd057711dd3e2f2e42118b42d51b63835  proxysql-3.1.7-1-centos10.x86_64.rpm
2f6f13b7d384b4f2afa15f0206f60d27116417235a7455120afefaf93ff4e946  proxysql-3.1.7-1-centos9-clang.x86_64.rpm
fbf9fa1cff16fe65c7ba626b4a4a415c8ee559d1cd1cbc5bdffe1bd7063ab82d  proxysql-3.1.7-1-centos9.aarch64.rpm
d347db13c61ef2d9becc36bd30f0f119397856b6c8285d1f16eb64521a5d72bb  proxysql-3.1.7-1-centos9.x86_64.rpm
b248ec72b815e17e9ea65bd9d29032ea31de35319f7a9e6d505c12366b0dede8  proxysql-3.1.7-1-dbg-almalinux10.x86_64.rpm
421ae3404310817b599ed166b8c14b868f6cd72789fcc74aa0a4dc92ece64143  proxysql-3.1.7-1-dbg-almalinux8.x86_64.rpm
5d8b71206ed3b821347570437269f2b11019e8efc5b41f5ab88a3a94168ed598  proxysql-3.1.7-1-dbg-almalinux9.x86_64.rpm
6d6293b1a22abac6e6935c8a4f42840cc4f7e49ceaacf013554b8d378d07a73f  proxysql-3.1.7-1-dbg-centos10.x86_64.rpm
510679212aa282ec5d3ecc91ecbe5aed4df3df2be829c28b0a2ce1da309df278  proxysql-3.1.7-1-dbg-centos9.x86_64.rpm
e230b06f230d6b18dee8e9e9e009ce6f5c58a8bd3f5efe3b8ed548c31b01abf6  proxysql-3.1.7-1-dbg-fedora42.x86_64.rpm
b9eec0b2e67d2bfa4eec910c0432741d4abf40ba549e1c70620801bb4b58c313  proxysql-3.1.7-1-dbg-fedora43.x86_64.rpm
c3ff57776554bae96e3bfe2eb45f5f25d7a060c13dbf7823acc3ab0ae839af01  proxysql-3.1.7-1-dbg-opensuse15.x86_64.rpm
482d1674c2ebd74f0cacb2c11828a9b794f23b97270d77022073f7ae2284ca3b  proxysql-3.1.7-1-dbg-opensuse16.x86_64.rpm
caccd15ee6a013d50c795fe7cad8047db5592889cd1c0e6a846f280e4d829759  proxysql-3.1.7-1-fedora42-clang.x86_64.rpm
cc930ea283897d4b4bef03e6290c69c161153354ab957fabd25abf9a23eb9bba  proxysql-3.1.7-1-fedora42.aarch64.rpm
54ed72cc4b6711c5e5eeb192cf0027c64fe7ecb5899b15fba04a728ce4549005  proxysql-3.1.7-1-fedora42.x86_64.rpm
ccf66387dc5c02d23bd6c028eaae4c5287889565864ba84e2f0afb5c6ea4adb6  proxysql-3.1.7-1-fedora43-clang.x86_64.rpm
b96167a68b274f719c612694e99bcf347da057d42b2c9ffb32e55960c823acd6  proxysql-3.1.7-1-fedora43.aarch64.rpm
5564910dcb214b9c529b26a3ed6dea89a1daa1f014089296e2f2316c3d20e7c5  proxysql-3.1.7-1-fedora43.x86_64.rpm
7ee746ca1507f45494c8337342d1613256e5c08c4bd3acc42869ce9771d5a838  proxysql-3.1.7-1-opensuse15-clang.x86_64.rpm
e4f866502d0e9ec5cc163cd1ee3b3eccf63bcf0dde673c2aee9d534251813002  proxysql-3.1.7-1-opensuse15.aarch64.rpm
1b0c3f51fa117932da1f6ab9d6817327b084c4d0bfd9402175faf5c0b7120221  proxysql-3.1.7-1-opensuse15.x86_64.rpm
4974679c66d9a196cb3382b5b8e9ffba2f1e0fae03921209b370316e52cdb610  proxysql-3.1.7-1-opensuse16-clang.x86_64.rpm
2ace970e6082be18fb6cc9cd071c5b9b6a36aa3707a03f5edfbbf22d59fcaa37  proxysql-3.1.7-1-opensuse16.aarch64.rpm
fa3b85822c5fba61a40d70fec43e051a9d9859dc9e440b5bf24a7b0a43f2040e  proxysql-3.1.7-1-opensuse16.x86_64.rpm
e8e8144d33e06f92b7f6961ce2825c3d4685901104c625a01bbc59535b99e628  proxysql_3.1.7-dbg-debian12_amd64.deb
4c2f084e01a8e23f9e9ad18fe0f7947a3760048c6efbeb1e7955481404d83bc0  proxysql_3.1.7-dbg-debian13_amd64.deb
320cb917195a817ea1bd93aecdc8fbd874918792458ddc1aa20c0196b2c45dcd  proxysql_3.1.7-dbg-ubuntu22_amd64.deb
edef73ab021e02a3149575475679a271f35a5698ebb4d2c078cfe8e93104c2ec  proxysql_3.1.7-dbg-ubuntu24_amd64.deb
5df9a11473a12a7c339f3dbfde144c2a3c45e4d646809e4b401533eb20ae9c9f  proxysql_3.1.7-debian12-clang_amd64.deb
22e281551b72162ea2f68ac4fc97b05c30ef51e4f8855093fda8b756a102b1e6  proxysql_3.1.7-debian12_amd64.deb
8aaec78a44d05f7fbc0b731954346fceac1551048d1d13093658a88c185b341b  proxysql_3.1.7-debian12_arm64.deb
9f23f6fcec35ed672329781bfa925d592650b60abe2eea2d92a256505100e6e5  proxysql_3.1.7-debian13-clang_amd64.deb
1dd7e8d2ae6195902c00498f5518581ab35d5afaa437919c4b7db1b952878ae6  proxysql_3.1.7-debian13_amd64.deb
b9a98ddf5c773c0ca2c792fb3ca6a29b9b0cbd82e28aaab8cb3bb9b8c698aa92  proxysql_3.1.7-debian13_arm64.deb
97e1ffb0c1709184cae3356057b15f4892bb9817f3362ac863f685fdb0d02cca  proxysql_3.1.7-ubuntu22-clang_amd64.deb
fc28984f62d0047f1ad27c299ed96e6122f5d868009ae85ef52bfa6376b574bc  proxysql_3.1.7-ubuntu22_amd64.deb
9102e5efba9c9d19bba02f3d8dcadd11c4b89bdabb56a062d3e3d47d5f664dad  proxysql_3.1.7-ubuntu22_arm64.deb
a2fff2c01d1d16eae783cab776c43a4cd6bda7e1a25efd64c702b5b137ee851e  proxysql_3.1.7-ubuntu24-clang_amd64.deb
77ec3a7d6351104eb8a92e350b175b30eab0c0f5c5a6ddd7d32e5ce8e0e8740f  proxysql_3.1.7-ubuntu24_amd64.deb
1f6c1f1e9129148a2d3083954c5d1a39d8918725f3638436aa7c4e5c1b4c3b7d  proxysql_3.1.7-ubuntu24_arm64.deb