分库分表
CodeBoyWLC
技术+原理爱好者
展开
-
【分库分表】ShardingSphere-Proxy:实现读写分离
--config-master_slave.yaml: schemaName: master_slave_db dataSources: master_ds: url: jdbc:mysql://127.0.0.1:3306/demo_ds_master?serverTimezone=UTC&useSSL=false username: root password: root connectionTimeoutMilliseconds: 30000 id原创 2021-05-07 22:16:47 · 244 阅读 · 0 评论 -
【分库分表】ShardingSphere-Proxy:实现分库
schemaName: sharding_db dataSources: ds_0: url: jdbc:mysql://127.0.0.1:3306/course_db_1?serverTimezone=UTC&useSSL=false username: root password: root connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifet原创 2021-05-07 22:15:26 · 114 阅读 · 0 评论 -
【分库分表】ShardingSphere-JDBC:读写分离+主从复制操作
# 增加数据源s0,使用上面主从同步配置的从库。 spring.shardingsphere.datasource.names = m0,m1,m2,s0 ... spring.shardingsphere.datasource.s0.type = com.alibaba.druid.pool.DruidDataSource spring.shardingsphere.datasource.s0.driver‐class‐name = com.mysql.jdbc.Driver spring.shardi原创 2021-05-07 22:12:51 · 321 阅读 · 1 评论 -
【分库分表】ShardingSphere-JDBC:公共表操作
@Data @TableName(value = "t_udict") public class Udict { private Long dictid; private String ustatus; private String uvalue; # shardingjdbc分片策略 # 配置数据源,给数据源起名称, # 水平分库,配置两个数据源 spring.shardingsphere.datasource.names=m1,m2,m0 # 一个实体类对应两张表,覆盖 spring.m原创 2021-05-07 22:06:44 · 218 阅读 · 0 评论 -
【分库分表】ShardingSphere-JDBC:垂直分库操作
CREATE TABLE t_user( user_id bigint(20) primary key, username varchar(100) not null, ustatus varchar(50) not null ); @Repository public interface UserMapper extends BaseMapper<User> { } # shardingjdbc分片策略 # 配置数据源,给数据源起名称, # 水平分库,配置两个数据源 sprin原创 2021-05-07 22:04:50 · 123 阅读 · 0 评论 -
【分库分表】ShardingSphere-JDBC:水平分库操作
@SpringBootApplication @MapperScan("com.example.mapper") public class ShardingDbApplication { public static void main(String[] args) { SpringApplication.run(ShardingDbApplication.class, args); } } @Repository public interface CourseMapper extends Bas原创 2021-05-07 22:03:18 · 150 阅读 · 0 评论 -
【分库分表】ShardingSphere-JDBC:水平分表操作
CREATE TABLE course_1( cid bigint(20) primary key, cname varchar(50) not null, user_id bigint(20) not null, cstatus varchar(10) not null ); CREATE TABLE course_2( cid bigint(20) primary key, cname varchar(50) not null, user_id bigint(20) not原创 2021-05-07 21:59:57 · 173 阅读 · 0 评论