配置多数据源

cl

2026-04-17 86fd4ec5fd97081f212e4c35523ee3d44f233fb6

 rsf-server/src/main/resources/application-dev.yml

@@ -21,14 +21,14 @@
    password: 12345
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      initial-size: 5
      min-idle: 5
      max-active: 20
      max-wait: 30000
      initial-size: 3
      min-idle: 8
      max-active: 40
      max-wait: 10000
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      test-while-idle: true
      test-on-borrow: true
      test-on-borrow: false
      test-on-return: false
      remove-abandoned: true
      remove-abandoned-timeout: 1800
@@ -43,6 +43,27 @@
        login-username: admin
        login-password: admin
        enabled: true
    # 多数据源：cus_item_sync_view 专用库
    cus-item-sync:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: 12345
      url: jdbc:mysql://127.0.0.1:3306/ilc_wms_test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
      initial-size: 1
      min-idle: 2
      max-active: 12
      max-wait: 10000
#    erp:
#      type: com.alibaba.druid.pool.DruidDataSource
#      driver-class-name: com.mysql.cj.jdbc.Driver
#      username: root
#      password: 12345
#      url: jdbc:mysql://127.0.0.1:3306/rsf_jdxaj?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
#      initial-size: 1
#      min-idle: 2
#      max-active: 12
#      max-wait: 10000
  servlet:
    multipart:
      maxFileSize: 100MB
@@ -71,13 +92,6 @@
  timeout: 5000
  index: 15

# 仅 cus_item_sync_view；url 不配置时仍查主库。库名按 108 实例实际库名修改
cus-item-sync:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/rsf_jdxaj?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: 12345
    driver-class-name: com.mysql.cj.jdbc.Driver

#平台接口信息配置(如：ERP, QMS, WCS等)
platform:
@@ -126,7 +140,10 @@
# whitelist-only=true：仅 sys_http_audit_rule 命中规则才写审计；无规则时不落库。false：排除路径外全量记录。
# rule-cache-refresh-ms：规则表缓存刷新间隔（毫秒）
http-audit:
  enabled: true
  # enabled: true
  enabled: false
  # 审计数据源：primary / cus-item-sync
  datasource: primary
  whitelist-only: true
  # false：/httpAuditLog、/httpAuditRule 也会被 Filter 记录（调试用；生产建议 true）
  exclude-audit-self-paths: false