apache.shardingsphere 读写分离、分库分表（后续再完善读写分离+分库分表）

Apache ShardingSphere 分库分表与读写分离实践

最新推荐文章于 2025-11-02 15:09:00 发布

原创

最新推荐文章于 2025-11-02 15:09:00 发布 · 566 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #spring #sharding

本文介绍了如何使用Apache ShardingSphere实现数据库的读写分离和分库分表操作，首先讲解了添加依赖的步骤，接着详细阐述了分库分表的配置和实施过程。

读写分离

#添加依赖


		<dependency>
			<groupId>org.apache.shardingsphere</groupId>
			<artifactId>sharding-jdbc-core</artifactId>
			<version>4.0.0-RC1</version>
		</dependency>

#yml数据库配置(根节点)

database0:
  url: jdbc:mysql://***:3306/srment?characterEncoding=utf8&useSSL=false
  ##数据库database0用户名
  username: srment
  ##数据库database0密码
  password: ***
  ##数据库database0驱动
  driverClassName: com.mysql.cj.jdbc.Driver
  ##数据库database0名称
  databaseName: database0
database1:
  url: jdbc:mysql://***:13306/srment?characterEncoding=utf8&useSSL=false
  ##数据库database1用户名
  username: srment
  ##数据库database1密码
  password: ***
  ##数据库database1驱动
  driverClassName: com.mysql.cj.jdbc.Driver
  ##数据库database1名称
  databaseName: database1


#主库（写）
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;

import javax.sql.DataSource;

/**
 * 主数据库
 *
 * @author wenrd
 * @date 2020-12-18
 */
@ConfigurationProperties(prefix = "database0")
@Component
public class Database0Config {
    private String url;
    private String username;
    private String password;
    private String driverClassName;
    private String databaseName;

    public DataSource createDataSource() {
        DruidDataSource result = new DruidDataSource();
        result.setDriverClassName(getDriverClassName());
        result.setUrl(getUrl());
        result.setUsername(getUsername());
        result.setPassword(getPassword());
        return result;
    }

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getDriverClassName() {
        return driverClassName;
    }

    public void setDriverClassName(String driverClassName) {
        this.driverClassName = driverClassName;
    }

    public String getDatabaseName() {
        return databaseName;
    }

    public void setDatabaseName(String databaseName) {
        this.databaseName = databaseName;
    }
}

#从库（读）

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.autoconfigure.condition.ConditionalOnExpression;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;

import javax.sql.DataSource;

/**
 * @author wenrd
 * @date 2020/12/18
 */
@ConfigurationProperties(prefix = "database1")
@Component
public class Database1Config {
    private String url;
    private String username;
    private String password;
    private String driverClassName;
    private String databaseName;

    public DataSource createDataSource() {
        DruidDataSource result = new DruidDataSource();
        r