ShardingSphere5.2.1+达梦数据库分表操作

于 2025-03-26 18:18:33 发布
阅读量427 收藏 1
点赞数 10
文章标签： 数据库 java 分布式
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/Angushine/article/details/146537280
版权

上一篇使用的ShardingSphere版本为4.1.1，本次使用5.2.1

依赖引用

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>org.example</groupId>
    <artifactId>sharding-dm04</artifactId>
    <version>1.0</version>
    <name>sharding-dm04</name>
    <description>sharding-dm04</description>
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.7.6</spring-boot.version>
        <shardingsphere.version>5.2.1</shardingsphere.version>
        <alibaba.druid.version>1.2.6</alibaba.druid.version>
        <snakeyaml.version>1.33</snakeyaml.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>com.dameng</groupId>
            <artifactId>DmJdbcDriver18</artifactId>
            <version>8.1.3.140</version>
        </dependency>
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
            <version>${shardingsphere.version}</version>
        </dependency>
        <dependency>
            <groupId>org.yaml</groupId>
            <artifactId>snakeyaml</artifactId>
            <version>${snakeyaml.version}</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>${alibaba.druid.version}</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.20</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>${spring-boot.version}</version>
                <configuration>
                    <mainClass>org.example.shardingdm.ShardingDm02Application</mainClass>
                    <skip>true</skip>
                </configuration>
                <executions>
                    <execution>
                        <id>repackage</id>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>

数据库脚本

CREATE TABLE "TEST"."GOODS_1"
(
    "GID" BIGINT,
    "GNAME" VARCHAR(50),
    "USER_ID" BIGINT,
    "GSTATUS" VARCHAR(50)
) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "TEST"."GOODS_2"
(
    "GID" BIGINT,
    "GNAME" VARCHAR(50),
    "USER_ID" BIGINT,
    "GSTATUS" VARCHAR(50)
) STORAGE(ON "MAIN", CLUSTERBTR) ;

关键代码

application.properties配置文件

mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

spring.main.allow-bean-definition-overriding=true

spring.shardingsphere.props.sql.show=true
spring.shardingsphere.datasource.names=g1

spring.shardingsphere.datasource.g1.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.g1.driver-class-name=dm.jdbc.driver.DmDriver
spring.shardingsphere.datasource.g1.url=jdbc:dm://10.16.39.19:5236/TEST
spring.shardingsphere.datasource.g1.username=SYSDBA
spring.shardingsphere.datasource.g1.password=szCIM2024

# 分片配置
spring.shardingsphere.rules.sharding.tables.goods.actual-data-nodes=g1.goods_$->{1..2}

# 分布式序列配置
spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
spring.shardingsphere.rules.sharding.key-generators.snowflake.props.work-id=123

# 分布式ID
spring.shardingsphere.rules.sharding.tables.goods.key-generate-strategy.column=gid
spring.shardingsphere.rules.sharding.tables.goods.key-generate-strategy.key-generator-name=snowflake

# 分表配置
spring.shardingsphere.rules.sharding.tables.goods.table-strategy.standard.sharding-column=gid
spring.shardingsphere.rules.sharding.tables.goods.table-strategy.standard.sharding-algorithm-name=goods_table_inline

# 分表规则
spring.shardingsphere.rules.sharding.sharding-algorithms.goods_table_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.goods_table_inline.props.algorithm-expression=goods_$->{gid % 2 + 1}

实体类

package org.example.shardingdm.pojo;

import lombok.Data;

@Data
public class Goods {
    private Long gid;
    private String gname;
    private Long userId;
    private String gstatus;
}

Mapper接口

package org.example.shardingdm.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.example.shardingdm.pojo.Goods;
import org.springframework.stereotype.Repository;

@Repository

public interface GoodsMapper extends BaseMapper<Goods> {

}

测试类

