分表配置文件

mitao

2024-03-06 816eae31f83fc7662d1d978c5b098ec84af92031

分表配置文件

 ruoyi-modules/ruoyi-member/src/main/resources/bootstrap.yml

@@ -17,9 +17,9 @@
        server-addr: 47.109.78.184:5000
#        server-addr: 127.0.0.1:8848
        #pro
        namespace: 9591ef9f-a49a-4900-be35-d77258bdd639
#        namespace: 9591ef9f-a49a-4900-be35-d77258bdd639
        #test
#        namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd
        namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd
        #dev
#        namespace: 6857cbd9-6088-4fe8-bb58-2b516d99876f
      config:
@@ -27,9 +27,9 @@
        server-addr: 47.109.78.184:5000
#        server-addr: 127.0.0.1:8848
        #pro
        namespace: 9591ef9f-a49a-4900-be35-d77258bdd639
#        namespace: 9591ef9f-a49a-4900-be35-d77258bdd639
        #test
#        namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd
        namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd
        #dev
#        namespace: 6857cbd9-6088-4fe8-bb58-2b516d99876f
        # 配置文件格式
@@ -37,6 +37,29 @@
        # 共享配置
        shared-configs:
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}
  shardingsphere:
    props:
      sql:
        show: true
    datasource:
      names: ds0
      ds0:
        driver-class-name: com.mysql.cj.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
        username: root
        password: hrt123456
        url: jdbc:mysql://8.137.105.173:10010/hrt_member?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
    sharding:
      tables:
        t_member_coupon:
          actual-data-nodes: ds0.t_member_coupon$->{0..9}
          key-generator:
            column: id
            type: SNOWFLAKE
          table-strategy:
            inline:
              sharding-column: id
              algorithm-expression: t_member_coupon$->{id % 10}
feign:
  compression:
    request: