Interview with Yan Huqing on Quickly Getting Started with Distributed Middleware Dble

On July 27, the 3306π community will host a Shanghai meetup featuring Yan Huqing, senior software engineer at iKangSheng and lead of the open‑source DBLE project, who also authored the training "2‑Hour Quick Start to Distributed Middleware Dble".

Yan introduces himself, his experience with read‑write separation, data replication, and MySQL source code, and explains his role in developing Dble, a MySQL‑focused distributed middleware that evolved from Mycat.

The meetup agenda includes a live installation demo, an overview of Dble’s core features (topology, split algorithms, global/ER tables, hints, cross‑database queries), advanced functions (global sequences, management port, hot‑update, black‑white list), and high‑level analysis tools (slow‑query log, EXPLAIN, TRACE).

In the interview, Yan discusses how Dble addresses Mycat’s shortcomings, the importance of using ER and global tables to avoid cross‑database queries, and recommends limiting sharding, avoiding distributed transactions when possible, and leveraging query plans, trace, and slow‑log features.

He shares best practices for sharding and read‑write separation, cites a large‑scale financial customer using Dble with a proprietary DB management platform, and describes quality‑assurance processes such as static analysis tools, extensive automated test suites, continuous regression testing, and rigorous code reviews.

Yan also notes that release cycles have shifted from monthly to bimonthly to allow more substantial refactoring and feature development.