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 props: first-n: 3 last-m: 4 replace-char: '*' 9.1. ShardingSphere-JDBC 75 Apache ShardingSphere document Read the YAML configuration to create a data source according 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

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 props: first-n: 3 last-m: 4 replace-char: '*' 9.1. ShardingSphere-JDBC 76 Apache ShardingSphere document Read the YAML configuration to create a data source according 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

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 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 offline, write data source shardingsphere.dbdiscovery.api.config.rule.DatabaseDiscoveryHeartBeatConfiguration Attributes: • N a m e * • Da ta T yp e* Description p r o p s ( + ) Pr op er ti es Detect heartbeat attribute configuration

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 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 offline, write data source shardingsphere.dbdiscovery.api.config.rule.DatabaseDiscoveryHeartBeatConfiguration Attributes: • N a m e * • Da ta T yp e* Description p r o p s ( + ) Pr op er ti es Detect heartbeat attribute configuration

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 (value,⋯),(value,⋯),⋯ Y INSERT INTO table (column,⋯) SELECT column1 from table1 where column1 = value1 N • SELECT/UPDATE/DELETE 4.9. Shadow DB 61 Apache ShardingSphere document, v5.1.1 • Condition* SQL SELECT/UPDATE/DELETE ⋯ WHERE column BETWEEN value1 AND value2 N GROUP BY ⋯HAVING⋯ SELECT/UPDATE/DELETE ⋯ WHERE ⋯GROUP BY column HAVING column > value N Subquery SELECT/UPDATE/DELETE ⋯ WHERE column = (SELECT

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 (value,⋯),(value,⋯),⋯ Y INSERT INTO table (column,⋯) SELECT column1 from table1 where column1 = value1 N • SELECT/UPDATE/DELETE • Condition* SQL S upp ort ed = SELECT/UPDATE/DELETE ⋯ WHERE column = value SELECT/UPDATE/DELETE ⋯ WHERE column BETWEEN value1 AND value2 N GROUP BY ⋯HAVING⋯ SELECT/UPDATE/DELETE ⋯ WHERE ⋯GROUP BY column HAVING column > value N Subquery SELECT/UPDATE/DELETE ⋯ WHERE column = (SELECT

ReadwriteSplittingRuleConfiguration Attributes: • Name* DataType Description d ataSo urces (+) Collectio n Data sources of write and reads loa dBala ncers (*) EncryptRuleConfiguration Attributes: Name DataType Description D ef au lt Va lu e tables (+) Collectio n Encrypt table rule configurations encr yptors (+) MapN a m e * Data Type Description t y p e String Standalone r e p o s i t o r y Per sistRepos itoryConf

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‐ select id, name, age, count(*) as n, (select id, name, age, sex from table2 where id=2) as sid, yyyy from table1 where id=1; SELECT id , name , age , COUNT(*) AS n, ( SELECT id , name For the item to be sorted which has its own order, merger ordering only has the time complexity of O(n), with a very low performance consumption. 3.1. Sharding 57 Apache ShardingSphere document, v5.0.0-beta

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 props: first-n: 3 last-m: 4 replace-char: '*' 然后通过 YamlShardingSphereDataSourceFactory 的 createDataSource 方法创建数据源。 9.1. ShardingSphere-JDBC 68 Apache ShardingSphere shardingsphere.encrypt.api.config.EncryptRuleConfiguration 可配置属性： 名称 数据类型 说明 默认值 tables (+) Collectio n 加密表规则配置 encryptors (+) Map 加解密算法名称和配置