application-dev.yml 3.07 KB
Newer Older
1
spring:
fangxinjiang's avatar
fangxinjiang committed
2 3 4 5 6
  shardingsphere:
    datasource:
      ds0:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
huyuchen's avatar
huyuchen committed
7
        url: jdbc:mysql://192.168.1.65:43306/mvp_social?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
fangxinjiang's avatar
fangxinjiang committed
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
        username: root
        password: yf_zsk
        hikari:
          driver-class-name: ${spring.datasource.driver-class-name}
          jdbc-url: ${spring.datasource.url}
          username: ${spring.datasource.username}
          password: ${spring.datasource.password}
          pool-name: AmytangHikariCP
          minimum-idle: 10 # 最小空闲连接数量
          idle-timeout: 60000 # 空闲连接存活最大时间,默认600000(10分钟)
          maximum-pool-size: 12 # 连接池最大连接数,默认是10
          auto-commit: true  #此属性控制从池返回的连接的默认自动提交行为,默认值:true
          max-lifetime: 0 #此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认1800000即30分钟
      names: ds0
    rules:
      sharding:
        key-generators:
          snowflake:
            type: SNOWFLAKE
        sharding-algorithms:
          t-payment-inline:
            props:
              strategy: standard
              algorithmClassName: com.yifu.cloud.plus.v1.yifu.social.config.OTAStrategyShardingAlgorithm
            type: CLASS_BASED
        tables:
          t_payment_info:
fangxinjiang's avatar
fangxinjiang committed
35
            actual-data-nodes: ds0.t_payment_info_20$->{17..24}
fangxinjiang's avatar
fangxinjiang committed
36 37 38 39 40 41 42 43
            key-generate-strategy:
              column: ID
              key-generator-name: snowflake
            table-strategy:
              standard:
                sharding-column: CREATE_TIME
                sharding-algorithm-name: t-payment-inline

44 45 46 47 48 49 50
  mvc:
    pathmatch:
      matching-strategy: ant_path_matcher
  config:
    activate:
      on-profile: dev
  redis:
fangxinjiang's avatar
fangxinjiang committed
51 52
    host: 127.0.0.1
    port: 6379
53 54 55 56
    password: '@yf_2017'
#社保士兵相关属性配置
soldier:
  authorizations : Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmODA2ZjRlYzYzZjY0NjVlOGFlZjRmZmVlOTYwMzcxNiIsInN1YiI6IjIiLCJ1c2VyX3Bob25lIjoiIiwidXNlcl90eXBlIjoiMTAiLCJ1c2VyX25hbWUiOiLmtYvor5UiLCJpc19hcHAiOiIxIiwiVXNlcklkIjoiMiIsIm5iZiI6MTcxMjg5Mjk1OCwiZXhwIjoxNzIzMjYwOTU4LCJpYXQiOjE3MTI4OTI5NTh9.oTmhLfv1tLq8aPOfO3LeqM1IDYT76YGXkqpz3dwBX4M
57 58 59 60
  urlPre : http://172.16.24.66:55555
  #线上社保士兵,一般不允许用,用之前要清理测试环境当月的社保自动化数据,否则有可能产生费用
  #authorizations: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiI2MzcwYWIyZDRhZTI0NjQ2YTg0MTE0Mzk1Y2M2MTkzMiIsInN1YiI6IjQiLCJ1c2VyX3Bob25lIjoiIiwidXNlcl90eXBlIjoiMTAiLCJ1c2VyX25hbWUiOiLlkIjogqXnpL7kv53lo6vlhbVBUEkiLCJpc19hcHAiOiIxIiwiVXNlcklkIjoiNCIsIm5iZiI6MTcxNjE3OTIxOSwiZXhwIjoxNzI2NTQ3MjE5LCJpYXQiOjE3MTYxNzkyMTl9.Ei-52hRlfMLXLzpzmbP2xCVFZKE5sHHexzfX5PtmZ_M
  #urlPre: http://60.168.131.18:55555