DBLE 3.22.01.0 Release Notes – New Features, Bug Fixes, and Full Details

DBLE (also known as “MyCat Plus”) is an enterprise‑grade open‑source distributed middleware that offers data sharding, read/write separation, distributed transaction support, and a rich set of features such as global IDs and IP/SQL black‑white lists.

The 3.22.01.0 version, the second release of the year, adds and refactors seven major functionalities, resolves more than four critical community defects, patches over one hundred bugs, and makes no incompatibility adjustments with previous versions.

Key new features:

Enhanced read/write separation with traffic control to prevent OOM caused by excessive SQL traffic and a sticky‑session mechanism (rwStickyTime) that routes reads to the primary instance when recent writes occurred.

Support for ClickHouse as an analytical backend disguised as a MySQL server, allowing special analytical users and databases to connect.

Hint‑based query plan specification, enabling users to influence execution order and optimization strategies.

Complete Release Notes:

Features:

[#3230] ClickHouse support as MySQL backend.

[#3231] Unified thread and parameter names.

[#2968] Connection stickiness added to read/write separation to avoid dirty reads.

[#3229] DDL log optimization.

[#3232] Traffic control for read/write separation.

[#3233] Split command optimization.

[#3234] Hint‑based query plan ordering support.

Major bug fixes:

[#3175] Incorrect data returned for smallInt columns.

[#3160] Routing failure when shard key is wrapped with backticks in UPDATE statements.

[#3132] Inaccurate parameter naming.

[#3063] Incorrect routing when partition field lacks alias in WHERE clause.

Incompatibilities with previous versions:

[#3231] Change of thread names.

Additional resources include the official DBLE GitHub repository, updated documentation, download links for the release, and community courses such as “DBLE Quick Start” and “DBLE Public Course”.