Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts sharding tables can also lead to the full use of local transactions when single‐table data amount de‐ creases. Troubles brought by distributed transactions can be avoided by the wise use of different Less More Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No ShardingSphere‐JDBC is suitable for java application

Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts sharding tables can also lead to the full use of local transactions when single‐table data amount de‐ creases. Troubles brought by distributed transactions can be avoided by the wise use of different 1. Sharding 27 Apache ShardingSphere document, v5.0.0-beta sql formatedSql select a+1 as b, name n from table1 join ta‐ ble2 where id=1 and name=‘lu’; SELECT a + 1 AS b, name nFROM table1 JOIN ta‐

Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts sharding tables can also lead to the full use of local transactions when single‐table data amount de‐ creases. Troubles brought by distributed transactions can be avoided by the wise use of different complexity of O(mn(log m)), and the number of shard m is generally small enough to be considered as O(n), with a very low performance consumption. Secondly, ShardingSphere further optimizes the query that

Full support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as paging, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements Parameters Class name: org.apache.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 a T y p e * Description De fault V alue aut oAwareData SourceName S t r i n g Database discovery logic data source name • writeDa taSourceQu eryEnabled (?) S t r i n g All read data source are

Low High Supported Languages Java Only Any Any Performance Low loss Relatively High loss Low loss De centralization Yes No No Static Entry No Yes No 1.1.4 Hybrid Architecture ShardingSphere‐JDBC adopts sharding tables can also lead to the full use of local transactions when single‐table data amount de‐ creases. Troubles brought by distributed transactions can be avoided by the wise use of different complexity of O(mn(log m)), and the number of shard m is generally small enough to be considered as O(n), with a very low performance consumption. Secondly, ShardingSphere further optimizes the query that

migrate the data from other data sources, while simul‐ taneously performing data sharding. Q ue ry Fe de ra ti on Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Full support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as pag‐ ing, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements keep_first_n_last_m_mask maskAlgorithms: md5_mask: type: MD5 mask_before_special_chars_mask: type: MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask:

migrate the data from other data sources, while simul‐ taneously performing data sharding. Q ue ry Fe de ra ti on Federated queries are effective in utilizing data in a complex data environment. Sharding‐ Full support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as pag‐ ing, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements keep_first_n_last_m_mask maskAlgorithms: md5_mask: type: MD5 mask_before_special_chars_mask: type: MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask:

Full support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as paging, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements Parameters Class name: org.apache.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 dingStrategy (?) ShardingStr ategyCon‐ figuration Default table sharding strategy Not sharding de faultKeyGene rateS‐ trategy (?) KeyGene ratorConfig‐ uration Default key generator S nowflake

something by sharding item 1 break; case 2: // do something by sharding item 2 break; // case n: ... } } } 5 Apache ShardingSphere ElasticJob document 4.3 Configure Job JobConfiguration jobConfig items to 1 and more than 1 servers to execute the jobs makes the job run in the mode of 1 master and n slaves. Once the servers that are executing jobs are down, the idle servers will take over the jobs 2. Elastic Schedule 11 Apache ShardingSphere ElasticJob document C hild node name Eph eme ral n ode Description inst ance NO The primary key of the job running instance that executes the shard

keep_first_n_last_m_mask maskAlgorithms: md5_mask: type: MD5 mask_before_special_chars_mask: type: MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask: k: type: KEEP_FIRST_N_LAST_M 9.1. ShardingSphere-JDBC 68 Apache ShardingSphere document props: first-n: 3 last-m: 4 replace-char: '*' 然后通过 YamlShardingSphereDataSourceFactory 的 createDataSource shardingsphere.encrypt.config.EncryptRuleConfiguration 可配置属性： 名称 数据类型 说明 默认值 tables (+) Collectio n 加密表规则配置 encryptors (+) Map 加解密算法名称和配置