robben009 opened a new issue, #31195:
URL: https://github.com/apache/shardingsphere/issues/31195
I have some tables that do not require splitting, how should I configure the
default data source? As shown in the figure below, I hope that all tables
except the tbreorder table do not need to be split. How should I configure it
at this time?
`
dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.jdbc.Driver
jdbcUrl: jdbc:mysql://***
username: ***
password: ***
hikari:
minimum-idle: 200 # 最小空闲连接数量
maximum-pool-size: 200 # 连接池最大连接数，默认是10
idle-timeout: 600000 # 空闲连接存活最大时间，默认600000（10分钟）
auto-commit: true # 自动提交行为,默认值：true
pool-name: playHikariPool # 连接池名称
max-lifetime: 1800000 # 此属性控制池中连接的最长生命周期，值0表示无限生命周期，默认1800000即30分钟
connection-timeout: 30000 # 数据库连接超时时间,默认30秒，即30000
connection-test-query: Select 1
rules:
- !SHARDING
tables:
tb_order:
actualDataNodes: ds_0.tb_order_${0..1}
tableStrategy:
standard:
shardingColumn: customer_id
shardingAlgorithmName: LastCharShardingAlgorithm
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
bindingTables:
- tb_order
shardingAlgorithms:
LastCharShardingAlgorithm:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName: *
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]
