tiandihai commented on issue #29226:
URL:
https://github.com/apache/shardingsphere/issues/29226#issuecomment-1833003950
props:
sql-show: false
dataSources:
db-0:
xxx
db-1:
xxx
db-2:
xxx
db-3:
xxx
sqlFederation:
sqlFederationEnabled: true
executionPlanCache:
initialCapacity: 1000
maximumSize: 1000
rules:
- SQL_PARSER: {}
sqlCommentParseEnabled: true
- SINGLE: {}
tables:
- '*.*'
defaultDataSource: db-0
- SHARDING: {}
tables:
tlog_transnumber_repeat:
actualDataNodes: db-${0..3}.tlog_transnumber_repeat
databaseStrategy:
standard:
shardingColumn: trans_number
shardingAlgorithmName: ds_sharding
tlog_header:
actualDataNodes: db-0.tlog_header
tableStrategy:
standard:
shardingColumn: trans_number
shardingAlgorithmName: tb_sharding
bindingTables:
- b_header,b_items
shardingAlgorithms:
ds_sharding:
type: DATABASE-MOD-SHARDING
props:
database-sharding-ranges:
db-0:0-15,db-1:16-31,db-2:32-47,db-3:48-63
tb_sharding:
type: CLASS_BASED
props:
strategy: standard
algorithmClassName:
com.xxx.sharding.algorithm.TableShardingAlgorithm
--
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-unsubscr...@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
