DBLE 3.23.04.0 Release Notes: New Features, Bug Fixes, and LTS Updates

DBLE is an enterprise‑grade open‑source distributed middleware, nicknamed “MyCat Plus”, known for its simplicity, stability, active community support, and extensive feature set such as data horizontal sharding, read‑write splitting, distributed transaction support, global ID generation, and IP/SQL black‑white lists.

The 3.23.04.0 release adds six new or refactored functionalities, resolves more than five important community defects and over one hundred bugs, and adjusts one incompatibility with previous versions.

New Features

Support for multi‑table UPDATE/DELETE when a sharded table joins a global table, with detailed routing conditions.

TCP keep‑alive related parameters can now be configured via bootstrap.cnf , affecting only DBLE connections (experimental, JDK‑version dependent).

Bug Fixes

Fix for read‑write splitting when MySQL auto‑increment step is not 1, preventing incorrect data insertion.

Fix for large packet size limit using maxPacketSize in read‑write splitting mode.

Resolution of occasional exit of the connection‑pool‑evictor‑thread during scaling operations.

Rollback failures after master‑slave switch, missing data rollbacks, and various NPE issues.

Improvements to connection pool logic, half‑connection handling, and memory leak prevention during large batch statements.

Incompatibilities with Previous Versions

Adjusted rule for the -DfakeMysqlVersion parameter in read‑write splitting mode.

LTS Version Updates

3.22.07.3 – bug‑fix release based on 3.22.07.01, addressing hangs, lost connections, memory leaks on non‑sharding‑key joins, LOAD DATA local errors, and master instance network failures.

3.22.01.5 – bug‑fix release based on 3.22.01.4, improving connection pool retrieval, handling half‑connections, supporting multi‑table UPDATE/DELETE for sharded‑global joins, and fixing rollback issues.

3.21.10.14 – bug‑fix release based on 3.22.10.12, fixing CPU spikes due to SQL statistics lock contention, connection‑pool‑evictor‑thread exits, and other stability problems.

Reference links are provided for detailed documentation of UPDATE, DELETE, version changes, and TCP parameter configuration.