方便更快捷的说明问题,可以按需填写(可删除)
使用环境:
5.0.1.SNAPSHOT 1206版本
场景、问题:
已进行操作:
config-sharding:
rules:
- !SHARDING
tables:
user:
actualDataNodes: ds_0.user
tableStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: user_inline
keyGenerateStrategy:
column: p_id
keyGeneratorName: snowflake
shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: ds_4
user_inline:
type: INLINE
props:
algorithm-expression: user_${id % 16}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
proxy内执行:
ADD RESOURCE ds_4 (
URL="jdbc:mysql://127.0.0.1:3306/account_shard?serverTimezone=UTC&useSSL=false",
USER=root,
PASSWORD=rootroot,
PROPERTIES("maximumPoolSize"=1000,"idleTimeout"="30000")
);
ALTER SHARDING TABLE RULE user (
RESOURCES(ds_4),
SHARDING_COLUMN=id,
TYPE(NAME=hash_mod,PROPERTIES("sharding-count"=16)),
GENERATED_KEY(COLUMN=p_id,TYPE(NAME=snowflake,PROPERTIES("worker-id"=123)))
);