techhero-ksfw-service.yml

server:
  tomcat:
    max-threads: 500 # Maximum amount of worker threads.
    min-spare-threads: 50 # Minimum amount of worker threads
spring:
  shardingsphere:
    datasource:
      names: master,slave1,slave2
      master:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://119.96.87.17:30101/ksfw_dev?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true
        username: ksfw_dev
        password: a3Nmd19kZXY=
        minimum-idle: 1
        maximum-pool-size: 5
        keepalive-time: 30000
        idle-timeout: 600000
        max-lifetime: 1500000
        connection-test-query: select 1
      slave1:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://119.96.87.17:30101/ksfw_dev?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true
        username: ksfw_dev
        password: a3Nmd19kZXY=
        minimum-idle: 1
        maximum-pool-size: 5
        keepalive-time: 30000
        idle-timeout: 600000
        max-lifetime: 1500000
        connection-test-query: select 1
      slave2:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://119.96.87.17:30101/ksfw_dev?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true
        username: ksfw_dev
        password: a3Nmd19kZXY=
        minimum-idle: 1
        maximum-pool-size: 5
        keepalive-time: 30000
        idle-timeout: 600000
        max-lifetime: 1500000
        connection-test-query: select 1
    rules:
      readwrite-splitting:
        data-sources:
          rw-ds: # 读写数据源名称
            static-strategy:
              write-data-source-name: master
              read-data-source-names:
                - slave1
                - slave2
            load-balancer-name: round_robin
        load-balancers:
          round_robin:
            type: ROUND_ROBIN
    props:
      show-sql: true # 显示SQL日志，调试用
  #      kernel-executor-size: 1
  redis:
    host: 192.168.50.159 #119.96.87.17 #47.104.251.199
    port: 6379 #6942
    password: techhero #ENC(08db934a254e34b5366ff337b81532ec)
    database: 14
    #host: 39.108.117.105
    #port: 6379
    #password: xh3.1415..
    #database: 2
    timeout: 10000
    lettuce:
      pool:
        max-idle: 4
        min-idle: 1
        max-active: 5
        max-wait: 10000
xc:
  mq:
    channel: gxjhhd
    addressList: 10.16.13.54:9876
    serviceAddress: http://10.16.13.55:8661

#rest连接池相关配置
x-rest-template:
  connect-timeout: 3000
  socket-timeout: 5000
  connection-request-timeout: 2000
  default-max-per-route: 50
  max-total: 200
  execute-max-retries: 3
  execute-retry-interval: 400

#专业收藏服务地址
x-major-favorite:
  service-address: 'http://192.168.50.175:8085'
  appid: app
  app-secret: '268c0143093e1fe3db361b2ef9f170b6'
  
logging:
  level:
    org.apache.shardingsphere: trace
    com.zaxxer.hikari: trace