1210958801 commented on issue #21422:
URL:
https://github.com/apache/shardingsphere/issues/21422#issuecomment-1276245987
`
- !SHARDING
shardingAlgorithms:
database_inline:
props:
algorithm-expression: rosetta_task_$->{project_id%4}
type: INLINE
history_table_inline:
props:
algorithm-expression: task_history_$->{task_id%4}
type: INLINE
task_table_inline:
props:
algorithm-expression: task_info_$->{project_id%3}
type: INLINE
tables:
task_info:
actualDataNodes: rosetta_task_$->{0..3}.task_info_$->{0..2}
databaseStrategy:
standard:
shardingAlgorithmName: database_inline
shardingColumn: project_id
logicTable: task_info
tableStrategy:
standard:
shardingAlgorithmName: task_table_inline
shardingColumn: project_id
task_history:
actualDataNodes: rosetta_task_$->{0..3}.task_history_$->{0..3}
databaseStrategy:
standard:
shardingAlgorithmName: database_inline
shardingColumn: project_id
logicTable: task_history
tableStrategy:
standard:
shardingAlgorithmName: history_table_inline
shardingColumn: task_id
`
--
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]
