wlc19981111的博客

--config-master_slave.yaml：schemaName: master_slave_dbdataSources: master_ds: url: jdbc:mysql://127.0.0.1:3306/demo_ds_master?serverTimezone=UTC&useSSL=false username: root password: root connectionTimeoutMilliseconds: 30000 id

schemaName: sharding_dbdataSources: 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

# 增加数据源s0，使用上面主从同步配置的从库。spring.shardingsphere.datasource.names = m0,m1,m2,s0... spring.shardingsphere.datasource.s0.type = com.alibaba.druid.pool.DruidDataSourcespring.shardingsphere.datasource.s0.driver‐class‐name = com.mysql.jdbc.Driverspring.shardi

@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

CREATE TABLE t_user( user_id bigint(20) primary key, username varchar(100) not null, ustatus varchar(50) not null);@Repositorypublic interface UserMapper extends BaseMapper<User> {}# shardingjdbc分片策略# 配置数据源，给数据源起名称,# 水平分库，配置两个数据源sprin

@SpringBootApplication@MapperScan("com.example.mapper")public class ShardingDbApplication { public static void main(String[] args) { SpringApplication.run(ShardingDbApplication.class, args); }}@Repositorypublic interface CourseMapper extends Bas

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