. . . . . . . . . . . . . . . . . . . . . . . . . 467 11.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 467 Objectives . . . . . . . . . . . . . . . . . . . . . . . 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 the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse and store. A Row Value

. . . . . . . . . . . . . . . . . . . . . . . . . 496 11.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 496 Objectives . . . . . . . . . . . . . . . . . . . . . . . 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 the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse and store. A Row Value

. . . . . . . . . . . . . . . . . . . . . . . . . 331 6.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 331 Objectives . . . . . . . . . . . . . . . . . . . . . . . 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 the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse and store. Row expressions

. . . . . . . . . . . . . . . . . . . . . . . . . 358 6.6.1 SysBench ShardingSphere‐Proxy Empty Rule Performance Test . . . . . . . . . 358 Objectives . . . . . . . . . . . . . . . . . . . . . . . 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 the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse and store. Row expressions

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

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 .

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 .

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