shardingjdbc分库分表配置

1、单库分表

        

dataSources:
  ds0: !!com.zaxxer.hikari.HikariDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    jdbcUrl: jdbc:mysql://localhost:3306/order1?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
    username: root
    password: root
shardingRule:
  tables:
    t_user:
      actualDataNodes: ds0.t_user$->{0..1}
      tableStrategy:
        inline:
          shardingColumn: sex
          algorithmExpression: t_user$->{sex % 2}
  bindingTables:
    - t_user
  defaultKeyGenerator:
    type: SNOWFLAKE
    column: id
props:
  sql.show: true

2、分库分表

        

dataSources:
  ds0: !!com.zaxxer.hikari.HikariDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    jdbcUrl: jdbc:mysql://localhost:3306/order1?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
    username: root
    password:
  ds1: !!com.zaxxer.hikari.HikariDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    jdbcUrl: jdbc:mysql://localhost:3306/order2?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
    username: root
    password:
shardingRule:
  tables:
    t_user:
      actualDataNodes: ds${0..1}.t_user${0..1}
      databaseStrategy:
        inline:
          shardingColumn: sex
          algorithmExpression: ds${sex % 2}
      tableStrategy:
        standard:
          shardingColumn: phone
          preciseAlgorithmClassName: org.ywb.subdbtable.sharding.UserPreciseShardingAlgorithm
      keyGenerator:
        type: SNOWFLAKE
        column: id
  bindingTables:
    - t_user
  defaultDataSourceName: ds0

props:
  sql.show: true