package org.example.shardingdm;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import org.example.shardingdm.mapper.GoodsMapper;
import org.example.shardingdm.pojo.Goods;
import org.example.shardingdm.utils.SnowflakeUtil;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class SharingJdbcTestApplicationTests {

    @Autowired
    GoodsMapper goodsMapper;

    @Test
    void addGoods() {
        Goods good = new Goods();
        good.setGid(SnowflakeUtil.getId());
        good.setGname("小米手机");
        good.setUserId(100L);
        good.setGstatus("已发布");
        goodsMapper.insert(good);
        Goods good2 = new Goods();
        good.setGid(SnowflakeUtil.getId());
        good2.setGname("华为手机");
        good2.setUserId(99L);
        good2.setGstatus("已发布");
        goodsMapper.insert(good2);
    }

    @Test
    void addGoods2() {
        for (int i = 0; i < 10; i++){
            Goods good = new Goods();
            good.setGid(SnowflakeUtil.getId());
            good.setGname("小米手机" + i);
            good.setUserId(100L);
            good.setGstatus("已发布");
            goodsMapper.insert(good);
        }
    }

    @Test
    void getGood3(){
        QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
        //此处根据实际gid值修改，还会查询goods表
        queryWrapper.eq("gid",1354449944638820361l);
        Goods good = goodsMapper.selectOne(queryWrapper);
        System.out.println(good.toString());
    }
}

结果

执行测试用例后，可以看到数据成功插入到了到各个表中

