springboot集成druid数据源

springboot默认使用Hikari数据源，只需要在application.properties配置

# rbac database
spring.datasource.rbac.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.rbac.url=jdbc:mysql://xxxxxxxxxxxxxxxxxx
spring.datasource.rbac.username=username
spring.datasource.rbac.password=password

# oauth2 database
spring.datasource.oauth2.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.oauth2.url=jdbc:mysql://xxxxxxxxxxxxxxxxxx
spring.datasource.oauth2.username=username
spring.datasource.oauth2.password=password

 然后使用spring实现一个Bean，分别为rbacDataSource和oauth2DataSource

/**
 * 授权服务器数据源配置
 */
@Configuration
public class OAuth2DataSourceConfiguration {

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.oauth2")
    public DataSource oauth2DataSource() {
        return DataSourceBuilder.create().build();
    }

}

/**
 * 鉴权中心数据源配置
 */
@Configuration
public class RbacDataSourceConfiguration {

    @Primary
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.rbac")
    public DataSource rbacDataSource() {
        return DataSourceBuilder.create().build();
    }

}

启动springboot的时候发现他使用的数据源是 com.zaxxer.hikari，按照我上面的配置，你会发现运行了一段时间以后数据源就用不了卡住了，百度了一下的结论是没有缺少了一些配置导致的。由于公司使用的是druid，虽然hikari很骚包很优秀，但是万一数据源出了问题我肯定不背锅，所以还是使用druid。

2018-08-07 22:57:37.329  INFO 2952 --- [           main] o.s.j.e.a.AnnotationMBeanExporter        : Located MBean 'rbacDataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=rbacDataSource,type=HikariDataSource]
2018-08-07 22:57:37.340  INFO 2952 --- [           main] o.s.j.e.a.AnnotationMBeanExporter        : Located MBean 'oauth2DataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=oauth2DataSource,type=HikariDataSource]

然后我加上druid的配置到application.properties中，发现他运行的还是hikari，那说明我这段配置没有被读取。

# druid database pool
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.initialSize=3
spring.datasource.minidle=3
spring.datasource.maxActive=18
spring.datasource.maxWait=60000
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.validationQuery=SELECT 1 FROM dual
spring.datasource.filters=stat,wall,log4j

然后我debug一下再DataSourceBuilder打了一个断点发现，他的type还是hikari数据源。properties属性无法注入到DataSource中。

然后修改成DruidDataSource使用@ConfigurationProperties将配置文件属性注入进去，然后就成功了

/**
 * 鉴权中心数据源配置
 */
@Configuration
public class RbacDataSourceConfiguration {

    @Primary
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.rbac")
    public DataSource rbacDataSource() {
        DruidDataSource datasource = new DruidDataSource();
        return datasource;
    }

}

# rbac database
spring.datasource.rbac.driverClassName=com.mysql.jdbc.Driver
spring.datasource.rbac.url=jdbc:mysql://xxxxxx
spring.datasource.rbac.username=username
spring.datasource.rbac.password=password
# druid rbac database pool
spring.datasource.rbac.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.rbac.initialSize=5
spring.datasource.rbac.minIdle=5
spring.datasource.rbac.maxActive=20
spring.datasource.rbac.maxWait=60000
spring.datasource.rbac.timeBetweenEvictionRunsMillis=60000
spring.datasource.rbac.minEvictableIdleTimeMillis=300000
spring.datasource.rbac.validationQuery=SELECT 1 FROM DUAL
spring.datasource.rbac.testWhileIdle=true
spring.datasource.rbac.testOnBorrow=false
spring.datasource.rbac.exceptionSorter=true
spring.datasource.rbac.testOnReturn=false
spring.datasource.rbac.poolPreparedStatements=true
spring.datasource.rbac.filters=stat,wall
spring.datasource.rbac.maxPoolPreparedStatementPerConnectionSize=20
spring.datasource.rbac.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
spring.datasource.rbac.useGlobalDataSourceStat=true

2018-08-08 09:28:22.755  INFO 7028 --- [           main] o.s.j.e.a.AnnotationMBeanExporter        : Bean with name 'rbacDataSource' has been autodetected for JMX exposure
2018-08-08 09:28:22.760  INFO 7028 --- [           main] o.s.j.e.a.AnnotationMBeanExporter        : Located MBean 'rbacDataSource': registering with JMX server as MBean [com.alibaba.druid.pool:name=rbacDataSource,type=DruidDataSource]

如果使用ORM框架，还要考虑将DataSource注入到sessionFactory中。过段时间研究一下源码在继续完善