cus-wms-supervise2.0/src/main/resources/application.yml

#---------- Spring Boot 项目 ----------#


# 项目配置
app:
  name: cus-wms-supervise
  description: ${app.name} is a Spring Boot application

# 服务配置
server:
  address: 172.18.0.193
#  address: 127.0.0.1
  port: 6666


# 分布式配置
ds:
  # 工作机ID (0~31)
  worker-id: 1
  # 数据中心ID (0~31)
  datacenter-id: 1

# 使用环境
spring:
  profiles:
    active:
  aop:
    proxy-target-class: true

  # 数据源
  datasource:
    primary:
      # 数据源zaxxer HikariCP 读取通天晓数据库
      type: com.zaxxer.hikari.HikariDataSource
      driver-class-name: org.mariadb.jdbc.Driver
      # url: jdbc:sqlserver://120.24.12.161:60001;DatabaseName=qhwms
      # url: jdbc:mysql://120.24.12.161:60002/wms_test?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull
      # username: qhdsrds
      # password: Cb!uk3vXPW
      url: jdbc:mysql://rm-wz9rps8173a1nx63g819.mysql.rds.aliyuncs.com:3306/wms_qhds?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull
      username: qhdsf_wms
      password: g$2tX98$tX
      # hikari连接池配置
      hikari:
        readOnly: true
        connectionTimeout: 10000
        validationTimeout: 5000
        idleTimeout: 600000
        maxLifetime: 1200000
        maximumPoolSize: 3
        minimumIdle: 3
    second:
      # 数据源zaxxer HikariCP 写入数据库
      type: com.zaxxer.hikari.HikariDataSource
      driver-class-name: org.mariadb.jdbc.Driver
#      url: jdbc:mysql://120.76.84.45:3306/wms_data?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull
#      username: tuser
#      password: Qq!123
      url: jdbc:mysql://183.3.221.144:3306/wms_data?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull
      username: wms_admin
      password: DsuBkL2w$q
      # hikari连接池配置
      hikari:
        connectionTimeout: 10000
        validationTimeout: 5000
        idleTimeout: 600000
        maxLifetime: 1200000
        maximumPoolSize: 10
        minimumIdle: 3
    third:
          # 数据源zaxxer HikariCP 读取oms
          type: com.zaxxer.hikari.HikariDataSource
          driver-class-name: org.mariadb.jdbc.Driver
#          url: jdbc:mysql://120.24.12.161:60002/oms_write?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull
#          username: out_qhm
#          password: r%4PEusOn&
          url: jdbc:mysql://rm-wz9rps8173a1nx63g819.mysql.rds.aliyuncs.com:3306/oms_write?useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull
          username: qhdsi_oms
          password: ZuQhCA#px3
          # hikari连接池配置
          hikari:
            connectionTimeout: 10000
            validationTimeout: 5000
            idleTimeout: 600000
            maxLifetime: 1200000
            maximumPoolSize: 10
            minimumIdle: 3



# mybatis config 多数据源
mybatis:
  primary:
      config-location: classpath:mybatis/mybatis-config.xml
      type-aliases-package: com.emato.cus.supervise.domain
  second:
      config-location: classpath:mybatis/mybatis-config-cus.xml
      type-aliases-package: com.emato.cus.supervise.domainCus
  third:
      config-location: classpath:mybatis/mybatis-config-oms.xml
      type-aliases-package: com.emato.cus.supervise.domainOms