Tagged articles
Master-Slave Replication
35 articles · Page 1 of 1

liandkSep 11, 2026 · Databases
This article provides a comprehensive practical guide to MySQL master-slave replication, covering synchronization principles, three replication modes, delay causes and troubleshooting, read-write splitting implementation with common pitfalls, failover strategies, and five production pitfalls to avoid.
Database High AvailabilityDatabase ReplicationFailover
0 likes · 12 min read

This article breaks down the four-step architecture design of a high-concurrency encyclopedia system, covering latency-driven multi-data-center deployment, a five-layer request chain with caching at each level, a three-tier optimization pyramid, and master-slave synchronization with automatic failover for disaster recovery.
CDN cachingCanalGeoDNS
0 likes · 8 min read

This article compares four Redis deployment modes—standalone, master-slave replication, sentinel, and cluster—detailing their architectures, pros, cons, and ideal use cases to help developers choose the best option for scalability and high availability.
ClusterDatabase ArchitectureHigh Availability
0 likes · 6 min read

This comprehensive guide covers MySQL read-write separation from fundamentals to production implementation, including master-slave replication principles, replication lag causes and three enterprise-grade solutions, one-master-multi-slave architecture patterns, MHA automatic failover, Sharding-JDBC middleware configuration, and five critical production pitfalls to avoid.
Database ArchitectureHigh AvailabilityMHA
0 likes · 10 min read

This article provides a comprehensive production guide for Redis Cluster, covering cluster selection, hash slot principles, data skew solutions for big and hot keys, scaling strategies, master-slave replication latency handling, failure scenarios like split-brain, and a 7-point checklist with a real e-commerce case study.
Big KeyCaffeineData Skew
0 likes · 13 min read

By configuring master‑slave replication, implementing read‑write splitting with ProxySQL, and selecting appropriate load‑balancing strategies, you can significantly improve MySQL’s scalability and availability while addressing replication lag through parallel or semi‑synchronous replication, hardware tuning, and monitoring.
High AvailabilityMaster-Slave ReplicationMySQL
0 likes · 12 min read

This article explains MySQL master‑slave replication, covering its purpose for high availability and read‑write separation, typical one‑master‑multiple‑slaves architecture, the binlog‑based synchronization mechanism, and the roles of the master’s dump thread and the slave’s I/O and SQL threads.
Binary LogDatabase ArchitectureHigh Availability
0 likes · 3 min read

Vivo’s storage team redesigned Redis cluster slot migration by disguising the target as a slave and using master‑slave replication with progressive loading, which eliminates ask‑move round trips, reduces latency spikes, consolidates topology updates, and ensures stable access and high availability during horizontal scaling.
ClusterMaster-Slave ReplicationRedis
0 likes · 14 min read

This article explains the concept of MySQL master‑slave replication, outlines its advantages and drawbacks, and provides a step‑by‑step guide—including downloading MySQL 8.0, configuring my.cnf on master and slave servers, creating replication users, setting up replication parameters, and using Laravel for read‑write splitting—complete with all necessary shell and SQL commands.
Database ConfigurationLaravelLinux
0 likes · 9 min read

This guide walks through creating a three‑node MySQL environment, installing and configuring MariaDB, establishing master‑slave replication, and implementing read/write splitting on an application server using MySQL‑Proxy, complete with command‑line examples and configuration snippets.
LinuxMaster-Slave ReplicationMySQL
0 likes · 11 min read

This article explains Redis master‑slave replication, covering read‑write separation, configuration steps for master and slave nodes, the PSYNC synchronization protocol, and how these mechanisms together provide high availability and consistent data across distributed Redis deployments.
High AvailabilityMaster-Slave ReplicationPSYNC
0 likes · 12 min read

This article explains the concept of database read‑write separation, why it improves performance in high‑concurrency scenarios, when to apply it, the underlying master‑slave replication mechanism, and provides a MySQL example illustrating the steps of replication and its benefits for scalability and availability.
Master-Slave ReplicationMySQLRead-Write Separation
0 likes · 6 min read


ITPUBAug 29, 2023 · Databases
This article explains the MySQL master‑slave switch process, why the internal event_scheduler thread cannot be killed, the differences between MySQL 5.7 and 8.0, and provides step‑by‑step commands for enabling, creating, viewing, modifying, and deleting scheduled events.
Event SchedulerMaster-Slave ReplicationMySQL
0 likes · 11 min read

This article explains RocketMQ's master‑slave replication mechanism, comparing synchronous and asynchronous modes, detailing metadata and message data copying processes, and showing how synchronous guarantees are implemented using CompletableFuture to ensure high availability.
Master-Slave ReplicationRocketMQasynchronous replication
0 likes · 9 min read


ITPUBNov 11, 2022 · Databases
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 middlewareMaster-Slave ReplicationMySQL
0 likes · 13 min read


ITPUBOct 29, 2022 · Databases
This article explains when read/write splitting is needed, details MySQL master‑slave replication mechanics, outlines middleware design choices, and provides practical monitoring and mitigation strategies for replication lag, helping developers decide and implement effective database scaling.
Master-Slave ReplicationMySQLread-write splitting
0 likes · 13 min read

This tutorial walks through the complete process of configuring MySQL master‑slave replication, preparing Docker containers, configuring MyBatisPlus and ShardingSphereJDBC for read‑write splitting, building a Spring Boot project with the necessary dependencies, generating code, and testing the setup with sample controller endpoints.
DockerMaster-Slave ReplicationShardingSphere
0 likes · 15 min read

This guide explains the concepts, benefits, and step‑by‑step configuration of MySQL master‑slave replication and read/write splitting, including required master and slave settings, practical VM setup, and Mycat configuration files for routing reads and writes.
Database High AvailabilityMaster-Slave ReplicationMySQL
0 likes · 12 min read

