Sharding-jdbc，SpringBoot读写分离配置

最新推荐文章于 2024-05-08 20:12:59 发布

浅梦^O^

最新推荐文章于 2024-05-08 20:12:59 发布

阅读量113

点赞数

文章标签： java

本文链接：https://blog.csdn.net/qq_45425562/article/details/130038954

版权

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>top.mxzero</groupId>
    <artifactId>sharding</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>17</maven.compiler.source>
        <maven.compiler.target>17</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <shardingsphere.version>5.2.1</shardingsphere.version>
        <mybatis.plus.version>3.5.3</mybatis.plus.version>
    </properties>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>3.0.5</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
            <version>${shardingsphere.version}</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
    </dependencies>

</project>

spring:
  shardingsphere:
    props:
      sql-show: true
    datasource:
      names: master,slave
      master:
        type: com.zaxxer.hikari.HikariDataSource
        url: jdbc:mysql://localhost:3306/sharding_1
        driver-class-name: com.mysql.cj.jdbc.Driver
        username: root
        password: root
      slave:
        type: com.zaxxer.hikari.HikariDataSource
        url: jdbc:mysql://localhost:3306/sharding_2
        driver-class-name: com.mysql.cj.jdbc.Driver
        username: root
        password: root
    rules:
      -READWRITE_SPLITTING:
        dataSources:
          readwrite_ds:
            staticStrategy:
              writeDataSourceName: master
              readDataSourceNames:
                - slave
            transactionalReadQueryStrategy: PRIMARY
            loadBalancerName: random
        loadBalancers:
          random:
            type: RANDOM