2025-03-26 18:17:05.606  INFO 41512 --- [           main] o.e.s.SharingJdbcTestApplicationTests    : Started SharingJdbcTestApplicationTests in 5.989 seconds (JVM running for 6.883)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31c7c281] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@7cd1ec54] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519547121405952(Long), 小米手机0(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.631  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.631  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.631  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_1  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519547121405952, 小米手机0, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@31c7c281]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15d0b458] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@72a0a60d] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519550837559297(Long), 小米手机1(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.678  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.678  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.678  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_2  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519550837559297, 小米手机1, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@15d0b458]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5e3405a1] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@22bfd4b] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519550954999810(Long), 小米手机2(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.704  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.704  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.704  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_1  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519550954999810, 小米手机2, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5e3405a1]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fa9247b] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@21ce3b22] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551034691587(Long), 小米手机3(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.723  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.723  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.723  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_2  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551034691587, 小米手机3, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fa9247b]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e2f6e13] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@18b30951] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551152132100(Long), 小米手机4(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.751  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.751  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.751  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_1  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551152132100, 小米手机4, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e2f6e13]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2697c156] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@1a88d194] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551223435269(Long), 小米手机5(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.768  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.769  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.769  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_2  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551223435269, 小米手机5, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2697c156]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fe13916] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@5ea0a7a9] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551311515654(Long), 小米手机6(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.790  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.790  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.790  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_1  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551311515654, 小米手机6, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fe13916]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@25e353dc] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@234ce7ff] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551370235911(Long), 小米手机7(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.804  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.804  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.804  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_2  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551370235911, 小米手机7, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@25e353dc]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@470f0637] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@6b278b17] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551437344776(Long), 小米手机8(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.819  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.819  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.820  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_1  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551437344776, 小米手机8, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@470f0637]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4203529f] was not registered for synchronization because synchronization is not active
JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@7d82ca56] will not be managed by Spring
==>  Preparing: INSERT INTO goods ( gid, gname, user_id, gstatus ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1354519551512842249(Long), 小米手机9(String), 100(Long), 已发布(String)
2025-03-26 18:17:06.836  INFO 41512 --- [           main] ShardingSphere-SQL                       : Logic SQL: INSERT INTO goods  ( gid,
gname,
user_id,
gstatus )  VALUES  ( ?,
?,
?,
? )
2025-03-26 18:17:06.836  INFO 41512 --- [           main] ShardingSphere-SQL                       : SQLStatement: SQL92InsertStatement(super=InsertStatement(super=AbstractSQLStatement(parameterCount=4, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), table=SimpleTableSegment(tableName=TableNameSegment(startIndex=12, stopIndex=16, identifier=IdentifierValue(value=goods, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), insertColumns=Optional[InsertColumnsSegment(startIndex=19, stopIndex=50, columns=[ColumnSegment(startIndex=21, stopIndex=23, identifier=IdentifierValue(value=gid, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=26, stopIndex=30, identifier=IdentifierValue(value=gname, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=33, stopIndex=39, identifier=IdentifierValue(value=user_id, quoteCharacter=NONE), owner=Optional.empty), ColumnSegment(startIndex=42, stopIndex=48, identifier=IdentifierValue(value=gstatus, quoteCharacter=NONE), owner=Optional.empty)])], insertSelect=Optional.empty, values=[InsertValuesSegment(startIndex=61, stopIndex=74, values=[ParameterMarkerExpressionSegment(startIndex=63, stopIndex=63, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=66, stopIndex=66, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=69, stopIndex=69, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=72, stopIndex=72, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty)])]))
2025-03-26 18:17:06.836  INFO 41512 --- [           main] ShardingSphere-SQL                       : Actual SQL: g1 ::: INSERT INTO goods_2  ( gid,
gname,
user_id,
gstatus )  VALUES  (?, ?, ?, ?) ::: [1354519551512842249, 小米手机9, 100, 已发布]
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4203529f]
2025-03-26 18:17:06.873  INFO 41512 --- [ionShutdownHook] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closing ...
2025-03-26 18:17:06.875  INFO 41512 --- [ionShutdownHook] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed
2025-03-26 18:17:06.876  INFO 41512 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2025-03-26 18:17:06.877  INFO 41512 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之基于seata+nacos+springcloud+shardingsphere的集成解决方案(十六)【万字博文】
笨鸟不会飞
12-27 1507
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之基于seata+nacos+springcloud+shardingsphere的集成解决方案(十六)
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之分表解决方案(一)
笨鸟不会飞
11-03 2003
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之分表解决方案
ShardingSphere5.1适配达梦数据库
欢迎每一位朋友不吝赐教，无论是宝贵的建议还是中肯的批评，都将是我前进路上不可或缺的灯塔
07-16 2347
Apache ShardingSphere 是一款分布式的数据库生态系统， 可以将任意数据库转换为分布式数据库，并通过数据分片、弹性伸缩、加密等能力对原有数据库进行增强。
shardingsphere 支持达梦数据库
热门推荐
jiejiegua的博客
03-29 1万+
1、项目中分表分库插件用的是 shardingsphere，现在需要从mysql 数据转移到达梦数据库。 2、但是shardingsphere并不支持达梦数据库，所以查看了源码。基于shardingsphere（4.1.1版本）源码优化了支持达梦数据库大部分sql查询能力，（复合查询需要自己拆解）。 1、第一步 首先找到 DataSourceMetaData 接口实现该接口 这里需要注意java 包路径 org.apache.shardingsphere.underlying.common.
shardingsphere 整合 达梦数据库 实现分表分库 (包含test demo)
03-29
1、shardingsphere 并不直接支持达梦数据库，需要实现部分接口逻辑。 2、本demo并不完全支持达梦sql 3、包里面含有test demo可以直接测试 4、感谢shardingsphere 团队。 5、具体如何实现的 请查看我的博文 https://blog.csdn.net/jiejiegua/article/details/123819390
ShardingSphere 5.2.1 版本使用
移动开发
12-28 4088
import cn/*** 按月分表的 Sharding 算法/*** 设置该参数的原因是，如果在范围查找的时候我们没有设置最小值，比如下面的查询* 这个时候范围查找就只有上限而没有下限，这时候就需要有一个下限值兜底，不能一致遍历下去/*** 在配置文件中配置算法的时候会配置 props 参数，框架会将props中的配置放在 properties 参数中，并且初始化算法的时候被调用try {try {} } } /*** 精确路由算法。
ShardingSphere5.2.1+达梦数据库
最新发布
03-26
ShardingSphere5.2.1+达梦数据库
【经验总结】ShardingSphere5.2.1 + Springboot 分库分表 快速开始
m0_74824534的博客
01-06 1182
Apache ShardingSphere （本文后续简称“SS”）是一款分布式的数据库生态系统， 可以将任意数据库转换为分布式数据库，并通过数据分片、弹性伸缩、加密等能力对原有数据库进行增强。Apache ShardingSphere 设计哲学为 Database Plus，旨在构建异构数据库上层的标准和生态。它关注如何充分合理地利用数据库的计算和存储能力，而并非实现一个全新的数据库。它站在数据库的上层视角，关注它们之间的协作多于数据库自身。ShardingSphere-JDBC 定位为。
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之基于分片容量的范围分片算法解决方案(十三)
笨鸟不会飞
12-28 1030
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之基于分片容量的范围分片算法解决方案(十三)
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之自动时间段分片算法解决方案(十五)
笨鸟不会飞
12-30 1842
基于springboot的ShardingSphere5.2.1的分库分表的解决方案之自动时间段分片算法解决方案(十五)
shardingSphere 适配达梦数据库
weixin_41039665的博客
10-26 2417
接下来就是在配置文件中配置好数据源和分片规则，就可以使用shardingSphere对达梦数据库进行分库分表操作了。1、在自己项目中引入shardingSphere的依赖：这里以4.1.1的版本为例，这里要说明的是，不同版本的shardingSphere对数据库类型的声明代码文件的位置不同，在进行扩展时要注意版本。到这里为止，就可以使用shardingSphere对达梦数据库进行基本的分库分表的操作了，更多的功能还没有进行研究，还是希望达梦官方可以对分库分表进行更多的支持，有更成熟的落地方案。
springboot整合ShardingSphere5.2.1（最新版）
qq_45502554的博客
09-14 2289
内容包含分表配置文件类型和自定义类型两种方法。无法直接上次代码，疯狂贴图。
ShardingSphere + 国产数据库，共同打造坚实的数字经济底座
ShardingSphere官微
04-14 1556
近日，Apache ShardingSphere 在与国产数据库合作方面取得了突破，继与国产开源数据库 openGauss 合作实现性能突破后，在 ShardingSphere 使用者的推动下，Apache ShardingSphere 也实现了与国产老牌数据库--达梦数据库的适配。这使得 Apache ShardingSphere 的数据库覆盖范围得到进一步增长，再次印...
Sharding-jdbc连接kingbasev8r6跨表分页
idto315的博客
09-09 2062
Sharding-jdbc连接kingbasev8r6跨表分页异常Can't find index: AggregationProjection
shardingsphere 5.2.1+springboot
05-10
ShardingSphere 5.2.1 SpringBoot是一个基于SpringBoot的分库分表中间件。它提供了分布式数据库解决方案，使得分库分表变得更为简单和易于管理。该中间件采用可靠的算法，实现了水平扩展，可以保证在高并发的情况下，数据的安全和稳定性。 ShardingSphere 5.2.1 SpringBoot可用于多种类型的应用程序，例如电子商务平台，物流管理系统，社交媒体等。该中间件支持水平分表和垂直分库，同时支持读写分离和动态数据源。它具有较高的性能，并提供了完善的监控和日志系统，方便开发者对整个系统进行监控和调试。 使用ShardingSphere 5.2.1 SpringBoot，开发者可以很轻松地集成分布式数据库，无需编写复杂的代码，只需配置相关的注解和XML文件。它支持一键启动，适用于开发和测试环境，也可以作为生产环境的解决方案。同时，该中间件具有极高的可靠性和容错能力，可以保证在节点宕机的情况下，系统的正常运行。 总之，ShardingSphere 5.2.1 SpringBoot是一款优秀的分库分表中间件，它既易于使用，又能够保证数据的安全和稳定性。它在分布式数据库解决方案领域中具有广泛的应用价值，有望成为未来分布式数据库的主流技术。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

angushine

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值