Getting Started with DBLE: Installation, Basic, Advanced, and Analysis Features

In the previous session we introduced the basic overview of DBLE; this article now dives into four main parts.

Course outline: The structure includes installation demo, basic functions, advanced functions, and analysis features.

1. Installation demo: Two rapid‑start methods are presented to help users quickly set up DBLE without prior knowledge of its architecture.

2. Basic functions: The middleware’s core capabilities are explained, including typical database CRUD operations, data sharding techniques, and related utilities.

3. Advanced functions: Topics such as global sequence handling and management of application‑side features are covered.

4. Analysis functions: These are operations‑friendly tools that allow users to examine SQL statements, review query execution plans, identify slow queries, and understand where performance bottlenecks occur, including how to collect and use slow‑query logs.

Quick installation: Using Docker, the environment can be set up with just two commands, assuming Docker and Docker‑compose are already installed.

First, wget the Docker‑compose configuration file from the GitHub repository. The compose file defines three nodes: two MySQL instances and one DBLE server.

The compose setup exposes ports such as MySQL 33061 and DBLE 8066/9066. Running docker-compose up brings the entire environment up automatically.

After the containers start, you can connect via a MySQL client, execute SHOW TABLES , and use DBLE‑specific commands like SHOW FULL TABLES or SHOW ALL TABLES to view table types (e.g., split tables, global tables).

Using Docker for this quick test environment greatly reduces the complexity compared with manual MySQL installation, allowing developers to focus on core problems.

This concludes the introduction.

Relevant code repositories: https://github.com/actiontech/dble , https://github.com/actiontech/dble-docs-cn , https://github.com/actiontech/dble-test-suite .

For course inquiries, contact the ActionTech Open Source Community via the WeChat public account "ActiontechOSS" or join the official technical group (ID 669663113).