Master‑Slave Replication & Read/Write Splitting in MySQL: Benefits, Pitfalls, Tips

This article explains how MySQL master‑slave replication enables read/write splitting, details the asynchronous replication process, discusses latency and its impact on business logic, and presents practical mitigation strategies along with middleware options for accessing replicated databases.

DB middlewareReplication Lagmaster-slave replication

0 likes · 13 min read

Master‑Slave Replication & Read/Write Splitting in MySQL: Benefits, Pitfalls, Tips

macrozheng

Jan 16, 2020 · Databases

How to Implement MySQL Read/Write Splitting with Xiaomi’s Gaea Middleware

This guide explains how to use Xiaomi's open‑source Gaea middleware to achieve automatic MySQL read/write separation, covering Go environment setup, Gaea compilation, configuration files, Docker deployment, testing procedures, and integration with SpringBoot.

DockerGaeaGo

0 likes · 9 min read

How to Implement MySQL Read/Write Splitting with Xiaomi’s Gaea Middleware

dbaplus Community

Jul 24, 2018 · Databases

How Cetus Middleware Optimizes MySQL Read Load Balancing and Performance

This article explains how the open‑source Cetus middleware addresses MySQL read/write pressure by implementing master‑slave and inter‑replica load‑balancing strategies, configurable routing parameters, and performance optimizations that improve throughput, especially in long‑connection scenarios.

Cetusload balancingmysql

0 likes · 9 min read

How Cetus Middleware Optimizes MySQL Read Load Balancing and Performance