fyname commented on issue #13857:
URL:
https://github.com/apache/shardingsphere/issues/13857#issuecomment-982304633
> Hi @fyname Can you show your algorithm configuration?
rules:
sharding:
tables:
tb_order:
actualDataNodes:
tmall.tb_order_$->{0..1},taobao.tb_order_$->{0..1},aliyun.tb_order_$->{0..1}
keyGenerateStrategy:
column: order_id
keyGeneratorName: snowflake
table-strategy:
standard:
sharding-column: order_no
sharding-algorithm-name: tb-order-inline
defaultDatabaseStrategy:
standard:
shardingColumn: merchant
shardingAlgorithmName: db-classbased
defaultTableStrategy:
none:
shardingAlgorithms:
db-classbased:
type: CLASS_BASED
props:
strategy: standard
algorithmClassName:
com.freesun.shardingsphere.multitenancy.spi.DbShardingAlgorithm
tb-order-inline:
type: INLINE
props:
algorithm-expression: tb_order_$->{order_no % 2}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
--
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]
