zhaojinchao95 commented on issue #27955:
URL:
https://github.com/apache/shardingsphere/issues/27955#issuecomment-1667643871
I check your config.yaml, Please use this yaml and try it again
rules:
- !SHARDING
tables:
t_order:
actualDataNodes: lingh_readwrite_data_sources.t_order$->{0..1}
tableStrategy:
standard:
shardingColumn: order_id
shardingAlgorithmName: lingh_inline
keyGenerateStrategy:
column: order_id
keyGeneratorName: lingh_snowflake
shardingAlgorithms:
lingh_inline:
type: INLINE
props:
algorithm-expression: t_order$->{order_id % 2}
allow-range-query-with-inline-sharding: true
keyGenerators:
lingh_snowflake:
type: SNOWFLAKE
props:
max-vibration-offset: 1
max-tolerate-time-difference-milliseconds: 10
- !READWRITE_SPLITTING
dataSources:
lingh_readwrite_data_sources:
writeDataSourceName: shardingmaster
readDataSourceNames:
- shardingslave0
- shardingslave1
loadBalancerName: lingh_load_balance_algorithm
loadBalancers:
lingh_load_balance_algorithm:
type: ROUND_ROBIN
- !SINGLE
tables:
- "*.*"
defaultDataSource: lingh_readwrite_data_sources
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
