database replication

IT Services Circle

Jun 1, 2025 · Databases

Understanding MySQL Dual‑Master Architecture and Replication Modes

This article explains MySQL dual‑master architecture, covering dual‑master replication, master‑slave replication, master‑master with backup nodes, and ring replication, while discussing their advantages, common pitfalls such as loop replication and data inconsistency, and practical solutions to ensure high availability and data integrity.

Dual-MasterHigh AvailabilityMySQL

0 likes · 6 min read

Understanding MySQL Dual‑Master Architecture and Replication Modes

IT Architects Alliance

Apr 2, 2025 · Backend Development

Designing High‑Concurrency Backend Architecture for E‑commerce Platforms

The article explains how to design a scalable, highly available backend system capable of handling millions of requests per second by defining key performance metrics, estimating traffic with the 2/8 rule, and applying architectural patterns such as load‑balanced clusters, vertical service splitting, distributed caching, and database master‑slave replication, illustrated with a Taobao case study.

High Concurrencybackend architecturedatabase replication

0 likes · 14 min read

Designing High‑Concurrency Backend Architecture for E‑commerce Platforms

Tencent Cloud Developer

Nov 27, 2024 · Databases

Analyzing the Write‑After‑Read Consistency Challenge in Multi‑Active Distributed Architectures

The article examines the write‑after‑read consistency problem in multi‑active cross‑region systems, compares single‑write‑single‑read routing, quorum‑based multi‑write‑multi‑read, and read‑while‑copy methods, explains why primary‑secondary replication is preferred, and proposes a four‑step framework—scenario flagging, data marking, latency evaluation, and near‑by asynchronous replication—to meet WAR requirements efficiently.

architectureconsistencydatabase replication

0 likes · 12 min read

Analyzing the Write‑After‑Read Consistency Challenge in Multi‑Active Distributed Architectures

Aikesheng Open Source Community

Aug 13, 2024 · Databases

Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup

This article explains the MySQL 8.0 Clone plugin introduced in version 8.0.17, compares it with Xtrabackup, details its five‑step cloning process, describes the code structure across SQL, plugin, and InnoDB layers, and outlines the page‑archiving subsystem used to track dirty pages during cloning.

Clone PluginInnoDBMySQL

0 likes · 18 min read

Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup

Beijing SF i-TECH City Technology Team

Jun 18, 2024 · Databases

Design and Implementation of MySQL High Availability Using Orchestrator and DBProxy

This article presents a comprehensive design and implementation for achieving MySQL high availability by replacing the single‑master architecture with Orchestrator‑driven automatic failover, integrating DBProxy for transparent routing, and addressing topology changes and data compensation to ensure continuous, reliable service.

DBProxyData CompensationFailover

0 likes · 16 min read

Design and Implementation of MySQL High Availability Using Orchestrator and DBProxy

High Availability Architecture

Jan 25, 2024 · Backend Development

Scaling a System from Zero to One Million Users: Architecture, Load Balancing, Caching, and Database Replication

This article explains how to evolve a single‑server application into a highly available, horizontally scalable system that can serve over a million users by introducing load balancers, database replication, caching layers, CDNs, stateless network design, multi‑data‑center deployment, and message queues.

CDNCachingMessage Queue

0 likes · 26 min read

Scaling a System from Zero to One Million Users: Architecture, Load Balancing, Caching, and Database Replication

政采云技术

Dec 27, 2023 · Databases

Understanding MySQL Binary Log (binlog): Architecture, Usage, and Implementation

This article explains MySQL's binary log (binlog), a binary format file that records SQL statements for database updates, its role in master-slave replication, crash recovery, and detailed implementation mechanisms including cache management and event writing processes.

Database InternalsMaster‑SlaveMySQL

0 likes · 8 min read

Architect

Oct 29, 2023 · Databases

MongoDB Cluster Architecture: Master‑Slave, Replica Set, and Sharding

This article explains MongoDB's three cluster architectures—deprecated Master‑Slave replication, the highly available Replica Set with automatic failover, and horizontal scaling Sharding—detailing their roles, data flow, advantages, limitations, and operational considerations for building reliable, scalable databases.

Cluster ArchitectureHigh AvailabilityMongoDB

0 likes · 13 min read

MongoDB Cluster Architecture: Master‑Slave, Replica Set, and Sharding

Aikesheng Open Source Community

Jul 6, 2023 · Databases

Impact of MySQL lower_case_table_names on DTLE Data Synchronization

This article investigates how differing MySQL lower_case_table_names settings between source and target affect DTLE's ability to synchronize data, presenting test scenarios, observed behaviors, and recommendations for configuration and job management.

DTLEData SynchronizationMySQL

0 likes · 10 min read

Impact of MySQL lower_case_table_names on DTLE Data Synchronization

Mike Chen's Internet Architecture

Jun 29, 2023 · Databases

Database Master‑Slave Synchronization and Consistency Solutions

This article explains why master‑slave replication is needed in high‑concurrency scenarios, describes the consistency challenges it introduces, and presents three practical solutions—half‑synchronous replication, database middleware, and cache‑key recording—detailing their principles, advantages, and drawbacks.

