Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5 Roadmap 45 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Source . . Architecture 10 4 Running Modes Apache ShardingSphere provides two running modes: standalone mode and cluster mode. 4.1 Standalone Mode It can achieve data persistence in terms of metadata information such

4.1 Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 1.5 Roadmap . 42 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Source . . requirement for a data storage and computing platform. Guar‐ antee the HA of your distributed database cluster with ShardingSphere’s Operator on Ku‐ bernetes, and the native HA of your existing data sources

. 10 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2 Quick Start 43 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Source . . 2.0 1.3.2 Running Modes Apache ShardingSphere provides two running modes: standalone mode and cluster mode. Standalone mode It can achieve data persistence in terms of metadata information such as

Standalone Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2 Cluster Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5 Roadmap 45 Nodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Cluster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Source . . . . . . . . . . . . . . . . 546 13.1.2 MODE What is the difference between cluster mode Cluster and Compati- ble_Cluster? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 546 13

3 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . users for quick test startup, stand‐alone running and cluster running, Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5 create a .shardingsphere file in the root directory to store configuration data by default. 3.2.4 Cluster mode Suitable for use in distributed scenarios which provides metadata sharing and state coordination

Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 i 3.2.4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . SQL92 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 4.2 Cluster Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 4.2.1 Background users for quick test startup, stand‐alone running and cluster running, Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5

3 Standalone mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . users for quick test startup, stand‐alone running and cluster running, Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5 create a .shardingsphere file in the root directory to store configuration data by default. 3.2.4 Cluster mode Suitable for use in distributed scenarios which provides metadata sharing and state coordination

transaction, and com‐ mit/rollback is executed through TC coordination. A typical lifecycle of Seata managed distributed transaction: 1. TM asks TC to begin a new global transaction. TC generates a XID representing clusters has gradually become a trend. In this case, how to efficiently and automatically manage cluster nodes, realize the collaborative work of different nodes, configuration consistency, state consistency modules: governance, observability and cluster management(in plan). 3.4.2 Challenges The challenges of distributed governance mainly lie in the complexity of cluster management and how to connect various

communi‐ cations with the registry will be generated, which will affect the performance of the cluster; Moreover, short‐interval jobs do not necessarily pay attention to the real‐time performance of way of DI (Dependency Injection), developers can easily use data sources and other objects that managed by the Spring container in their jobs, and use placeholders to get values from property files

时，需要引入此模块 --> org.apache.shardingsphere shardingsphere-cluster-mode-repository-zookeeper-curator ${shardingsphere.version} 5.1. ShardingSphere-JDBC 83 Apache ShardingSphere document, v5.0.0 shardingsphere-cluster-mode-repository-etcd ${shardingsphere.version} 规则配置 -data-source ", "localhost:2181", new Properties()); // 配置 Cluster Config ModeConfiguration modeConfig = new ModeConfiguration("Cluster", registryCenterConfig, true); // 创建 ShardingSphereDataSource