shardingsphere自定义分片算法实现

JAVA-葵花宝典

于 2024-08-28 08:09:01 发布

阅读量19

点赞数

分类专栏：分库分表 shardingsphere 文章标签： java

本文链接：https://blog.csdn.net/baidu_34848066/article/details/141620557

版权

依赖

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

配置



table.order.size=2

spring.shardingsphere.datasource.names=test
spring.shardingsphere.datasource.test.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.test.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.test.username=root
spring.shardingsphere.datasource.test.password=1
spring.shardingsphere.datasource.test.jdbc-url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useSSL=false




spring.shardingsphere.rules.sharding.tables.t_order.actual-data-nodes=test.t_order_$->{0..6}
spring.shardingsphere.rules.sharding.tables.t_order.table-strategy.standard.sharding-colu