Cache ConsistencyMySQLdatabase replication

0 likes · 8 min read

Database Master‑Slave Synchronization and Consistency Solutions

Architects Research Society

Apr 28, 2023 · Databases

High‑Availability Cluster Solutions for PostgreSQL

This article explains high‑availability concepts for PostgreSQL, reviews standby database types, describes clustering models, and evaluates several HA solutions such as DRBD, ClusterControl, Rubyrep, Pgpool II, Bucardo, Postgres‑XC, Citus, and PostgresXL, while noting practical considerations and trade‑offs.

ClusteringHA SolutionsHigh Availability

0 likes · 10 min read

High‑Availability Cluster Solutions for PostgreSQL

Top Architect

Mar 20, 2023 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache

This article explains two methods for keeping MySQL data in sync with a Redis cache—using MySQL triggers with a UDF function and parsing MySQL binlog streams—detailing their processes, advantages, limitations, and related open‑source tools like Canal.

Cache SynchronizationCanalMySQL

0 likes · 7 min read

Two Approaches to Synchronize MySQL Data with Redis Cache

Java Architect Essentials

Mar 13, 2023 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache

This article explains two technical solutions for keeping MySQL data in sync with Redis cache—using a MySQL trigger with a UDF function and parsing MySQL binlog events—while also reviewing the Canal open‑source tool and discussing their trade‑offs and implementation details.

Cache SynchronizationCanalMySQL

0 likes · 6 min read

Wukong Talks Architecture

Mar 7, 2023 · Databases

Ensuring MySQL Slave Node Availability with Keepalived and Read/Write Splitting

This article documents a MySQL read‑write splitting architecture, investigates an unexpected slave‑node crash, and provides a step‑by‑step guide to using Keepalived for monitoring and automatically restarting the MySQL container to achieve high availability of the replica.

DockerHigh AvailabilityKeepalived

0 likes · 7 min read

Ensuring MySQL Slave Node Availability with Keepalived and Read/Write Splitting

政采云技术

Jan 5, 2023 · Databases

Design and Implementation of a Go-Based MySQL-to-MySQL Data Synchronization System

This article presents a Go-based MySQL-to-MySQL data synchronization solution built on go-mysql-transfer, detailing its architecture, multi‑threaded design, binlog handling, DDL/DML ordering, and code implementation for reliable, ordered, and fault‑tolerant replication.

Data SynchronizationGoMySQL

0 likes · 20 min read

Design and Implementation of a Go-Based MySQL-to-MySQL Data Synchronization System

Code Ape Tech Column

Oct 14, 2022 · Backend Development

Designing Scalable Systems: From a Single Server to Multi‑Node Architecture

This article explains how to design and evolve a system from a single‑server deployment to a highly scalable architecture using vertical and horizontal scaling, load balancing, database replication, sharding, caching, CDN, and stateless design to support billions of users.

System Architecturedatabase replicationhorizontal scaling

0 likes · 20 min read

Designing Scalable Systems: From a Single Server to Multi‑Node Architecture

Code Ape Tech Column

Sep 15, 2022 · Databases

Understanding Data Heterogeneity: Scenarios, Methods, and Implementation with Binlog, Canal, and MQ

This article explains the concept of data heterogeneity, outlines common use cases such as sharding and multi‑dimensional queries, and details practical implementation methods including full cloning, marked sync, binlog‑based replication with Canal, and MQ‑driven approaches, while providing deployment tips and references.

CanalData HeterogeneityElasticsearch

0 likes · 12 min read

Understanding Data Heterogeneity: Scenarios, Methods, and Implementation with Binlog, Canal, and MQ

Aikesheng Open Source Community

Aug 15, 2022 · Databases

Step-by-Step Migration of Large MySQL Datasets to DBLE Using TiDB DM

This article provides a comprehensive, code‑rich guide on using TiDB DM v2.0.7 to perform full and incremental migration of terabyte‑scale MySQL data to DBLE, covering environment setup, TiDB DM installation, DBLE configuration, data generation, task execution, verification, and important operational considerations.

DBLEData MigrationMySQL migration

0 likes · 18 min read

Step-by-Step Migration of Large MySQL Datasets to DBLE Using TiDB DM

Ctrip Technology

Aug 11, 2022 · Databases

Design and Implementation of Ctrip's Data Replicate Center (DRC) for Database Cloud Migration

This article details Ctrip's Data Replicate Center (DRC) architecture, challenges, and solutions for migrating MySQL databases to the cloud, covering read‑only and read‑write scenarios, cost analysis, proxy modules, transaction‑table replication, data isolation, filtering, deployment workflow, and achieved performance and cost benefits.

CtripDRCMySQL replication

0 likes · 16 min read

Design and Implementation of Ctrip's Data Replicate Center (DRC) for Database Cloud Migration

Architecture Digest

Jul 29, 2022 · Databases

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

This tutorial explains how to configure MySQL master‑slave replication using Docker, set up read‑write splitting with ShardingSphereJDBC, integrate MyBatis‑Plus, and build a Spring Boot application that demonstrates write operations on the master and read operations on the slave.

DockerMyBatis-PlusMySQL

0 likes · 16 min read

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