sharding-jdbc 分库 分表

spring:
  shardingsphere:
    datasource:
      names: m0,m1,m2,m3
      m0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/saas_cms_0?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
        username: root
        password: 4rfv7ujmd
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1 FROM DUAL
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        connection-properties: druid.stat.mergeSql:true;druid.stat.slowSqlMillis:5000
      m1:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/saas_cms_1?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
        username: root
        password: 4rfv7ujmd
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1 FROM DUAL
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        connection-properties: druid.stat.mergeSql:true;druid.stat.slowSqlMillis:5000
      m2:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/saas_cms_2?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
        username: root
        password: 4rfv7ujmd
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1 FROM DUAL
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        connection-properties: druid.stat.mergeSql:true;druid.stat.slowSqlMillis:5000
      m3:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/saas_cms_3?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
        username: root
        password: 4rfv7ujmd
        initial-size: 5
        min-idle: 5
        max-active: 20
        max-wait: 60000
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1 FROM DUAL
        test-while-idle: true
        test-on-borrow: true
        test-on-return: false
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        connection-properties: druid.stat.mergeSql:true;druid.stat.slowSqlMillis:5000
    props:
      sql:
        show: true
    sharding:
      default-data-source-name: m0
      tables:
        article:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4} //能除下0库 然后 1 2 3
        article_content:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4}
        channel:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4}
        source:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4}
        clue:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4}
        clue_browse:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4} 
        clue_collection:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4}
        clue_gather_scope:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4}
        hot_type:
          database-strategy:
            inline:
              sharding-column: tenant_id
              algorithm-expression: m$->{tenant_id % 4} 
                                          

management:
  health:
    db:
      enabled: false



不写表的话默认就是0 库 没有规则