shardingsphere 5.x beta + mybatis plus 配置

最新推荐文章于 2024-08-20 16:53:34 发布

听劝

最新推荐文章于 2024-08-20 16:53:34 发布

阅读量1.2k

点赞数 1

分类专栏： JAVA学习

本文链接：https://blog.csdn.net/m0_37068073/article/details/118373096

版权

JAVA学习专栏收录该内容

11 篇文章 1 订阅

订阅专栏

spring boot + shardingsphere 5.0.0 beta + mybatis plus 配置

版本

spring boot 2.5.2
shardingsphere 5.0.0-beta
mybatis plus 3.4.3.1
druid 1.2.6

表结构

create table t_business_1
(
    id          bigint auto_increment comment '主键' primary key,
    type        tinyint default 1 null,
    state       tinyint default 1 null comment '状态，1有效，0无效'
)
    comment '业务表';
    
create table t_business_2
(
    id          bigint auto_increment comment '主键' primary key,
    type        tinyint default 1 null,
    state       tinyint default 1 null comment '状态，1有效，0无效'
)
    comment '业务表';

创建项目

idea新建spring boot项目

Java代码

MybatisX一键生成

依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.6</version>
</dependency>

<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
    <version>5.0.0-beta</version>
</dependency>

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3.1</version>
</dependency>

配置文件

# 开发环境配置
server:
  # 服务器的HTTP端口，默认为80
  port: 80

# Spring配置
spring:
  shardingsphere:
    # 数据源配置
    datasource:
      # 数据源名称，多数据源以逗号分隔
      names: db0 #你想要的数据库名字
      db0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/junisyoan?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
        username: junisyoan
        password: 123123
    # 规则配置
    rules:
      sharding:
        # 分片算法配置
        sharding-algorithms:
          table-inline:
            # 分片算法类型 https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-algorithm/sharding/
            type: INLINE
            props:
              # 分片算法的行表达式
              algorithm-expression: t_business_$->{id % 2 + 1}
        # 分布式序列算法配置
        key-generators:
          snowflake:
            # 分布式序列算法（雪花算法：SNOWFLAKE； UUID：UUID）
            type: SNOWFLAKE
            # 分布式序列算法属性配置
            props:
              # 工作机器唯一标识
              worker-id: 123
        tables:
          # 逻辑表名称
          t_business:
            # 行表达式标识符可以使用 ${...} 或 $->{...}，但前者与 Spring 本身的属性文件占位符冲突，因此在 Spring 环境中使用行表达式标识符建议使用 $->{...}
            actual-data-nodes: db0.t_business_$->{1..2}
            # 分表策略
            table-strategy:
              standard:
                # 分片列名称
                sharding-column: id
                # 分片算法名称
                sharding-algorithm-name: table-inline
            # 表主键算法
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
    # 属性配置
    props:
      # 展示修改以后的sql语句
      sql-show: true

输出日志

2021-07-01 00:57:17.534  INFO 16404 --- [nio-8000-exec-4] ShardingSphere-SQL: Logic SQL: INSERT INTO t_business  ( type, state )  VALUES  ( ?, ? )
2021-07-01 00:57:17.534  INFO 16404 --- [nio-8000-exec-4] ShardingSphere-SQL: SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
2021-07-01 00:57:17.534  INFO 16404 --- [nio-8000-exec-4] ShardingSphere-SQL: Actual SQL: db0 ::: INSERT INTO t_business_1  ( type, state , id)  VALUES  (?, ?, ?) ::: [1, 1, 617160953175715840]

2021-07-01 00:57:18.534  INFO 16404 --- [nio-8000-exec-5] ShardingSphere-SQL: Logic SQL: INSERT INTO t_business  ( type, state )  VALUES  ( ?,? )
2021-07-01 00:57:18.534  INFO 16404 --- [nio-8000-exec-5] ShardingSphere-SQL: SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
2021-07-01 00:57:18.534  INFO 16404 --- [nio-8000-exec-5] ShardingSphere-SQL: Actual SQL: db0 ::: INSERT INTO t_business_2  ( type, state , id)  VALUES  (?, ?, ?) ::: [1, 1, 617160957370019841]