美文网首页
【sharding-jdbc】spring boot 集成sha

【sharding-jdbc】spring boot 集成sha

作者: miniy_7 | 来源:发表于2019-10-24 15:31 被阅读0次

应实际业务需求,实现一主多从读写分离。sharding-jdbc 框架能够实现此功能,集成此框架到项目中去。
集成sharding-jdbc前建议仔细阅读官网相关文档
shardingsphere 官网
shardingsphere github地址

步骤

  • 引入相关依赖
   <sharding-sphere.version>4.0.0-RC2</sharding-sphere.version>
   <!-- sharding-jdbc -->
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>${sharding-sphere.version}</version>
        </dependency>
  • 进行一主多从读写分离配置
spring:
  
  shardingsphere:
    datasource:
      names: master,slave0,slave1
      master:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.p6spy.engine.spy.P6SpyDriver
        url: jdbc:p6spy:mysql://0.0.0.0:3306/master?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
        username: root
        password: pwd
        initial-size: 10
        max-active: 10
        min-idle: 10
        max-wait: 60000
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        filter:
          stat:
            log-slow-sql: true
            slow-sql-millis: 1000
            merge-sql: true
          wall:
            config:
              multi-statement-allow: true
      slave0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.p6spy.engine.spy.P6SpyDriver
        url: jdbc:p6spy:mysql://0.0.0.0:3306/slave0?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
        username: root
        password: pwd
        initial-size: 10
        max-active: 10
        min-idle: 10
        max-wait: 60000
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        filter:
          stat:
            log-slow-sql: true
            slow-sql-millis: 1000
            merge-sql: true
          wall:
            config:
              multi-statement-allow: true
      slave1:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.p6spy.engine.spy.P6SpyDriver
        url: jdbc:p6spy:mysql://0.0.0.0:3306/slave1?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
        username: root
        password: pwd
        initial-size: 10
        max-active: 10
        min-idle: 10
        max-wait: 60000
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: SELECT 1
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        filter:
          stat:
            log-slow-sql: true
            slow-sql-millis: 1000
            merge-sql: true
          wall:
            config:
              multi-statement-allow: true
    masterslave: # 实现 一主多从 读写分离
      name: ms
      master-data-source-name: master
      slave-data-source-names: slave0,slave1
      load-balance-algorithm-type: round_robin
    props:
      sql:
        show:true

说明
sharding-jdbc 的官方文档在我看来是比较绕的,尤其是配置文件,看着相当头大,仔细看绝对是看得懂的。上面配置一主两从的情况,此框架支持一主,这点是需要注意的。而且框架不复制主从数据的同步。

相关文章

网友评论

      本文标题:【sharding-jdbc】spring boot 集成sha

      本文链接:https://www.haomeiwen.com/subject/yqtdvctx.html