二、Sharding JDBC实战-垂直分库分表

lemonade-water

已于 2022-11-30 11:33:29 修改

阅读量409

点赞数

CC 4.0 BY-SA版权

分类专栏： Sharding JDBC 文章标签： mysql java spring boot

于 2022-11-30 11:31:17 首次发布

本文链接：https://blog.csdn.net/m0_37932830/article/details/128111444

Sharding JDBC 专栏收录该内容

9 篇文章

订阅专栏

文章目录

1.说明

垂直拆分

2.添加Sharding-jdbc依赖包

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

3.完整配置yml文件

spring:
  #Sharding-JDBC的配置
  shardingsphere:
    datasource:
      #数据源名称，多个用逗号分开
      names: ds1,ds2
      ds1:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://192.168.0.1:3306/ds1?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
        username: root
        password: 123456
        driver-class-name: com.mysql.cj.jdbc.Driver
      ds2:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://192.168.0.1:3306/ds2?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
        username: root
        password: 123456
        driver-class-name: com.mysql.cj.jdbc.Driver
    #分片的配置
    sharding:
      #表的分片策略
      tables:
        product:
          #数据节点配置，采用Groovy表达式，切分之后的真实表所在的节点
          actual-data-nodes: ds$->{1}.product
          #主键生成策略
          key-generator:
            #主键
            column: id
            #生成算法
            type: SNOWFLAKE
        shop:
          #数据节点配置，采用Groovy表达式，切分之后的真实表所在的节点
          actual-data-nodes: ds$->{2}.shop
          #主键生成策略
          key-generator:
            #主键
            column: id
            #生成算法
            type: SNOWFLAKE
    props:
      sql:
        show: true

4.附录

	<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.2</version>
    </parent>
    <packaging>jar</packaging>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>2.5.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <version>2.5.2</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-core</artifactId>
            <version>5.8.0</version>
        </dependency>
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-extra</artifactId>
            <version>5.8.0</version>
        </dependency>
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-crypto</artifactId>
            <version>5.8.0</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.56</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3.4</version>
        </dependency>
       <!--sharding-jdbc-->
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>4.1.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.4</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.10</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

@RunWith(SpringRunner.class)
@SpringBootTest(classes = App.class)
@ActiveProfiles("dev")
public class ProductTest {

    @Autowired
    private ProductService productService;

    @Autowired
    private ShopService shopService;

    @Test
    public void testInsert(){
        Shop shop = new Shop();
        shop.setId(IdWorker.getId());
        shop.setName("汉服专卖店");
        shopService.save(shop);
        Product product = new Product();
        product.setLocation("广东省东莞市");
        product.setName("迷彩服");
        product.setShopId(shop.getId());
        product.setId(IdWorker.getId());
        productService.save(product);
    }
}