. . . . . . . . . . . . . . . . . . . . . . . . . 467 11.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 467 Objectives . . . . . . . . . . . . . . . . . . . . . . . Involved ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm 2. Rule configuration. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx

. . . . . . . . . . . . . . . . . . . . . . . . . 496 11.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 496 Objectives . . . . . . . . . . . . . . . . . . . . . . . Involved ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 13 7 Quick Start In shortest time, this chapter provides ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm 2. Rule configuration. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/global.yaml. Edit %SHARDINGSPHERE_PROXY_HO

ShardingSphere‐Proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.1 Rule Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.2 Import Dependencies ShardingSphere‐Scaling (Experimental) . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.3.1 Rule Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.3.2 Import Dependencies Overall Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 Encryption Rule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 Encryption Process .

2.2.1 Get ShardingSphere‐Proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.2 Rule Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.3 Import Dependencies Overall Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 Encryption Rule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 Encryption Process . Overall Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 301 7.6.2 Shadow Rule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 302 7.6.3 Routing Process

AlgorithmConfiguration> 从库负载均衡算法配 置 主从数据源配置 类名称：org.apache.shardingsphere.readwritesplitting.api.rule.ReadwriteSplittingDataSourceRuleConfiguration 可配置属性： 算法类型的详情，请参见内置负载均衡算法列表。 操作步骤 1. 添加读写分离数据源 Map 加解密算法名称和配置 加密表规则配置 类名称：org.apache.shardingsphere.encrypt.api.config.rule.EncryptTableRuleConfiguration 可配置属性： 名称 数据类型 说明 name String 表名称 columns (+) Collection 加密列规则配置列表 加密列规则配置 类名称：org.apache.shardingsphere.encrypt.api.config.rule.EncryptColumnRuleConfiguration 可配置属性： 名称 数据类型 说明 name String 逻辑列名称 cipher EncryptColumnItemRuleConfiguration

AlgorithmConfiguration> 从库负载均衡算法配 置 主从数据源配置 类名称：org.apache.shardingsphere.readwritesplitting.api.rule.ReadwriteSplittingDataSourceRuleConfiguration 可配置属性： 算法类型的详情，请参见内置负载均衡算法列表。 操作步骤 1. 添加读写分离数据源 Map 加解密算法名称和配置 加密表规则配置 类名称：org.apache.shardingsphere.encrypt.api.config.rule.EncryptTableRuleConfiguration 可配置属性： 名称 数据类型 说明 name String 表名称 columns (+) Collection 加密列规则配置列表 加密列规则配置 类名称：org.apache.shardingsphere.encrypt.api.config.rule.EncryptColumnRuleConfiguration 可配置属性： 名称 数据类型 说明 name String 逻辑列名称 cipher EncryptColumnItemRuleConfiguration

AlgorithmConfiguration> 从库负载均衡算法配 置 主从数据源配置 类名称：org.apache.shardingsphere.readwritesplitting.config.rule.ReadwriteSplittingDataSourceGroupRuleConfiguration 可配置属性： 算法类型的详情，请参见内置负载均衡算法列表。 操作步骤 1. 添加读写分离数据源 Map 加解密算法名称和配置 加密表规则配置 类名称：org.apache.shardingsphere.encrypt.config.rule.EncryptTableRuleConfiguration 可配置属性： 名称 数据类型 说明 name String 表名称 columns (+) Collectionrule.EncryptColumnRuleConfiguration 可配置属性： 名称 数据类型 说明 name String 逻辑列名称 cipher EncryptColumnItemRuleConfiguration

. . . . . . . . . . . . . . . . . . . . . . . . . 358 6.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 358 Objectives . . . . . . . . . . . . . . . . . . . . . . . Involved ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.5. Roadmap 9 2 Quick Start In shortest time, this ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm 2. Rule configuration. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx

ShardingSphere‐Proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.1 1. Rule Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.2 2. Import Dependencies ShardingSphere‐Scaling (Experimental) . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.1 1. Rule Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.2 2. Import Dependencies Overall Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Encryption Rule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Encryption Process .

. . . . . . . . . . . . . . . . . . . . . . . . . 331 6.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 331 Objectives . . . . . . . . . . . . . . . . . . . . . . . Contribute ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.2 Design Philosophy ShardingSphere adopts the database ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm 2. Rule configuration. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx