Distributed | dble pure read-write separation function-summary of implicit submission support

Author: Ma Yingle

A member of the R&D team of Aikesheng, responsible for the testing of mysql middleware. I am a testing technology enthusiast, welcome everyone to try the new dble function~

Source of this article: original submission

* Produced by the Aikesheng open source community, original content is not allowed to be used without authorization, please contact the editor and indicate the source for reprinting.

One, dble introduction

dble is Shanghai Aikesheng Information Technology Co., Ltd. a highly scalable distributed middleware based on mysql. It has the following advantages:

• Data horizontal split

  As your business grows, you can use dble to replace the original single MySQL instance.

• compatible with Mysql

  It is compatible with the MySQL protocol. In most cases, you can replace MySQL with it to provide new storage for your application without changing any code.

• high availability

  The dble server can be used as a cluster, and the business will not be affected by a single node failure.

• SQL support

  Supports SQL 92 standard and MySQL dialect. We support complex SQL queries, such as group by, order by, distinct, join, union, sub-query, etc.

• Complex query optimization

  Optimize complex queries, including but not limited to global table join shard tables, ER relational tables, sub-queries, simplified selection items, etc.

• Distributed transaction support

  Distributed transactions using two-phase commit. You can choose normal mode for performance or use XA mode for data security. Of course, the XA mode depends on the XA Transaction of MySQL-5.7, the high availability of MySQL nodes and the reliability of data.

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

2. dble introduced pure read-write separation function in version 3.20.10.0

pure read-write separation function which is independent of the sub-database and sub-table business function in Release Notes , and made further improvements in the just released version 3.21.02.0~

3. Implicit submission support in dble read-write separation

No.	Sql that triggers implicit commit	Does it support
1	ALTER EVENT test	stand by
2	ALTER FUNCTION test	stand by
3	ALTER PROCEDURE test	stand by
4	ALTER SERVER test	stand by
5	ALTER TABLE test	stand by
6	ALTER VIEW test	stand by
7	CREATE DATABASE test	stand by
8	CREATE EVENT test	stand by
9	CREATE FUNCTION test	stand by
10	CREATE INDEX test	stand by
11	CREATE PROCEDURE test	stand by
12	CREATE ROLE test	Support (MySQL8.0)
13	CREATE SERVER test	stand by
14	CREATE SPATIAL REFERENCE SYSTEM	Support (MySQL8.0)
15	CREATE TABLE test	stand by
16	CREATE TRIGGER test	stand by
17	CREATE VIEW test	stand by
18	DROP DATABASE test	stand by
19	DROP EVENT test	stand by
20	DROP FUNCTION test	stand by
21	DROP INDEX test	stand by
22	DROP PROCEDURE test	stand by
23	DROP ROLE test	Support (MySQL8.0)
24	DROP SERVER test	stand by
25	DROP SPATIAL REFERENCE SYSTEM	Support (MySQL8.0)
26	DROP TABLE test	stand by
27	DROP TRIGGER test	stand by
28	DROP VIEW test	stand by
29	INSTALL PLUGIN test	stand by
30	RENAME TABLE test	stand by
31	TRUNCATE TABLE test	stand by
32	UNINSTALL PLUGIN	stand by
33	ALTER USER test	stand by
34	CREATE USER test	stand by
35	DROP USER test	stand by
36	GRANT test	stand by
37	RENAME USER test	stand by
38	REVOKE test	stand by
39	SET PASSWORD	Not supported (limited by druid)
40	BEGIN	stand by
41	LOCK TABLES test	stand by
42	START TRANSACTION test	stand by
43	LOAD DATA test	not support
44	SET autocommit = 1	stand by
45	ANALYZE TABLE test	not support
46	CACHE INDEX test	not support
47	CHECK TABLE test	not support
48	FLUSH	not support
49	LOAD INDEX INTO CACHE	not support
50	OPTIMIZE TABLE test	not support
51	REPAIR TABLE test	not support
52	RESET test	not support
53	START SLAVE test	not support
54	STOP SLAVE	not support
55	RESET SLAVE	not support
56	CHANGE MASTER TO	not support