github sysown/proxysql v4.0.8
ProxySQL 4.0.8

latest release: v3.0.8
pre-release8 hours ago

ProxySQL 4.0.8 Release Notes

Release date: 2026-04-25

ProxySQL 4.0.8 is a maintenance release for the AI/MCP Tier, incorporating all improvements from ProxySQL 3.1.8 and 3.0.8. The headline 4.0-specific change in this cycle is the removal of the experimental Rust-based sqlite-rembed dependency, which eliminates the Rust toolchain requirement for PROXYSQLGENAI=1 builds and trims the GenAI documentation accordingly.

Release commit: 6ef036a00c6f1dbcf3f27fe7f6e07f3211d7d6f8

Highlights (AI/MCP Tier)

  • No Rust Toolchain Required: With sqlite-rembed removed, PROXYSQLGENAI=1 (and therefore PROXYSQL31=1) builds no longer require rustc / cargo. sqlite-vec (the C-only sibling) is preserved.
  • FFTO Enabled by Default (4.0.x): FFTO remains enabled by default in 4.0.x, providing full traffic observability out of the box. (FFTO is opt-in in 3.1.x.)
  • All 3.1.8 / 3.0.8 Improvements Included: MySQL session-variable tracking (#5166), PostgreSQL Cluster Sync (#5297), per-server PgSQL backend SSL (#5583), PgSQL backend SSL keylog (#5567), mid-transaction backend-death recovery (#5654, #5659), mysql-zstd_compression_level (#5637), mysql-resolution_family (#5554), and the caching_sha2_password hex-rounds authentication fix.
  • AI/MCP-Tier Package Coverage: The new on-demand package pipeline produces proxysql-4.0.8-* RPMs / DEBs for 13 distros × 2 architectures and proxysql-4.0.8-<sha>-macos-<arch>.tar.gz tarballs for macOS.

New Features (4.0.x)

Build Simplification

Removed Vendored sqlite-rembed and Rust Toolchain Requirement (#5616, c3266dd, 57c3e3f)

The experimental sqlite-rembed-0.0.1-alpha.9 Rust extension (previously vendored under deps/sqlite3/sqlite-rembed-source/) has been removed. The extension's hook pointer was permanently NULL in the runtime, with a TODO admitting the original integration was incomplete — so the extension was never registered at runtime in any tier, stable or GENAI.

With sqlite-rembed gone, the only consumer of rustc/cargo in the tree is removed, and the Rust toolchain detection block in deps/Makefile (along with the SQLITE3_* env exports that existed solely for the cargo build) goes with it. PROXYSQLGENAI=1 builds now succeed with rustc and cargo stripped from PATH.

Documentation in doc/GENAI.md and doc/SQLite3-Server.md has been updated to remove references to sqlite-rembed. Nine rembed-only auxiliary docs/scripts (shell demos, SQL examples, integration guide, posts-embeddings setup, MCP vector embeddings plan, python processor) are also removed. sqlite-vec (the C-only sibling) is preserved unchanged and continues to be registered under #ifdef PROXYSQLGENAI.

Known Limitation: GenAI on Older Distributions

The GenAI tier relies on C++17 features (notably std::regex::multiline) that are unavailable on the libstdc++ shipping with AlmaLinux 8 and on the libc++ shipping with openSUSE Leap 15. proxysql-4.0.8-*-almalinux8* and proxysql-4.0.8-*-opensuse15* packages are therefore not produced in this cycle. Use a newer distribution (AlmaLinux 9+, Fedora 42+, Debian 12+, Ubuntu 22.04+, openSUSE Leap 16) for the GenAI tier.

Features Inherited from v3.1.8 (Innovative Tier)

ProxySQL 4.0.8 includes all features from the v3.1.8 (Innovative) release, including:

  • FFTO Default Behavior: FFTO remains enabled by default in 4.0.x.
  • TSDB Subsystem: Behavior unchanged this cycle (warning cleanup and lint pass only).

Features Inherited from v3.0.8 (Stable Tier)

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

  • MySQL Session-Variable Tracking — new mysql-session_track_system_variables mode (DISABLED / OPTIONAL / ENFORCED) with backend-driven variable sync and per-server backoff (#5166).
  • PostgreSQL Cluster Sync — peer-to-peer sync for PgSQL admin tables with runtime checksums and save-to-disk (#5297).
  • Per-Server PgSQL Backend SSL — new pgsql_servers_ssl_params admin table mirroring mysql_servers_ssl_params (#5583).
  • PgSQL Backend SSL Keylog — NSS-format keylog for PgSQL backends via libpq PQsetSSLKeyLogCallback patch (#5567).
  • PgSQL Mid-Transaction Backend-Death Recoverypgsql-preserve_client_on_broken_backend_in_tx (default true) keeps client sessions alive across mid-tx backend death, with new pgsql_tx_poisoned_* counters (#5654, #5659).
  • PgSQL Monitor: Scheduler Clamp on Interval Change — runtime interval changes take effect immediately (#5614).
  • PgSQL CopyCmdMatcher — fast-reject + comment-tolerant regex (#5596).
  • GTID Ranged Updates — internal Gtid_Interval/GTID_Set rework + I3/I4 wire-message parsing (#5224, #5557).
  • MySQL mysql-zstd_compression_level — decoupled from zlib, range 1–22 default 3 (#5637).
  • MySQL mysql-resolution_family — deterministic IPv4/IPv6 backend hostname resolution (#5554).
  • Greeting Capabilities Restored — upper-word capability bits re-advertised in the MySQL greeting.
  • Authentication: caching_sha2_password rounds parsed as hex; CACHING_SHA2_PASSWORD() accepts an optional rounds argument (#5640).
  • Bug Fixes: MySQL 9.x charset handling in validate_charset; GR Monitor first-iteration probe; GTID range validation; GTID parser NULL check after strchr; PgSQL MD5 → EVP migration.
  • Build & Platform: macOS build support (#5664); 156 on-demand Linux package workflows + 6 macOS workflows landing in a single canonical draft release (#5662, #5666, #5668, #5671); ASAN unit-test coverage (#5618).
  • Code Quality: lint and static-analysis sweep across ~100+ files (#5594).

For a detailed list of these core improvements, please refer to the ProxySQL 3.0.8 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:

  • @wazir-ahmed for MySQL session-variable tracking (#5166), GTID range parsing and unit tests, TSDB / MCP stack maintenance, and the GTID strchr NULL-check.
  • @rahim-kanji for PostgreSQL Cluster Sync (#5297), the mid-transaction backend-death recovery (#5654, #5659), per-server PgSQL SSL parameters (#5583), PgSQL backend SSL keylog (#5567), the CopyCmdMatcher improvements (#5596), the PgSQL Monitor scheduler clamp (#5614), and the MD5→EVP migration.
  • @proton-lisandro-pin for the initial GTID interval refactor that made ranged updates possible (#5224).
  • @mirostauder for continued build system and distribution-support work.

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

Hashes

The release commit is: 6ef036a00c6f1dbcf3f27fe7f6e07f3211d7d6f8

SHA256s:

a0d752e8237d7430ce0402cc44f405167465e6d4af61f6ba5b8c553411d86caa  proxysql-4.0.8-1-almalinux10-clang.x86_64.rpm
afee23221dea2d14a1bfa70b3955d767205793ccc5e9bda0bb7063a562f183f4  proxysql-4.0.8-1-almalinux10.aarch64.rpm
a54365781a64b19404e889ddc4f9ca41c84476d05b52592b80c0c84d3b989207  proxysql-4.0.8-1-almalinux10.x86_64.rpm
0af0f13a9ffaf1327dc9f73ed9288d81a006e37c105d44d7735df3efbd1b9020  proxysql-4.0.8-1-almalinux8-clang.x86_64.rpm
e087cdd8043e22e50c4397e796288fd0bba3dae2e73e0b476966d377d20ebb2a  proxysql-4.0.8-1-almalinux9-clang.x86_64.rpm
d4b3218b69381cdf32b2a98c9d39ff254863be5222129e59b9d93f2f67fdfa51  proxysql-4.0.8-1-almalinux9.aarch64.rpm
195511daf4b6ba5a492d723e773f5f0f2480d28baa153094b16306b647624a5b  proxysql-4.0.8-1-almalinux9.x86_64.rpm
1b4de34df68be976ed845386bf59f3f21cae8a12ebdc7b9dc81d1b8608d16669  proxysql-4.0.8-1-centos10-clang.x86_64.rpm
2dd449a30e553904546a31689dc9ad567bc895b829d6523bab53c79280fe88d2  proxysql-4.0.8-1-centos10.aarch64.rpm
c00b87676efcdd14151ca6e6903d4261512042b7b59e083bd5a7a47bdec5fc17  proxysql-4.0.8-1-centos10.x86_64.rpm
a31a41ce0854da778dbbf0717d183a5c5a2f908ee2237647e361b2ce3f76f416  proxysql-4.0.8-1-centos9-clang.x86_64.rpm
35b90544d06f15843a1a2ebe173cce1512a8af674c5e397b9e2890b73e500c85  proxysql-4.0.8-1-centos9.aarch64.rpm
633904432573058dd14a406f0c34866e226fe12674702e52dd78211a5750f10b  proxysql-4.0.8-1-centos9.x86_64.rpm
6c75ad2a5dc16713f78c93220f51e28aaa232d6d048ca7f304d21fb98e20e9c9  proxysql-4.0.8-1-dbg-almalinux10.x86_64.rpm
7618f395f70e78111394413da71331ab9778d8e1feb7b556c8f5f7e96bf11a09  proxysql-4.0.8-1-dbg-almalinux9.x86_64.rpm
794eb173364a6d9f34bb8a6128e98643ec212afc548136699bc6d99034759354  proxysql-4.0.8-1-dbg-centos10.x86_64.rpm
182918b181516afd2eec4a7c7b21b87568298f5d3e8482aedb06f8106d13f0a7  proxysql-4.0.8-1-dbg-centos9.x86_64.rpm
c5f1aa0e6e34aab390734d20d7db159aaa1e5297b18e00337ebee3bea95c1fe4  proxysql-4.0.8-1-dbg-fedora42.x86_64.rpm
fa666ac3e9e55a10a10d08a1e2ce9902f26c05ba0bae5fb6b0956c5206c02486  proxysql-4.0.8-1-dbg-fedora43.x86_64.rpm
1bbc1917f9c82203e3089b3094e4b1b3111cc62c904de501d1ac06c2f3732204  proxysql-4.0.8-1-dbg-opensuse16.x86_64.rpm
75674ace4668a47a22853de405e9e4d3f2c22838ce1f1a7029ab88eb9c758b28  proxysql-4.0.8-1-fedora42-clang.x86_64.rpm
4eae9c412b5689c12fb3610d50e99157afeda9c900daffe2a833060f55ce9376  proxysql-4.0.8-1-fedora42.aarch64.rpm
b1a357dfb596eec65751403a911edf2329641ecf93552820b8f60cfa3ccacb9c  proxysql-4.0.8-1-fedora42.x86_64.rpm
e70577994e8ce44baef3d0198500641fb0b3a935b65237e19c366eaec747dedc  proxysql-4.0.8-1-fedora43-clang.x86_64.rpm
426ab9c855cbc692b796b598981c484bf8aab69db30f04e6aa9f013acc20bd0c  proxysql-4.0.8-1-fedora43.aarch64.rpm
e45b1c415e6b14fae122e7c06eb26540974c19dacde2573a01ce3628a79939f6  proxysql-4.0.8-1-fedora43.x86_64.rpm
b5aa0d57e860e1039c7bc4ff31a575d08fdca13b5a8a681c17f49f95f75badc9  proxysql-4.0.8-1-opensuse16-clang.x86_64.rpm
e7ffaa00743c32dc00bc8645f1f66781af659cdc12104a5013de7bb110b21d5d  proxysql-4.0.8-1-opensuse16.aarch64.rpm
a9e89d29eb05fca6d0b04a1fb7fa99fe1fee82663b6cc830174ffac8324464ac  proxysql-4.0.8-1-opensuse16.x86_64.rpm
cd48c831b71b50aacd66a7cfd9a32550c92f28427bc16e3dcc8bebb1c1ebfa32  proxysql_4.0.8-dbg-debian12_amd64.deb
e51454f05df55b45e4ddd881f472d14f1d0c89fac60cf9a863b10460d6e48690  proxysql_4.0.8-dbg-debian13_amd64.deb
5495e24f7d1ffe0b65081e358b373e86e392bd82d8bb2603bb2f5a829aa8a9ad  proxysql_4.0.8-dbg-ubuntu22_amd64.deb
7e7cdb48f687ca84bcc76919aaea2f7146093aadf12d601db689f38927497d28  proxysql_4.0.8-dbg-ubuntu24_amd64.deb
c29b432a5f151b45b2499a7c4b5932f429395e56f5d14c6a22e853bd0e817673  proxysql_4.0.8-debian12-clang_amd64.deb
f96d70d5760c3f88a739707d2fa0af1762112cf8a7e34e4867201cb4c7e2cc97  proxysql_4.0.8-debian12_amd64.deb
ca66bc63f8024dea1143f3cc7b1c65d905645b5045dea1d588a4bccc3fa816f7  proxysql_4.0.8-debian12_arm64.deb
7303d937100cb2c353bd2d830deb1e11553e71f462d6c43ff52dce6775910b4f  proxysql_4.0.8-debian13-clang_amd64.deb
71e6fb79768f58e6a3a6579254e33f80843613d7ea040e6675b57f31bde1fee3  proxysql_4.0.8-debian13_amd64.deb
1005fd1686522278e0653bb0e390621291a863e89c836927bc8d4674e184a5dd  proxysql_4.0.8-debian13_arm64.deb
ba02b776f58af30f7f7a6f704eb91e104888d311fe0979dbb27c380497957397  proxysql_4.0.8-ubuntu22-clang_amd64.deb
9bc6955f6e8ef56ea48adda87b17374511ec5a79a25549f2378663f5ce3ee254  proxysql_4.0.8-ubuntu22_amd64.deb
c0c3149ff0c398e8d75f94814697a9de91fdf1b67c826e74c5d7c3227bfa700e  proxysql_4.0.8-ubuntu22_arm64.deb
ecb86e698fa3991561170c0b1b2691bf435ebda36bf2eaec14b342893f6ea879  proxysql_4.0.8-ubuntu24-clang_amd64.deb
c6449c5e76db4d612fe418b6a7a4a82ea7d70ae36124e08c7ede10f414b63f49  proxysql_4.0.8-ubuntu24_amd64.deb
f723ef022b6de76749972905271757423aad766029f0f251d11887e3b51de340  proxysql_4.0.8-ubuntu24_arm64.deb

Don't miss a new proxysql release

NewReleases is sending notifications on new releases.