######primary#############
|
#datasource.primary.url=jdbc:mysql://123.57.213.140:3306/test1
|
#datasource.primary.username=com.java110.wuxw
|
#datasource.primary.password=com.java110.wuxw@2016
|
#datasource.primary.driverClassName=com.mysql.jdbc.Driver
|
######secondary#############
|
#datasource.secondary.url=jdbc:mysql://123.57.213.140:3306/test2
|
#datasource.secondary.username=com.java110.wuxw
|
#datasource.secondary.password=com.java110.wuxw@2016
|
#datasource.secondary.driverClassName=com.mysql.jdbc.Driver
|
# 主数据源，默认的
|
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
|
spring.datasource.url=jdbc:mysql://123.57.155.214:3306/crm
|
spring.datasource.username=OutTest
|
spring.datasource.password=wxwlovewym2977
|
#保持连接
|
spring.datasource.poolPingQuery=SELECT * FROM crm.t_user a WHERE a.uid = 1
|
spring.datasource.poolPingEnabled=true
|
spring.datasource.poolPingConnectionsNotUsedFor=3600000
|
|
# 更多数据源
|
custom.datasource.names=primary,secondary
|
custom.datasource.primary.driver-class-name=com.mysql.jdbc.Driver
|
custom.datasource.primary.url=jdbc:mysql://123.57.155.214:3306/crm
|
custom.datasource.primary.username=OutTest
|
custom.datasource.primary.password=wxwlovewym2977
|
#保持连接
|
spring.datasource.primary.poolPingQuery=SELECT * FROM crm.t_user a WHERE a.uid = 1
|
spring.datasource.primary.poolPingEnabled=true
|
spring.datasource.primary.poolPingConnectionsNotUsedFor=3600000
|
|
custom.datasource.secondary.driver-class-name=com.mysql.jdbc.Driver
|
custom.datasource.secondary.url=jdbc:mysql://123.57.155.214:3306/crm
|
custom.datasource.secondary.username=OutTest
|
custom.datasource.secondary.password=wxwlovewym2977
|
#保持连接
|
spring.datasource.secondary.poolPingQuery=SELECT * FROM crm.t_user a WHERE a.uid = 1
|
spring.datasource.secondary.poolPingEnabled=true
|
spring.datasource.secondary.poolPingConnectionsNotUsedFor=3600000
|
