# sharding_test

**Repository Path**: chenyuhua321/sharding_test

## Basic Information

- **Project Name**: sharding_test
- **Description**: 通过sharding-jdbc实现分库分表，读写分离操作
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2020-06-27
- **Last Updated**: 2021-08-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# sharding_test

#### 介绍
通过sharding-jdbc实现分库分表，读写分离操作

## 一、环境介绍

虚拟机linux版本：centos7

Mysql版本:5.7.29

JAVA 11

shardingsphere 4.1.0

springboot 2.2.5.RELEASE



## 二、机器说明

master0:192.168.230.129

slave0:192.168.230.130

slave1:192.168.230.131

master1:192.168.230.133

slave2:192.168.230.134

slave3:192.168.230.135



master负责写，slave负责读

master0,master1作为主库，corder表根据userId进行数据分片到master0，master1上

slave0，slave1为master0的从库

slave2，slave3为master1的从库