数据库德鲁伊连接池druid

配置监控平台
//http://localhost:8080/dbs/
    @Bean
    public ServletRegistrationBean<StatViewServlet> druidStatViewServlet() {
        //先配置管理后台的servLet，访问的入口为/druid/
        ServletRegistrationBean<StatViewServlet> servletRegistrationBean = new ServletRegistrationBean<>(
                new StatViewServlet(), "/dbs/*");
        // IP白名单 (没有配置或者为空，则允许所有访问)
        servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
        // IP黑名单 (存在共同时，deny优先于allow)
        servletRegistrationBean.addInitParameter("deny", "");
        servletRegistrationBean.addInitParameter("loginUsername", "admin");
        servletRegistrationBean.addInitParameter("loginPassword", "admin123");
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }

springboot3.0
  <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.6.0</version>
        </dependency>


        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-3-starter</artifactId>
            <version>1.2.18</version>
        </dependency>
德鲁伊+苞米豆动态数据源配置
spring:
  datasource:
    dynamic:
      primary: master #设置默认的数据源或者数据源组,默认值即为master
      strict: true #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
      druid:
        initial-size: 1 # 初始化线程数量
        max-active: 50 #最大线程数量
        min-idle: 1 #最小线程数量
        max-wait: 6000  #最大等待超时时间
        max-wait-thread-count: 20 #最大等待线程数
        time-between-eviction-runs-millis: 60000  #间隔多少毫秒去检查空闲线程
        minEvictableIdleTimeMillis: 300000 #连接最小活多久
        poolPreparedStatements: true # prepared-statement 线程池开启
        keep-alive: true
        async-init: true #initialsize配置过大打开异步启动连接 增加启动速度
        max-pool-prepared-statement-per-connection-size: 20  # prepared-statement 最大数量
        filters: mergeStat #druid监控合并sql 不同value的查询统计
      datasource:
        master:
          url: jdbc:mysql://ip:3306/mk-auth-center
          username: root
          password: root
          driver-class-name: com.mysql.cj.jdbc.Driver # 3.2.0开始支持SPI可省略此配置
          type: com.alibaba.druid.pool.DruidDataSource