ckall commented on issue #24157:
URL:
https://github.com/apache/shardingsphere/issues/24157#issuecomment-1430608551
`
schemaName: order
dataSources:
test_write_order_0:
url:
jdbc:mysql://xxxx:32770/test_order_0?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_1:
url:
jdbc:mysql://xxxx:32770/test_order_1?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_2:
url:
jdbc:mysql://xxxx:32770/test_order_2?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_3:
url:
jdbc:mysql://xxxx:32770/test_order_3?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_4:
url:
jdbc:mysql://xxxx:32770/test_order_4?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_5:
url:
jdbc:mysql://xxxx:32770/test_order_5?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_0:
url:
jdbc:mysql://xxxx:32771/test_order_0?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_1:
url:
jdbc:mysql://xxxx:32771/test_order_1?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_2:
url:
jdbc:mysql://xxxx:32771/test_order_2?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_3:
url:
jdbc:mysql://xxxx:32771/test_order_3?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_4:
url:
jdbc:mysql://xxxx:32771/test_order_4?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_5:
url:
jdbc:mysql://xxxx:32771/test_order_5?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
rules:
- !READWRITE_SPLITTING
dataSources:
test_order_0:
staticStrategy:
writeDataSourceName: test_write_order_0
readDataSourceNames:
- test_read_order_0
loadBalancerName: random
test_order_1:
staticStrategy:
writeDataSourceName: test_write_order_1
readDataSourceNames:
- test_read_order_1
loadBalancerName: random
test_order_2:
staticStrategy:
writeDataSourceName: test_write_order_2
readDataSourceNames:
- test_read_order_2
loadBalancerName: random
test_order_3:
staticStrategy:
writeDataSourceName: test_write_order_3
readDataSourceNames:
- test_read_order_3
loadBalancerName: random
test_order_4:
staticStrategy:
writeDataSourceName: test_write_order_4
readDataSourceNames:
- test_read_order_4
loadBalancerName: random
test_order_5:
staticStrategy:
writeDataSourceName: test_write_order_5
readDataSourceNames:
- test_read_order_5
loadBalancerName: random
loadBalancers:
random:
type: ROUND_ROBIN
- !SHARDING
tables:
test_order:
actualDataNodes: test_order_${0..5}.order_${0..4}
tableStrategy:
standard:
shardingColumn: user_id
shardingAlgorithmName: order_inline
databaseStrategy:
standard:
shardingColumn: agent_id
shardingAlgorithmName: database_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
defaultShardingColumn: agent_id
defaultDatabaseStrategy:
standard:
shardingColumn: agent_id
shardingAlgorithmName: database_inline
defaultTableStrategy:
standard:
shardingColumn: user_id
shardingAlgorithmName: order_inline
shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: test_order_${agent_id % 6}
order_inline:
type: INLINE
props:
algorithm-expression: order_${user_id % 5}
keyGenerators:
snowflake:
type: SNOWFLAKE
`
--
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]
