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

DBLE is an enterprise‑grade open‑source distributed middleware, often nicknamed “MyCat Plus”, known for its simplicity, stability, and active community support.

Project Introduction

Official repository: https://github.com/actiontech/dble

Documentation (updated): https://actiontech.github.io/dble-docs-cn

Release downloads and notes: https://github.com/actiontech/dble/releases

New Version Main Updates (3.23.08.0)

1. Support for OLAP/OLTP mixed workload

Added hybridTAU users; DBLE now routes TP‑type SQL to MySQL and AP‑type SQL to ClickHouse, automatically recognizing and dispatching mixed workloads.

TP/AP routing rules:

SELECT statements containing aggregation functions (min, sum, count, avg, max, STDDEV_*, VAR_*, GROUP BY) are sent to AP.

Transactions are sent to TP because ClickHouse does not support transactions.

DML (INSERT/UPDATE/DELETE) is sent to TP due to MySQL‑ClickHouse binlog synchronization constraints.

2. Internal thread hang detection and interrupt/recover operations

DBLE can now detect suspected hangs in internal timer threads (Timer/TimerScheduler) and generate alerts in dble.log . It also supports interrupting and recovering specific threads via commands such as thread @@print , thread @@kill name='?' , and thread @@recover name='?' .

Full Release Notes

Feature: [#3831] Support OLAP/OLTP mixed load.

Feature: [#3832] ManagerFrontWorker now manages its own thread pool.

Feature: [#3833] Monitor selected timer threads and allow interrupt operations.

Feature: [#3834] Optimize and unify internal statistics.

Feature: [#3838] Strengthen handling of captured thread error exceptions.

Bug Fixes

[#3835] Long‑running asynchronous initialization tasks during startup.

[#3836] Inconsistent lower_case_table_name handling causing unexpected behavior.

Various DDL issues resolved.

ClickHouse sync variable errors fixed during reload.

ChildTable now supports specifyCharset attribute.

Incompatibilities with previous versions

[#3834] Changes to internal statistics collection may affect existing monitoring setups.

LTS Version Updates

3.22.11.1 – bug‑fix release addressing connection‑pool logic, hang scenarios, multi‑table UPDATE/DELETE support, half‑connection handling, transaction rollback issues, and connection‑pool eviction thread crashes.

3.22.01.6 – bug‑fix release covering transaction rollback after master‑slave switch, SQL statistics dead‑lock, connection‑pool eviction thread stability, slow‑log blockage, sequence configuration optimizations, and other NPE fixes.

3.21.10.15 – bug‑fix release fixing datetime precision loss in max , null handling for white_ips , sequence configuration, and miscellaneous NPEs.

References

[1] HTAP documentation: https://actiontech.github.io/dble-docs-cn/history/develop/2.Function/2.39_HTAP.html

[2] Configuration details: https://actiontech.github.io/dble-docs-cn/history/develop/1.config_file/1.02_bootstrap.cnf.html

[3] Thread command guide: https://actiontech.github.io/dble-docs-cn/history/develop/2.Function/2.40_thread_cmd.html

[4] Version change details: https://actiontech.github.io/dble-docs-cn/history/develop/1.config_file/1.10_version_change.html#config-title-3.23.08.0