GravityMatrix commented on issue #16159:
URL:
https://github.com/apache/shardingsphere/issues/16159#issuecomment-1070778216
```spring:
shardingsphere:
props:
sql:
show: true
sharding:
tables:
t_order:
actual-data-nodes: db-$->{2021..2022}.t_order_$->{1..12}
database-strategy:
standard:
sharding-column: created_time
precise-algorithm-class-name:
com.shardingjdbc.sharding.algorithm.DatabasePreciseShardingAlgorithm
table-strategy:
standard:
sharding-column: created_time
precise-algorithm-class-name:
com.shardingjdbc.sharding.algorithm.DatePreciseShardingAlgorithm
range-algorithm-class-name:
com.shardingjdbc.sharding.algorithm.TableRangeShardingAlgorithm
datasource:
names: db-2021, db-2022
db-2021:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url:
username:
password:
initial-size: 10
max-active: 20
min-idle: 10
max-wait: 6000
validation-query: "select '1'"
validation-query-timeout: 2000
test-on-borrow: false
test-on-return: false
test-while-idle: true
time-between-eviction-runs-millis: 600000
min-evictable-idle-time-millis: 300000
remove-abandoned: true
db-2022:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url:
username:
password:
initial-size: 10
max-active: 20
min-idle: 10
max-wait: 6000
validation-query: "select '1'"
validation-query-timeout: 2000
test-on-borrow: false
test-on-return: false
test-while-idle: true
time-between-eviction-runs-millis: 600000
min-evictable-idle-time-millis: 300000
remove-abandoned: true
```
--
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]
