shardingsphere的讀寫分離和分表設(shè)置

本篇內(nèi)容主要講解“shardingsphere的讀寫分離和分表設(shè)置”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實(shí)用性強(qiáng)。下面就讓小編來帶大家學(xué)習(xí)“shardingsphere的讀寫分離和分表設(shè)置”吧!

shardingsphere版本

<dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>4.1.1</version>
        </dependency>

springboot yml配置

spring:
  shardingsphere:
    datasource:
      names: master,slave0
      master: #主庫
        type: com.zaxxer.hikari.HikariDataSource
        driverClassName: com.mysql.cj.jdbc.Driver
        jdbcUrl: jdbc:mysql://xxx.xxxx.xxxx:3432/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useLocalSessionState=true
        username: db_dev
        password: db_dev123
      slave0: #從庫(讀庫)
        type: com.zaxxer.hikari.HikariDataSource
        driverClassName: com.mysql.cj.jdbc.Driver
        jdbcUrl: jdbc:mysql://xxxx.xxxx.xxxx.xxxx:3433/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useLocalSessionState=true
        username: db_dev
        password: db_dev123

    sharding: #分片設(shè)置
      tables:  #分表規(guī)則
        t_order: #要做分表的表名(或者叫表名前輟)
          actualDataNodes: ms.t_order$->{0..2}  # t_order0~2子表, 這里的ms是主從名: ms
          tableStrategy: #表分片設(shè)置
            inline:
              shardingColumn: customer_id #以此字段做為分片條件
              algorithmExpression: t_order$->{customer_id % 3}  #數(shù)據(jù)分配策略，這里考慮客戶維度的數(shù)據(jù)分表
          keyGenerator:
            column: id
            type: SNOWFLAKE #雪花算法
      masterSlaveRules: #主從設(shè)置(讀寫設(shè)置)
        ms:  #主從名
          masterDataSourceName: master #主庫
          slaveDataSourceNames: slave0  #從庫列表
          loadBalanceAlgorithmType: round_robin  #主從輪詢規(guī)則
    props:
      sql:
        show: true

參考文檔

https://shardingsphere.apache.org/document/legacy/3.x/document/cn/manual/sharding-proxy/configuration/ https://www.cnblogs.com/qdhxhz/p/11656205.html https://www.jianshu.com/p/cb48ba2941cb

到此，相信大家對“shardingsphere的讀寫分離和分表設(shè)置”有了更深的了解，不妨來實(shí)際操作一番吧！這里是億速云網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！