sharding demo 读写分离 U (分库分表 & 不分库只分表)

application-sharding.yml

sharding:
  jdbc:
    datasource:
      names: ds0,ds1,dsx,dsy
      ds0:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/db0?useUnicode=true&characterEncoding=utf8&useSSL=false
        username: hsq
        password: root
      ds1:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/db1?useUnicode=true&characterEncoding=utf8&useSSL=false
        username: hsq
        password: root
      dsx:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/db2?useUnicode=true&characterEncoding=utf8&useSSL=false
        username: hsq
        password: root
      dsy:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/db3?useUnicode=true&characterEncoding=utf8&useSSL=false
        username: hsq
        password: root
    config:
      sharding:
        default-database-strategy:
          inline:
            sharding-column: order_id
            algorithm-expression: ds$->{order_id % 2}
        tables:
          t_order:
            actual-data-nodes: ds$->{5..6}.t_order_$->{0..1}
            table-strategy:
              inline:
                sharding-column: user_id
                algorithm-expression: t_order_$->{user_id % 2}
            key-generator-column-name: id

        props:
          sql:
            show: true
        master-slave-rules:
          ds5:
            master-data-source-name: ds0
            slave-data-source-names: dsx
            load-balance-algorithm-type: round_robin
          ds6:
            master-data-source-name: ds1
            slave-data-source-names: dsy
            load-balance-algorithm-class-name: shardingsphere.demo.balance.NewBananceAlgorithm


application.yml

logging:
  level:
    ROOT: INFO
    shardingsphere.demo: DEBUG
    shardingsphere.demo.mapper: debug
server:
  port: 8100

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: shardingsphere.demo.entity
  config-location: classpath:mybatis-config.xml

spring:
  profiles:
    active: sharding






不分库  只分表

sharding:
  jdbc:
    datasource:
      names: ds0,ds1
      ds0:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/db0?useUnicode=true&characterEncoding=utf8&useSSL=false
        username: hsq
        password: root
      ds1:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/db1?useUnicode=true&characterEncoding=utf8&useSSL=false
        username: hsq
        password: root
    config:
      sharding:
                    default-database-strategy:
                       none:
                         sharding-column: none
                    tables:
                      t_order:
                        actual-data-nodes: dsx.t_order_$->{0..1}
                        table-strategy:
                          inline:
                            sharding-column: user_id
                            algorithm-expression: t_order_$->{user_id % 2}
                        key-generator-column-name: id
                      user:
                         actual-data-nodes: dsx.user
                    props:
                         sql:
                          show: true
                    master-slave-rules:
                     dsx:
                      master-data-source-name: ds0
                      slave-data-source-names: ds1
                      load-balance-algorithm-type: round_robin

转载于:https://www.cnblogs.com/hsq666666/p/10983674.html