document, v5.2.1 type: # Database discovery type, such as: MySQL.MGR props (?): group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # Required parameters for database discovery types, such as MGR's group-name shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster api.ReadwriteSplittingRuleConfiguration Configurable Properties: • Name* DataType Description d ataSo urces (+) Colle ction Data sources of write

discovery type name type: # Database discovery type, such as: MySQL.MGR props (?): group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # Required parameters for database discovery types, such as MGR's group-name shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster Collection Binding table rules E mpty broadcastTables (*) Collection Broadcast table rules E mpty d efaultDatabaseS hardingStrategy (?) Sharding StrategyCon‐ figuration Default database sharding

Database Gateway Stress T esting Data Sharding Data Encrypt Heterogeneous Databases Sup‐ ported Shadow D atabase Readwrit e‐ splitting Row Authority (TODO) SQL Dialect Translate (TODO) Observ ability Rule Query Language) responsible for the query of resources and rules; • RAL (Resource & Rule Administration Language) responsible for the added‐on administrator fea‐ ture of hint, transaction type switch quicker startup with -A │ Database changed │Database changed MySQL [test1]> XA START '61c052438d3eb'; │MySQL [test2]> XA START '61c0524390927'; Query OK, 0 rows affected (0.030 sec) │Query OK, 0

database solution based on the underlying database, which can scale computing and storage horizontally. D is tr ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster parser.api.CacheOption Attributes: 9.1. ShardingSphere-JDBC 114 Apache ShardingSphere document na me • D a t a T y p e * Des cription Default Value ini tia lCa pac ity i n t Initial capacity of local

Database Gateway Stress T esting Data Sharding Data Encrypt Multi‐model Databases Sup‐ ported Shadow D atabase Readwrit e‐ splitting Row Authority (TODO) SQL Dialect Translate (TODO) Observ ability Rule Query Language) responsible for the query of resources and rules; • RAL (Resource & Rule Administration Language) responsible for the added‐on administrator fea‐ ture of hint, transaction type switch ├──circuit_breaker ├ ├ ├ ├──${your_instance_ip_c}@${your_instance_port_v} ├ ├ ├ ├──${your_instance_ip_d}@${your_instance_port_w} ├ ├ ├ ├──.... ├ ├──storage_nodes ├ ├ ├──disable 4.5. Governance 50 Apache

HTTP, file, big data – Focus business SDK, can work with Spring IOC • Admin Console – Job administration – Job event trace query – Registry center management 3 3 Environment Required 3.1 Java 5.2. Elastic Schedule 12 Apache ShardingSphere ElasticJob document C hi ld no de na me E p h e m e r a l n o d e Description el ec ti on :r aw ‐l at ex :ˋ i ns ta nc eˋ Y E S The IP address of the handling strategies can be used. Error handler strat- egy name Description • B u i l t - i n * • D e f a u l t * E xtra con fig Log Strategy Log error and do not interrupt job Y e s Y e s Throw

database solution based on the underlying database, which can scale computing and storage horizontally. D is tr ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and pagination, sorting, and aggregation queries. In terms of business implementation, it can enable R&D personnel to no longer care about the scope of SQL usage, focus on business function development, and shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster

Database Gateway Stress T esting Data Sharding Data Encrypt Heterogeneous Databases Sup‐ ported Shadow D atabase Readwrit e‐ splitting Row Authority (TODO) SQL Dialect Translate (TODO) Observ ability Rule Query Language) responsible for the query of resources and rules; • RAL (Resource & Rule Administration Language) responsible for the added‐on administrator fea‐ ture of hint, transaction type switch quicker startup with -A │ Database changed │Database changed MySQL [test1]> XA START '61c052438d3eb'; │MySQL [test2]> XA START '61c0524390927'; Query OK, 0 rows affected (0.030 sec) │Query OK, 0

Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询 等管理功能。 3.3. DistSQL 14 Apache ShardingSphere document, v5 quicker startup with -A │ Database changed │Database changed MySQL [test1]> XA START '61c052438d3eb'; │MySQL [test2]> XA START '61c0524390927'; Query OK, 0 rows affected (0.030 sec) │Query OK, 0 XA END '61c052438d3eb'; │MySQL [test2]> XA END '61c0524390927'; Query OK, 0 rows affected (0.006 sec) │Query OK, 0 rows affected (0.008 sec) │ MySQL [test1]> XA PREPARE '61c052438d3eb'; │MySQL [test2]>

Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询 等管理功能。 3.3.3 目标 打破中间件和数据库之间的界限，让开发者像使用数据库一样使用 Apache ShardingSphere，是 ├──circuit_breaker ├ ├ ├ ├──${your_instance_ip_c}@${your_instance_port_v} ├ ├ ├ ├──${your_instance_ip_d}@${your_instance_port_w} ├ ├ ├ ├──.... ├ ├──storage_nodes ├ ├ ├──disable ├ ├ ├ ├──${schema_1.ds_0} 算法类型的详情，请参见内置分布式序列算法列表。 读写分离 配置入口 类名称：ReadwriteSplittingRuleConfiguration 可配置属性： 名称 数据类型 说明 d ataSources (+) Collection 读写数据源配置 loa dBalancers