DBLE 2.19.07.0 Release Notes and Detailed Analysis

This document presents a detailed analysis of the DBLE 2.19.07.0 release.

Project Introduction : DBLE (also known as “MyCat Plus”) is an enterprise‑grade open‑source distributed middleware offering data sharding, read/write separation, distributed transaction support, and global ID management.

New Version Overview : The release adds 10 new or refactored features, fixes 22 defects, and makes 4 backward‑compatibility adjustments. Contributors are acknowledged, and users are encouraged to download the latest tarball from the official GitHub releases page.

Main Updates :

Support for richer data import/export tools (Workbench, DBeaver, mysqldump, Navicat, and MySQL source/load data commands). Important notes for mysqldump usage are provided, including the required command syntax: ./mysqldump -h127.0.0.1 -utest -P3306 -p111111 --default-character-set=utf8 --master-data=2 \ --single-transaction --set-gtid-purged=off --hex-blob --databases schema1 > export.sql

Enhanced show commands (issue #759) with new manager commands such as show @@user , show @@datasource , show @@datasource.synstatus , show @@datasource.syndetail where name=? , and show @@datasource.cluster .

Text protocol extensions (issues #1356, #1326) adding COM_CHANGE_USER , COM_RESET_CONNECTION , and COM_SET_OPTION to support connection reset, credential change, and option toggling.

Full Release Notes and Translation :

Features include new commands ( release @@reload_metadata , show @@reload_status ), support for creating FUNCTIONS, heartbeat logic refactoring, and more. The bug‑fix list covers issues such as reload configuration leaks, duplicate global sequence values, ZK cluster restart failures, invalid parameters, view handling errors, and numerous SQL execution problems.

Compatibility changes remove deprecated properties (e.g., useOldMetaInit ), switch default charset to utf8mb4 , and adjust column names containing connection IDs.

Overall, the release enhances DBLE’s functionality, stability, and compatibility while providing extensive documentation and translation for the community.