不灭的火

革命尚未成功,同志仍须努力下载JDK17

作者:AlbertWen  添加时间:2025-04-11 18:53:12  修改时间:2025-04-22 09:04:46  分类:02.MyBatis-Flex  编辑

官方文档:多数据源

application-dev.yml 文件内容:

MyBaits-Flex 内置了功能完善的多数据源支持^1.0.6,不需要借助第三方插件或者依赖,开箱即用, 支持包括 druid、hikaricp、dbcp2、beecp 在内的任何数据源,MyBatis-Flex 多数据源配置如下:

mybatis-flex:
  datasource:
    ds1:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: org.postgresql.Driver
      url: jdbc:postgresql://120.1.2.3:5432/zx_db_informat2_biz_prd_0
      username: postgres
      password: 123456
      druid:
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 30000
        validation-query: SELECT 'x'
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false
        pool-prepared-statements: false
        filters: stat,wall,slf4j
        max-pool-prepared-statement-per-connection-size: -1
        use-global-data-source-stat: true
        connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
        web-stat-filter:
          enabled: true
          url-pattern: /*
          exclusions: /druid/*,*.js,*.gif,*.jpg,*.png,*.css,*.ico
        stat-view-servlet:
          enabled: true
          url-pattern: /druid/*
          reset-enable: false
          login-username: admin
          login-password: admin888
          allow: 127.0.0.1
    ds2:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: org.postgresql.Driver
      url: jdbc:postgresql://120.1.2.3:5432/zx_db_informat2_account_prd
      username: postgres
      password: 123456
      druid:
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 30000
        validation-query: SELECT 'x'
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false
        pool-prepared-statements: false
        filters: stat,wall,slf4j
        max-pool-prepared-statement-per-connection-size: -1
        use-global-data-source-stat: true
        connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
        web-stat-filter:
          enabled: true
          url-pattern: /*
          exclusions: /druid2/*,*.js,*.gif,*.jpg,*.png,*.css,*.ico
        stat-view-servlet:
          enabled: true
          url-pattern: /druid2/*
          reset-enable: false
          login-username: admin
          login-password: admin888
          allow: 127.0.0.1

# 日志
logging:
  config: classpath:config/logback-dev.xml
  level:
    com.fuyo: info