You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "zhaojinchao95 (via GitHub)" <gi...@apache.org> on 2023/08/07 10:59:53 UTC
[GitHub] [shardingsphere] zhaojinchao95 commented on issue #27955: When a logic database uses both `SHARDING` and `READWRITE_SPLITTING` features, CRUD operations on table throw `NoSuchTableException`
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org