wzshuang opened a new issue, #31449:
URL: https://github.com/apache/shardingsphere/issues/31449
version: 5.2.1
In my project, I have multi datasources, the yml file like this:
``` sql
shardingsphere:
datasource:
names: db_01,db_02,db_03
db_01:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://127.0.0.1:3306/aaa?useunicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8&useTimezone=true&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&verifyServerCertificate=false&useSSL=false&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&autoReconnect=true
username: aaa
password: bbb
initial-size: 2
min-idle: 2
max-active: 20
query-timeout: 3
max-wait: 10000
connect-timeout: 10000
socket-timeout: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
max-evictable-idle-time-millis: 900000
validation-query: SELECT 1 FROM DUAL
max-wait-thread-count: 1000
db_02:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://127.0.0.1:3306/aaa/gov_ds_330000?useunicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8&useTimezone=true&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&verifyServerCertificate=false&useSSL=false&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&autoReconnect=true
username: aaa
password: bbb
initial-size: 2
min-idle: 2
max-active: 20
query-timeout: 3
max-wait: 10000
connect-timeout: 10000
socket-timeout: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
max-evictable-idle-time-millis: 900000
validation-query: SELECT 1 FROM DUAL
max-wait-thread-count: 1000
db_03:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://127.0.0.1:3306/aaa?useunicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8&useTimezone=true&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&verifyServerCertificate=false&useSSL=false&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&autoReconnect=true
username: aaa
password: bbb
initial-size: 2
min-idle: 2
max-active: 20
query-timeout: 3
max-wait: 10000
connect-timeout: 10000
socket-timeout: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
max-evictable-idle-time-millis: 900000
validation-query: SELECT 1 FROM DUAL
max-wait-thread-count: 1000
```
both datasource have same properties:
```
initial-size: 2
min-idle: 2
max-active: 20
query-timeout: 3
max-wait: 10000
connect-timeout: 10000
socket-timeout: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
max-evictable-idle-time-millis: 900000
validation-query: SELECT 1 FROM DUAL
max-wait-thread-count: 1000
```
is there any way to config druid properties just once
--
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]
