110117 commented on issue #19348:
URL:
https://github.com/apache/shardingsphere/issues/19348#issuecomment-1189839895
> datasource:
names: master0,master0slave0,master1,master1slave0
master0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://xxx
username: postgres
password: postgres
#durid连接池的属性
initial-size: 10
max-active: 100
min-idle: 5
max-wait: 30000
validation-query: select 0
time-between-eviction-runs-millis: 60000
min-evictableIdle-time-millis: 1800000
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 100
test-on-borrow: false
test-on-return: false
test-while-idle: true
master0slave0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://xxxx
username: postgres
password: postgres
#省略durid连接池的属性
master1:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://xxx
username: postgres
password: postgres
#省略durid连接池的属性
master1slave0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://xxx
username: postgres
password: postgres
#省略durid连接池的属性
# 在日志中打印 SQ
props:
sql-show: true
rules:
readwrite-splitting:
load-balancers:
round-robin:
type: ROUND_ROBIN
data-sources:
ds-0:
write-data-source-name: master0
read-data-source-names: master0slave0
load-balancer-name: round-robin
ds-1:
write-data-source-name: master1
read-data-source-names: master1slave0
load-balancer-name: round-robin
--
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]
