配置監(jiān)控平臺
//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優(yōu)先于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>
德魯伊+苞米豆動態(tài)數(shù)據(jù)源配置
spring:
  datasource:
    dynamic:
      primary: master #設置默認的數(shù)據(jù)源或者數(shù)據(jù)源組,默認值即為master
      strict: true #嚴格匹配數(shù)據(jù)源,默認false. true未匹配到指定數(shù)據(jù)源時拋異常,false使用默認數(shù)據(jù)源
      druid:
        initial-size: 1 # 初始化線程數(shù)量
        max-active: 50 #最大線程數(shù)量
        min-idle: 1 #最小線程數(shù)量
        max-wait: 6000  #最大等待超時時間
        max-wait-thread-count: 20 #最大等待線程數(shù)
        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 最大數(shù)量
        filters: mergeStat #druid監(jiān)控合并sql 不同value的查詢統(tǒng)計
      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