Master ShardingSphere: Implement Database Sharding, Read‑Write Splitting & Distributed Transactions

This article introduces ShardingSphere, an open‑source distributed database middleware, explains its core features such as horizontal sharding, read‑write separation, and distributed transactions, and provides a step‑by‑step configuration and Java usage example.

Distributed TransactionsJavaRead-Write Splitting

0 likes · 6 min read

Master ShardingSphere: Implement Database Sharding, Read‑Write Splitting & Distributed Transactions

Code Ape Tech Column

Jan 28, 2021 · Databases

Configuring MyCat with MySQL Master‑Slave and SpringBoot for Read‑Write Splitting

This tutorial explains how to set up MySQL master‑slave replication, configure MyCat as a database middleware, install and configure MyCat, and integrate it with a SpringBoot application using dynamic data sources and AOP to achieve transparent read‑write separation.

JavaMycatRead-Write Splitting

0 likes · 13 min read

Configuring MyCat with MySQL Master‑Slave and SpringBoot for Read‑Write Splitting

Code Ape Tech Column

Jan 22, 2021 · Databases

Implementing Database Read-Write Separation with Spring Boot and MySQL

This article explains how to achieve database read‑write separation in high‑concurrency scenarios using Spring Boot, Druid connection pool, and MySQL, covering master‑slave data source configuration, routing via AbstractRoutingDataSource, context holder management, custom annotations, AOP switching, and usage examples with code snippets.

DataSource RoutingJavaRead-Write Splitting

0 likes · 11 min read

Implementing Database Read-Write Separation with Spring Boot and MySQL