BestHub
Sign in
Tagged articles

master‑slave replication

30 articles · Page 1 of 1
Senior Xiao Ying
Senior Xiao Ying
Feb 23, 2026 · Databases

MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing

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 AvailabilityProxySQLRead‑Write Splitting
0 likes · 12 min read
MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing
Architect Chen
Architect Chen
Jan 26, 2026 · Databases

Mastering MySQL Master‑Slave Replication: Architecture, Threads, and Setup

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.

Database ArchitectureHigh Availabilitybinary log
0 likes · 3 min read
Mastering MySQL Master‑Slave Replication: Architecture, Threads, and Setup
vivo Internet Technology
vivo Internet Technology
Sep 11, 2024 · Databases

Redis Cluster Slot Migration Optimization Based on Master-Slave Replication Mechanism

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.

RedisSlot Migrationcluster
0 likes · 14 min read
Redis Cluster Slot Migration Optimization Based on Master-Slave Replication Mechanism
Laravel Tech Community
Laravel Tech Community
May 23, 2024 · Databases

MySQL Master‑Slave Replication: Theory, Installation, Configuration, and Laravel Read‑Write Separation

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
MySQL Master‑Slave Replication: Theory, Installation, Configuration, and Laravel Read‑Write Separation
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jan 17, 2024 · Databases

Understanding Database Read‑Write Separation and Master‑Slave Replication

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.

Read‑Write Separationdatabasemaster‑slave replication
0 likes · 6 min read
Understanding Database Read‑Write Separation and Master‑Slave Replication
Sanyou's Java Diary
Sanyou's Java Diary
Aug 17, 2023 · Backend Development

How RocketMQ Achieves High Availability with Master‑Slave Replication

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.

Asynchronous ReplicationRocketMQbackend messaging
0 likes · 9 min read
How RocketMQ Achieves High Availability with Master‑Slave Replication
ITPUB
ITPUB
Nov 11, 2022 · Databases

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
ITPUB
ITPUB
Oct 29, 2022 · Databases

When and How to Implement Master‑Slave Read/Write Splitting in MySQL

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.

Read‑Write Splittingmaster‑slave replicationmysql
0 likes · 13 min read
When and How to Implement Master‑Slave Read/Write Splitting in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Aug 15, 2022 · Backend Development

Guide to Setting Up MySQL Master‑Slave Replication with MyBatisPlus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting

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.

DockerRead‑Write SplittingShardingSphere
0 likes · 15 min read
Guide to Setting Up MySQL Master‑Slave Replication with MyBatisPlus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting
dbaplus Community
dbaplus Community
Dec 7, 2021 · Backend Development

How to Ensure Cache‑Database Consistency: Strategies, Pitfalls & Best Practices

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.

Cacheasynchronous-retrydatabase-consistency
0 likes · 19 min read
How to Ensure Cache‑Database Consistency: Strategies, Pitfalls & Best Practices
Top Architect
Top Architect
Oct 2, 2021 · Databases

ShardingSphere-JDBC Tutorial: MySQL Master‑Slave Replication, Redo/Binlog, and Sharding Configuration

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.

JDBCShardingSphereSpring Boot
0 likes · 22 min read
ShardingSphere-JDBC Tutorial: MySQL Master‑Slave Replication, Redo/Binlog, and Sharding Configuration
Wukong Talks Architecture
Wukong Talks Architecture
Aug 27, 2021 · Databases

Understanding Redis Master‑Slave Architecture: Principles, Topologies, and Replication Mechanisms

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.

CachingDatabasesmaster‑slave replication
0 likes · 16 min read
Understanding Redis Master‑Slave Architecture: Principles, Topologies, and Replication Mechanisms
Top Architect
Top Architect
Jul 27, 2021 · Databases

ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation

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.

JDBCShardingSpheredatabase sharding
0 likes · 28 min read
ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation
Selected Java Interview Questions
Selected Java Interview Questions
Apr 18, 2021 · Databases

Understanding Master‑Slave Replication in Databases: Principles, Benefits, and Interview Questions

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.

DatabasesRead‑Write Splittinginterview preparation
0 likes · 6 min read
Understanding Master‑Slave Replication in Databases: Principles, Benefits, and Interview Questions
Tencent Cloud Developer
Tencent Cloud Developer
Jan 14, 2021 · Databases

PostgreSQL Master-Slave Replication Performance Optimization: Solving Drop Table Bottleneck

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.

Database InternalsPerformance OptimizationPostgreSQL
0 likes · 7 min read
PostgreSQL Master-Slave Replication Performance Optimization: Solving Drop Table Bottleneck
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 28, 2020 · Databases

Setting Up MySQL Master‑Slave Replication and Read/Write Splitting with Spring Boot

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.

Read/Write SplittingSpring Bootmaster‑slave replication
0 likes · 14 min read
Setting Up MySQL Master‑Slave Replication and Read/Write Splitting with Spring Boot
ITPUB
ITPUB
Jan 28, 2019 · Databases

How to Prevent Redis Single‑Point Failures with Sentinel and Master‑Slave Replication

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.

Disaster RecoveryHigh AvailabilityRedis
0 likes · 10 min read
How to Prevent Redis Single‑Point Failures with Sentinel and Master‑Slave Replication
Efficient Ops
Efficient Ops
Aug 24, 2017 · Databases

Mastering Redis Disaster Recovery: Sentinel and Manual Failover Strategies

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 AvailabilityRedisSentinel
0 likes · 11 min read
Mastering Redis Disaster Recovery: Sentinel and Manual Failover Strategies
Vipshop Quality Engineering
Vipshop Quality Engineering
Jul 11, 2017 · Backend Development

Why Master‑Slave Sync Delays Break Your Order Cache and How to Fix It

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.

Cache InvalidationRead‑Write SeparationRedis
0 likes · 5 min read
Why Master‑Slave Sync Delays Break Your Order Cache and How to Fix It
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Nov 15, 2016 · Databases

How to Set Up Redis Master‑Slave Replication in Minutes

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 AvailabilityRedis
0 likes · 5 min read
How to Set Up Redis Master‑Slave Replication in Minutes
21CTO
21CTO
Apr 21, 2016 · Databases

How to Set Up MySQL Read/Write Splitting with MySQLProxy

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.

MySQLProxyRead‑Write Splittingmaster‑slave replication
0 likes · 9 min read
How to Set Up MySQL Read/Write Splitting with MySQLProxy