type="SNOWFLAKE"> 5.1. ShardingSphere-JDBC 76 Apache ShardingSphere document, v5.0.0 123 worker-id", "123"); shardingRuleConfiguration.getKeyGenerators().put("snowflake", new ShardingSphereA key-generators.snowflake.type=SNOWFLAKE spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123 # read query configuration # ds_0,ds_1 is the logical data source name of the readwrite-splitting

123 worker-id", "123"); shardingRuleConfiguration.getKeyGenerators().put("snowflake", new ShardingSphereA key-generators.snowflake.type=SNOWFLAKE spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123 # 读写分离策略配置 # ds_0,ds_1 为读写分离配置的逻辑数据源名称 spring.shardingsphere.rules.readwrite-splitting

instance id instance_type instance type host host port port status status mode_type mode type worker_id worker id labels labels version version 9.2. ShardingSphere-Proxy 305 Apache ShardingSphere document ------+--------+----------+ | instance_id | instance_type | host | port | status | mode_type | worker_id | labels | version | +--------------------------------------+---------------+------------+------+------- 'READ' '(' ('WORKER_THREAD' '=' workerThreadPoolSize ',')? ('BATCH_SIZE' '=' batchSize ',')? ('SHARDING_SIZE' '=' shardingSize ',')? (rateLimiter)? ')' writeConfiguration ::= 'WRITE' '(' ('WORKER_THREAD'

instance id instance_type instance type host host port port status status mode_type mode type worker_id worker id labels labels version version Example mysql> SHOW COMPUTE NODES; +----------------- ------+--------+----------+ | instance_id | instance_type | host | port | status | mode_type | worker_id | labels | version | +--------------------------------------+---------------+------------+------+------- 'READ' '(' ('WORKER_THREAD' '=' workerThreadPoolSize ',')? ('BATCH_SIZE' '=' batchSize ',')? ('SHARDING_SIZE' '=' shardingSize ',')? (rateLimiter)? ')' writeConfiguration ::= 'WRITE' '(' ('WORKER_THREAD'

说明 instance_id 实例 id instance_type 实例类型 host 主机地址 port 端口号 status 实例状态 mode_type 模式类型 worker_id worker id labels 标签 version 版本 示例 mysql> SHOW COMPUTE NODES; +------------------------------- ------+--------+----------+ | instance_id | instance_type | host | port | status | mode_type | worker_id | labels | version | +--------------------------------------+---------------+------------+------+------- 'READ' '(' ('WORKER_THREAD' '=' workerThreadPoolSize ',')? ('BATCH_SIZE' '=' batchSize ',')? ('SHARDING_SIZE' '=' shardingSize ',')? (rateLimiter)? ')' writeConfiguration ::= 'WRITE' '(' ('WORKER_THREAD'

列 说明 instance_id proxy 实例编号 host 主机地址 port 端口号 status proxy 实例状态 mode_type proxy 实例模式 worker_id worker id labels 标签 version 版本 示例 • 查询 proxy 实例信息 SHOW COMPUTE NODES; mysql> SHOW COMPUTE NODES; host | port | status | mode_type 9.2. ShardingSphere-Proxy 282 Apache ShardingSphere document | worker_id | labels | version | +--------------------------------------+---------------+------+--------+----------- 'READ' '(' ('WORKER_THREAD' '=' workerThreadPoolSize ',')? ('BATCH_SIZE' '=' batchSize ',')? ('SHARDING_SIZE' '=' shardingSize ',')? (rateLimiter)? ')' writeConfiguration ::= 'WRITE' '(' ('WORKER_THREAD'

algorithm-expression: t_account_detail_${account_id % 2} keyGenerators: snowflake: type: SNOWFLAKE props: worker-id: 123 Assert data are in the xml under test type in test\resources. In the xml file, yaml-rule Test Engine 108 Apache ShardingSphere document, v5.0.0-beta snowflake: type: SNOWFLAKE props: worker-id: 123 Readwrite-splitting Configuration schemaName: sharding_db dataSources: primary_ds: url: props: algorithm-expression: tbl${k % 1024} keyGenerators: snowflake: type: SNOWFLAKE props: worker-id: 123 - !READWRITE_SPLITTING dataSources: pr_ds_0: 3.10. Test Engine 111 Apache ShardingSphere

说明 instance_id 实例 id instance_type 实例类型 host 主机地址 port 端口号 status 实例状态 mode_type 模式类型 worker_id worker id labels 标签 version 版本 示例 mysql> SHOW COMPUTE NODES; +------------------------------- ------+--------+----------+ | instance_id | instance_type | host | port | status | mode_type | worker_id | labels | version | +--------------------------------------+---------------+------------+------+------- 'READ' '(' ('WORKER_THREAD' '=' workerThreadPoolSize ',')? ('BATCH_SIZE' '=' batchSize ',')? ('SHARDING_SIZE' '=' shardingSize ',')? (rateLimiter)? ')' writeConfiguration ::= 'WRITE' '(' ('WORKER_THREAD'

PROPERTIES("sharding-count"=4)), GENERATED_KEY(COLUMN=another_id,TYPE(NAME=snowflake,PROPERTIES("worker-id"=123))) ); ALTER SHARDING TABLE RULE t_order ( RESOURCES(resource_0,resource_1), SHARDING_COLUMN=order_id PROPERTIES("sharding-count"=10)), GENERATED_KEY(COLUMN=another_id,TYPE(NAME=snowflake,PROPERTIES("worker-id"=123))) ); 3.8. Dist SQL 92 Apache ShardingSphere document, v5.0.0-beta DROP SHARDING TABLE TYPE(NAME=hash_mod,PROPERTIES("sharding-count"=4)), GENERATED_KEY(COLUMN=order_id,TYPE(NAME=snowflake,PROPERTIES("worker-id"=123))) ); 4. 创建切分表 3.8. Dist SQL 102 Apache ShardingSphere document, v5.0.0-beta CREATE

de‐ tails in simple style f a l s e kern el‐e xecu tor‐ size (?) i n t The max thread size of worker group to execute SQL. One ShardingSphereData‐ Source will use a independent thread pool, it simple style. f a l s e t r u e ke rne l‐e xec uto r‐s ize (?) i n t The max thread size of worker group to exe‐ cute SQL. One ShardingSphere‐ DataSource will use a indepen‐ dent thread pool RATE_LIMITER (algorithmDefinition) streamChannel: STREAM_CHANNEL (algorithmDefinition) workerThread: WORKER_THREAD=intValue batchSize: BATCH_SIZE=intValue intValue: INT • ENABLE is used to set which sharding