Spring Boot 數據庫連接池深度配置：HikariCP 與 Druid 參數調優、監控與多數據源實戰

連接池是數據庫訪問性能的核心基礎設施。Spring Boot 2.x/3.x 默認採用 HikariCP，Druid 為國產強項。本文深度解析兩大連接池關鍵參數、監控體系、動態配置與多數據源隔離實戰。

Spring Boot 連接池自動配置邏輯

// DataSourceAutoConfiguration 簡化邏輯
@ConditionalOnClass({DataSource.class, EmbeddedDatabaseType.class})
@EnableConfigurationProperties(DataSourceProperties.class)
public class DataSourceAutoConfiguration {
    
    @Bean
    @ConditionalOnMissingBean
    @ConditionalOnProperty(name = "spring.datasource.type")
    public DataSource dataSource(DataSourceProperties props) {
        return props.initializeDataSourceBuilder().build();
    }
    
    // HikariCP 優先 (類路徑存在)
    @Bean
    @ConditionalOnClass(HikariDataSource.class)
    @ConditionalOnMissingBean(DataSource.class)
    @ConditionalOnProperty(name = "spring.datasource.hikari.*", matchIfMissing = true)
    public HikariDataSource hikariDataSource(DataSourceProperties props) { ... }
    
    // Druid 次之
    @Bean
    @ConditionalOnClass(DruidDataSource.class)
    @ConditionalOnMissingBean(DataSource.class)
    @ConditionalOnProperty(name = "spring.datasource.druid.*", matchIfMissing = false)
    public DruidDataSource druidDataSource(DataSourceProperties props) { ... }
}

HikariCP 核心參數詳解 (Spring Boot 映射: spring.datasource.hikari.*)

application.yml 完整配置

spring:
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/app?useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
    username: root
    password: root
    hikari:
      maximum-pool-size: 30
      minimum-idle: 10
      connection-timeout: 20000
      idle-timeout: 300000
      max-lifetime: 1200000
      connection-test-query: SELECT 1
      validation-timeout: 5000
      leak-detection-threshold: 30000
      auto-commit: false
      pool-name: AppHikariPool
      register-mbeans: true
      # 傳遞驅動屬性 (需字符串)
      data-source-properties:
        cachePrepStmts: "true"
        prepStmtCacheSize: "250"
        prepStmtCacheSqlLimit: "2048"
        useServerPrepStmts: "true"
        rewriteBatchedStatements: "true"
        maintainTimeStats: "false"

Druid 核心參數詳解 (Spring Boot 映射: spring.datasource.druid.*)

Druid 監控配置

spring:
  datasource:
    druid:
      # ... 上述核心參數
      web-stat-filter:
        enabled: true
        url-pattern: /*
        exclusions: "*.js,*.css,*.png,*.jpg,*.gif,*.ico,/druid/*"
        profile-enable: true  # URL 調用統計
      stat-view-servlet:
        enabled: true
        url-pattern: /druid/*
        login-username: admin
        login-password: ${DRUID_PASSWORD:admin123}  # 環境變量注入
        reset-enable: false
        allow: 127.0.0.1,10.0.0.0/8  # 白名單
        deny: 192.168.1.100

多數據源隔離配置 (業務解耦、讀寫分離)

配置文件

spring:
  datasource:
    # 主庫 (寫)
    master:
      type: com.zaxxer.hikari.HikariDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://master-db:3306/app?useSSL=false&serverTimezone=UTC
      username: root
      password: ${MASTER_PWD}
      hikari:
        maximum-pool-size: 20
        pool-name: MasterHikariPool
    # 從庫 (讀)
    slave:
      type: com.zaxxer.hikari.HikariDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://slave-db:3306/app?useSSL=false&serverTimezone=UTC
      username: readonly
      password: ${SLAVE_PWD}
      hikari:
        maximum-pool-size: 30
        pool-name: SlaveHikariPool

配置類

# application.yml
spring:
  datasource:
    hikari:
      register-mbeans: true

# 依賴
&
    io.micrometer
    micrometer-registry-prometheus


# 暴露端點
management:
  endpoints:
    web:
      exposure:
        include: prometheus,metrics,health
  endpoint:
    prometheus:
      enabled: true