spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
# driverClassName: oracle.jdbc.driver.OracleDriver
druid:
# first: #数据源1
# url: jdbc:oracle:thin:@10.10.1.145:1521:ORCL
# username: dev_servercenter
# password: 123
# second: #数据源2
# url: jdbc:oracle:thin:@10.10.1.145:1521:ORCL
# username: dev_servercenter
# password: 123
first: #数据源1
url: jdbc:mysql://localhost:3306/daily?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
username: root
password: ***
second: #数据源2
url: jdbc:mysql://localhost:3306/daily?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
username: authorize
password: ***
initial-size: 10
max-active: 100
min-idle: 10
max-wait: 60000
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 20
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
stat-view-servlet:
enabled: true
url-pattern: /druid/*
#login-username: admin
#login-password: admin
filter:
stat:
log-slow-sql: true
slow-sql-millis: 1000
merge-sql: true
wall:
config:
multi-statement-allow: true
flyway:
enabled: false
baseline-on-migrate: true
placeholder-replacement: false
locations: classpath:db/migration/mysql
网友评论