galaxylqx opened a new issue #15876:
URL: https://github.com/apache/shardingsphere/issues/15876
Problem Description：multiple data source ，use the same database instance.
for example, The host is 127.0.0.1 and port is 3306，Need to create multiple
connection pools，If it is 100 databases，You need to create 100 connection pools
`schemaName: sharding_db
dataSources:
ds_1:
url: jdbc:mysql://**127.0.0.1:3306**/db_1?serverTimezone=UTC&useSSL=false
username: root
password:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_2:
url: jdbc:mysql://**127.0.0.1:3306**/db_2?serverTimezone=UTC&useSSL=false
username: root
password:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1`
Therefore, whether the same database instance will share the connection pool
for aggregation，Increase the parameter identification whether to enable
aggregation.
server.yaml
props:
data-source-aggregation-enabled: 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]