This article explains why caching improves performance, examines the trade‑offs between cache utilization and data consistency, analyzes concurrency‑induced inconsistency scenarios, compares update‑then‑delete versus delete‑then‑update approaches, and recommends asynchronous retry with message queues or binlog subscription to reliably keep cache and database in sync.
CacheDelayed Double DeleteMaster-Slave Replication
0 likes · 19 min read

This article provides a comprehensive guide on using ShardingSphere-JDBC for read‑write splitting, configuring MySQL master‑slave replication with Docker, explaining redo log and binlog mechanisms, demonstrating two‑phase commit, and showing how to implement database sharding and distributed primary keys in a Spring Boot application.
JDBCMaster-Slave ReplicationMySQL
0 likes · 22 min read

This article explains the fundamentals of Redis master‑slave architecture, covering why high‑availability replication is needed, the three topology patterns, the three replication modes (continuous, full, partial), the replication backlog buffer, PSYNC command handling, heartbeat mechanisms, and the practical considerations for operators and architects.
CachingMaster-Slave Replicationdatabases
0 likes · 16 min read

This article introduces ShardingSphere‑Jdbc as a lightweight Java JDBC framework, details step‑by‑step Docker‑based MySQL master‑slave replication configuration, reviews redo log and binlog mechanisms, explains two‑phase commit, and demonstrates read‑write splitting and sharding strategies with Spring Boot examples.
JDBCMaster-Slave ReplicationMySQL
0 likes · 28 min read

This article explains the concept, advantages, and inner workings of master‑slave database replication, outlines the key threads and step‑by‑step process, and provides common interview questions with concise answers for candidates preparing for database engineering roles.
Interview PreparationMaster-Slave ReplicationMySQL
0 likes · 6 min read

The article explains how massive DROP TABLE operations in PostgreSQL master‑slave replication trigger costly buffer‑invalidation loops that cause severe lag, and describes extracting this step into a separate subprocess with a shared hash table, cutting replication lag from over 400 GB to about 10 MB—a 30,000‑fold speedup.
Buffer ManagementDatabase InternalsDatabase Replication
0 likes · 7 min read

This guide explains how to install MySQL 8.0.16 on two CentOS7 servers, configure master‑slave replication with binlog, set up read/write splitting, and integrate the setup into a Spring Boot application using dynamic‑datasource, covering all necessary commands, configuration files, and code examples.
Master-Slave ReplicationMySQLRead/Write Splitting
0 likes · 14 min read

This guide walks through preparing three CentOS 7 servers, installing Redis 6.0.3, configuring master‑slave replication, handling common compilation errors, setting up system startup, adjusting firewall and Redis settings, and finally enabling Sentinel for high‑availability monitoring.
CachingCentOSMaster-Slave Replication
0 likes · 6 min read

This article explains the fundamentals of database read‑write separation, compares master‑slave and master‑backup concepts, discusses replication lag issues, and presents code‑level and middleware approaches for routing reads and writes efficiently.
Database ArchitectureMaster-Slave ReplicationReplication Lag
0 likes · 6 min read


ITPUBJan 28, 2019 · Databases
This article explains Redis’s key features and common use cases, highlights the risks of single‑node deployments, compares two master‑slave replication architectures, and outlines their pros and cons, and details how Redis Sentinel provides automated monitoring, failover, and configuration to achieve high availability.
High AvailabilityMaster-Slave ReplicationRedis
0 likes · 10 min read

This article explains how to protect Redis deployments from single‑point failures by using master‑slave replication, manual failover procedures, and the automated high‑availability Sentinel solution, providing practical guidance for reliable disaster recovery in non‑clustered environments.
High AvailabilityMaster-Slave ReplicationRedis
0 likes · 11 min read

An order system retrieved incorrect product size data due to master‑slave database lag causing stale Redis cache, and the article explains the original flawed flow, the revised solution that writes to cache during sync, and best practices for cache updates, read‑through, and QA testing.
Master-Slave ReplicationRead-Write SeparationRedis
0 likes · 5 min read

This guide walks through securing MySQL/MariaDB master‑slave replication over a network using SSL encryption, covering environment setup, certificate generation, server configuration, replication testing, troubleshooting common errors, and ensuring only SSL‑based replication users can connect.
Database SecurityMariaDBMaster-Slave Replication
0 likes · 5 min read

This guide walks you through configuring a simple Redis master‑slave setup, covering the benefits, step‑by‑step file modifications, essential replication directives, testing procedures, and common pitfalls to ensure high availability and read/write separation.
ConfigurationHigh AvailabilityMaster-Slave Replication
0 likes · 5 min read


21CTOApr 21, 2016 · Databases
Learn the fundamentals of MySQL read/write splitting, why it boosts performance, and step‑by‑step instructions to configure master‑slave replication, create users, set up MySQLProxy, and verify the split‑read behavior using command‑line examples on a test environment.
Master-Slave ReplicationMySQLMySQLProxy
0 likes · 9 min read

This article analyzes YouPai.com's evolution from a simple master‑slave setup to horizontal sharding using a mapping table, detailing migration steps, access flow, and challenges such as cross‑database joins, consistency, and ID generation.
Horizontal PartitioningMapping TableMaster-Slave Replication
0 likes · 6 min read

This tutorial walks through setting up secure MySQL/MariaDB master‑slave replication over a network using SSL encryption, covering environment preparation, installation, configuration of both master and slave servers, certificate generation, SSL integration, troubleshooting, and verification of data synchronization.
Database SecurityLinuxMariaDB
0 likes · 11 min read
