Installing and Configuring DBLE with Docker and MySQL

In the previous episode we introduced installing DBLE via Docker; this article shows the traditional installation method while still using Docker to run two MySQL containers as the backend databases.

First, download the DBLE release from GitHub, unzip it to create a dble directory, then start two MySQL containers with Docker, mapping host ports 33061 and 33062 to the containers' default 3306 ports.

Next, configure DBLE by copying the three XML template files to their final names and editing schema.xml. The configuration defines two datahosts, each with a writehost that points to the corresponding MySQL container (IP, port, username, password). Unnecessary template entries are removed to keep the file clean.

Start DBLE by executing the start script in the bin directory. Verify the startup by checking the log for a “successfully” message or by running ps and grepping for DBLE processes. Connect to DBLE on port 8066 and run commands such as show databases to see the two configured logical databases.

Use the DBLE management console on port 9066 (user manager) to create the physical databases on the MySQL nodes. After the databases exist, source a tempable_table.sql file to create tables and insert initial data. Verify with show tables, show all tables, and show create table, confirming that both split and non‑split tables work correctly.

Note that query result order may vary because DBLE does not guarantee ordering without an ORDER BY clause; routing is based on modulus, so rows may be distributed across different data nodes.

For further reference, the DBLE source code and documentation are available at the GitHub links provided, and contact information for the community and course inquiries is listed at the end of the article.