DBLE Middleware: Overview, New Pure Read/Write Splitting Feature in v3.20.10.0, and Implicit Commit Support Matrix

Author: Ma Yingle, member of the ActionSky R&D team responsible for DBLE testing.

DBLE is a high‑scalable distributed middleware based on MySQL, offering features such as horizontal data sharding, MySQL compatibility, high availability, full SQL‑92 and MySQL dialect support, complex query optimization, and distributed transaction support via two‑phase commit (ordinary or XA mode).

1. DBLE Overview

Project address: https://github.com/actiontech/dble

2. Pure Read/Write Splitting in Version 3.20.10.0

Version 3.20.10.0 introduces a pure read/write splitting capability independent of sharding, with further improvements in version 3.21.02.0. Documentation: Read/Write Split . Release notes: Release Notes .

3. Implicit Commit Support in DBLE Read/Write Splitting

The following table lists SQL statements that trigger implicit commits and indicates whether they are supported by DBLE.

No.

Triggering SQL

Supported?

1

ALTER EVENT test

Supported

2

ALTER FUNCTION test

Supported

3

ALTER PROCEDURE test

Supported

4

ALTER SERVER test

Supported

5

ALTER TABLE test

Supported

6

ALTER VIEW test

Supported

7

CREATE DATABASE test

Supported

8

CREATE EVENT test

Supported

9

CREATE FUNCTION test

Supported

10

CREATE INDEX test

Supported

11

CREATE PROCEDURE test

Supported

12

CREATE ROLE test

Supported (MySQL 8.0)

13

CREATE SERVER test

Supported

14

CREATE SPATIAL REFERENCE SYSTEM

Supported (MySQL 8.0)

15

CREATE TABLE test

Supported

16

CREATE TRIGGER test

Supported

17

CREATE VIEW test

Supported

18

DROP DATABASE test

Supported

19

DROP EVENT test

Supported

20

DROP FUNCTION test

Supported

21

DROP INDEX test

Supported

22

DROP PROCEDURE test

Supported

23

DROP ROLE test

Supported (MySQL 8.0)

24

DROP SERVER test

Supported

25

DROP SPATIAL REFERENCE SYSTEM

Supported (MySQL 8.0)

26

DROP TABLE test

Supported

27

DROP TRIGGER test

Supported

28

DROP VIEW test

Supported

29

INSTALL PLUGIN test

Supported

30

RENAME TABLE test

Supported

31

TRUNCATE TABLE test

Supported

32

UNINSTALL PLUGIN

Supported

33

ALTER USER test

Supported

34

CREATE USER test

Supported

35

DROP USER test

Supported

36

GRANT test

Supported

37

RENAME USER test

Supported

38

REVOKE test

Supported

39

SET PASSWORD

Not supported (limited by druid)

40

BEGIN

Supported

41

LOCK TABLES test

Supported

42

START TRANSACTION test

Supported

43

LOAD DATA test

Not supported

44

SET autocommit = 1

Supported

45

ANALYZE TABLE test

Not supported

46

CACHE INDEX test

Not supported

47

CHECK TABLE test

Not supported

48

FLUSH

Not supported

49

LOAD INDEX INTO CACHE

Not supported

50

OPTIMIZE TABLE test

Not supported

51

REPAIR TABLE test

Not supported

52

RESET test

Not supported

53

START SLAVE test

Not supported

54

STOP SLAVE

Not supported

55

RESET SLAVE

Not supported

56

CHANGE MASTER TO

Not supported

Keywords: #ImplicitCommit#