BestHub
Sign in
Tagged articles

Database Replication

104 articles · Page 1 of 2
YiSu Grain
YiSu Grain
Aug 8, 2026 · Databases

Day 51: Database Architecture – Master‑Slave Replication, Read‑Write Separation, Sharding & Consistency

The article walks through diagnosing database bottlenecks, explains MySQL replication flow, read‑write separation benefits and limits, shows when to apply vertical versus horizontal partitioning, details sharding‑key selection, cross‑shard challenges, high‑availability steps, and presents a complete e‑commerce case study.

Database ReplicationHigh AvailabilityHorizontal Partitioning
0 likes · 29 min read
Day 51: Database Architecture – Master‑Slave Replication, Read‑Write Separation, Sharding & Consistency
ITPUB
ITPUB
Jun 27, 2026 · Databases

Why Does Database Master‑Slave Replication Lag Every Day at 5‑7 AM?

The article investigates why master‑slave replication delay spikes each morning between 05:00 and 07:00, tracing it to the inventory‑snapshot worker that floods binlog traffic, evaluates five mitigation strategies, implements a big‑data extraction pipeline to Elasticsearch, and reports that the nightly delay disappeared and disk utilization improved.

BDPDatabase ReplicationElasticsearch
0 likes · 9 min read
Why Does Database Master‑Slave Replication Lag Every Day at 5‑7 AM?
dbaplus Community
dbaplus Community
Jun 21, 2026 · Databases

Why Master‑Slave Replication Lags 5‑7 AM and How a Big‑Data Snapshot Fixes It

The article analyzes why the master‑slave database replication experiences 30‑minute delays each morning between 5 AM and 7 AM, traces the cause to massive inventory‑snapshot jobs, evaluates several mitigation options, and details a big‑data extraction workflow that eliminates the lag while reducing disk usage.

Database ReplicationElasticsearchHive
0 likes · 8 min read
Why Master‑Slave Replication Lags 5‑7 AM and How a Big‑Data Snapshot Fixes It
JD Tech
JD Tech
May 8, 2026 · Databases

Engineering Wisdom Behind High‑Availability Architecture for E‑Commerce Storage Layers

The article analyzes how to design a high‑availability architecture for large‑scale e‑commerce systems, detailing layered risk isolation, stateful storage strategies for flow and state data, unified document‑ID routing, multi‑replica databases, multi‑datacenter synchronization, and real‑world JD case studies that demonstrate elastic scaling and disaster recovery.

Database ReplicationDistributed ArchitectureHigh Availability
0 likes · 17 min read
Engineering Wisdom Behind High‑Availability Architecture for E‑Commerce Storage Layers
JD Tech
JD Tech
Dec 24, 2025 · Databases

How to Eliminate 30‑Minute Master‑Slave Lag in High‑Volume Inventory Systems

This article analyzes why a warehouse management system’s master‑slave database replication lagged up to 30 minutes during nightly inventory snapshot generation, evaluates several mitigation strategies, and details the chosen big‑data‑driven solution that moved snapshots to Elasticsearch, reducing lag and disk usage.

Database ReplicationElasticsearchHive
0 likes · 8 min read
How to Eliminate 30‑Minute Master‑Slave Lag in High‑Volume Inventory Systems
Raymond Ops
Raymond Ops
Oct 27, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera

This article examines three MySQL high‑availability solutions—MHA, Percona XtraDB Cluster, and Galera Cluster—detailing their architectures, advantages, limitations, deployment scenarios, and best‑practice recommendations to help engineers choose the most suitable approach for continuous, reliable database operations.

Cluster DeploymentDatabase ReplicationGalera
0 likes · 11 min read
Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera
Ray's Galactic Tech
Ray's Galactic Tech
Sep 27, 2025 · Databases

Master PostgreSQL Streaming Replication: Step‑by‑Step Setup Guide

This comprehensive guide explains PostgreSQL streaming replication concepts, required environment, primary and standby configuration commands, verification queries, failover procedures, and production best‑practice recommendations, enabling you to build a reliable high‑availability database cluster.

Database ReplicationFailoverHigh Availability
0 likes · 7 min read
Master PostgreSQL Streaming Replication: Step‑by‑Step Setup Guide
Liangxu Linux
Liangxu Linux
Jun 5, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera

An in‑depth comparison of three popular MySQL high‑availability architectures—MHA, Percona XtraDB Cluster (PXC), and Galera Cluster—covers their principles, architectures, strengths, limitations, deployment scenarios, and best‑practice recommendations to help you select the optimal solution for your production environment.

Database ReplicationGaleraHigh Availability
0 likes · 10 min read
Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera
IT Architects Alliance
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.

Backend ArchitectureDatabase ReplicationLoad Balancing
0 likes · 14 min read
Designing High‑Concurrency Backend Architecture for E‑commerce Platforms
Tencent Cloud Developer
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.

Database ReplicationMulti-Activeconsistency
0 likes · 12 min read
Analyzing the Write‑After‑Read Consistency Challenge in Multi‑Active Distributed Architectures
Aikesheng Open Source Community
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 PluginDatabase ReplicationInnoDB
0 likes · 18 min read
Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup
Beijing SF i-TECH City Technology Team
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.

DBProxyDatabase ReplicationFailover
0 likes · 16 min read
Design and Implementation of MySQL High Availability Using Orchestrator and DBProxy
Programmer DD
Programmer DD
May 23, 2024 · Backend Development

Mastering High‑Concurrency Architecture: From Metrics to Read/Write Splitting and Caching

This article explains the essential elements of high‑concurrency system design—performance, availability, scalability—introduces quantitative metrics, classifies read‑heavy and write‑heavy scenarios, and details practical solutions such as database read/write separation, local and distributed caching, cache‑penetration and avalanche mitigation, and CQRS implementation for billion‑user applications.

Database ReplicationRediscaching
0 likes · 22 min read
Mastering High‑Concurrency Architecture: From Metrics to Read/Write Splitting and Caching
MaGe Linux Operations
MaGe Linux Operations
May 19, 2024 · Databases

How to Deploy Xenon: A Raft‑Based MySQL HA Solution with Semi‑Sync and Parallel Replication

This guide walks through deploying Xenon, an open‑source Raft‑based MySQL high‑availability solution, covering environment setup, installation of Go and Percona XtraBackup, configuring Xenon’s JSON, starting the cluster, monitoring status, and troubleshooting backup failures caused by misconfigured host settings.

BackupDatabase ReplicationGo
0 likes · 8 min read
How to Deploy Xenon: A Raft‑Based MySQL HA Solution with Semi‑Sync and Parallel Replication
MaGe Linux Operations
MaGe Linux Operations
Feb 16, 2024 · Databases

Master Oracle Data Guard: Step‑by‑Step Master‑Slave Setup Guide

This comprehensive tutorial walks you through configuring Oracle Data Guard for master‑slave replication, covering prerequisites, detailed command‑by‑command steps, common pitfalls, testing procedures, switchover operations, and post‑switch recovery, all illustrated with diagrams and code snippets.

BackupData GuardDatabase Replication
0 likes · 24 min read
Master Oracle Data Guard: Step‑by‑Step Master‑Slave Setup Guide
21CTO
21CTO
Jan 27, 2024 · Operations

How to Scale a System to Over 1 Million Users: From One Server to Multi‑Data‑Center Architecture

This article walks you through building a scalable system—from a single‑server prototype to a multi‑data‑center design that uses load balancers, database replication, caching, CDNs, stateless layers, message queues and automated monitoring—to handle traffic from hundreds of thousands to millions of users.

CDNDatabase ReplicationLoad Balancing
0 likes · 26 min read
How to Scale a System to Over 1 Million Users: From One Server to Multi‑Data‑Center Architecture
High Availability Architecture
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.

CDNDatabase ReplicationLoad Balancing
0 likes · 26 min read
Scaling a System from Zero to One Million Users: Architecture, Load Balancing, Caching, and Database Replication
Programmer DD
Programmer DD
Jan 23, 2024 · Operations

How to Scale a System from Zero to One Million Users: Proven Strategies

This guide walks you through expanding a single‑server application into a highly available, horizontally‑scaled architecture that can serve over a million users by adding load balancers, database replication, caching layers, CDNs, stateless network design, multi‑data‑center support, message queues, monitoring and automation.

Database ReplicationLoad BalancingMessage Queue
0 likes · 26 min read
How to Scale a System from Zero to One Million Users: Proven Strategies
Architect
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 ArchitectureDatabase ReplicationMongoDB
0 likes · 13 min read
MongoDB Cluster Architecture: Master‑Slave, Replica Set, and Sharding
Mike Chen's Internet Architecture
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 ConsistencyDatabase ReplicationMySQL
0 likes · 8 min read
Database Master‑Slave Synchronization and Consistency Solutions
Programmer DD
Programmer DD
Jun 6, 2023 · Databases

How DBSyncer Enables Seamless Multi-Database Synchronization

DBSyncer is an open‑source middleware that synchronizes data across multiple databases such as MySQL, Oracle, SqlServer, PostgreSQL, Elasticsearch, Kafka and files, offering custom plug‑in development, real‑time monitoring, performance alerts, and detailed configuration guides for various connectors and use cases.

DBSyncerData synchronizationDatabase Replication
0 likes · 5 min read
How DBSyncer Enables Seamless Multi-Database Synchronization
Architects Research Society
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.

ClusteringDatabase ReplicationHA Solutions
0 likes · 10 min read
High‑Availability Cluster Solutions for PostgreSQL
21CTO
21CTO
Apr 4, 2023 · Databases

How to Keep MySQL and Redis In Sync: Two Practical Solutions Explained

This article compares two methods for synchronizing MySQL data with Redis cache—using MySQL triggers combined with a UDF function, and parsing MySQL binlog via tools like Canal—detailing their workflows, advantages, limitations, and implementation considerations.

CanalDatabase ReplicationMySQL
0 likes · 6 min read
How to Keep MySQL and Redis In Sync: Two Practical Solutions Explained
Top Architect
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.

CanalDatabase ReplicationMySQL
0 likes · 7 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
Java Architect Essentials
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.

CanalDatabase ReplicationMySQL
0 likes · 6 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
Aikesheng Open Source Community
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 MigrationDatabase Replication
0 likes · 18 min read
Step-by-Step Migration of Large MySQL Datasets to DBLE Using TiDB DM
Ctrip Technology
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.

CtripDRCDatabase Replication
0 likes · 16 min read
Design and Implementation of Ctrip's Data Replicate Center (DRC) for Database Cloud Migration
Architecture Digest
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.

Database ReplicationMySQLShardingSphere
0 likes · 16 min read
Guide to Setting Up MySQL Master‑Slave Replication with MyBatis‑Plus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting
IT Services Circle
IT Services Circle
Jul 18, 2022 · Databases

Migrating MySQL Dual-Master High Availability to Master‑Slave Architecture: Lessons Learned and Simple Conversion Steps

After a month of testing a MySQL dual‑master high‑availability setup, the author details the numerous pitfalls encountered—including primary key collisions, sync failures, and data inconsistencies—and explains why they switched to a simpler master‑slave configuration, providing step‑by‑step instructions for the conversion.

Database ReplicationHigh AvailabilityKeepalived
0 likes · 8 min read
Migrating MySQL Dual-Master High Availability to Master‑Slave Architecture: Lessons Learned and Simple Conversion Steps
dbaplus Community
dbaplus Community
Jul 3, 2022 · Databases

Master MySQL Clone Plugin: Installation, Usage, and Optimization

This guide explains MySQL 8.0.17's Clone Plugin—how to install it, perform local and remote clones, monitor progress via performance_schema, build replicas from cloned data, understand its internal stages, configure parameters, and compare it with XtraBackup.

BackupClone PluginDatabase Replication
0 likes · 19 min read
Master MySQL Clone Plugin: Installation, Usage, and Optimization
Shopee Tech Team
Shopee Tech Team
Jun 23, 2022 · Backend Development

ShopeePay Multi-Active Data Center Architecture and Unitization Strategy

ShopeePay replaces its traditional active‑standby design with a unit‑based multi‑active data‑center architecture—splitting user, public, and order data across independent units, employing routing tables, caches, and a dual‑active model that enables seamless failover, reduced latency, and continuous payment processing across two or more IDC sites.

Data CenterDatabase ReplicationShopeePay
0 likes · 22 min read
ShopeePay Multi-Active Data Center Architecture and Unitization Strategy
IT Architects Alliance
IT Architects Alliance
Jun 7, 2022 · Databases

Introduction to Change Data Capture (CDC) Practices

This article introduces the concept and practice of Change Data Capture (CDC), explaining how it captures database changes to provide real‑time incremental data for analytics and reporting without impacting source performance, and outlines modern CDC methods, challenges, and production‑ready system requirements.

CDCChange Data CaptureData Integration
0 likes · 8 min read
Introduction to Change Data Capture (CDC) Practices
IT Architects Alliance
IT Architects Alliance
May 11, 2022 · Databases

How Change Data Capture Enables Real‑Time Analytics Without Overloading Your Database

The article explains the fundamentals of Change Data Capture (CDC), describing how capturing DML changes from relational databases like MySQL or PostgreSQL can provide incremental, near‑real‑time data for analytics and reporting while preserving source performance, and outlines modern CDC architectures, transaction‑log based extraction, and production‑ready design considerations.

CDCChange Data CaptureDatabase Replication
0 likes · 9 min read
How Change Data Capture Enables Real‑Time Analytics Without Overloading Your Database
IT Xianyu
IT Xianyu
Apr 20, 2022 · Fundamentals

Designing Scalable Systems for Billions of Users: From a Single Server to Distributed Architecture

This article explains how to evolve a simple single‑server web application into a highly available, horizontally and vertically scalable system for billions of users by covering DNS, vertical and horizontal scaling, load balancing, database replication, sharding, denormalization, SQL/NoSQL choices, stateless design, caching, CDN and global deployment.

Database ReplicationLoad BalancingSystem Design
0 likes · 18 min read
Designing Scalable Systems for Billions of Users: From a Single Server to Distributed Architecture
Top Architect
Top Architect
Mar 9, 2022 · Backend Development

Designing a System to Scale to 100 Million Users: Architecture, Scalability, and Database Strategies

This article explains how to design a highly scalable system for tens of millions of users by starting with a simple single‑server setup, applying vertical and horizontal scaling, using load balancers, expanding relational databases, choosing between SQL and NoSQL, and employing advanced techniques such as caching, CDN, and GeoDNS.

Database ReplicationSystem Designcloud architecture
0 likes · 18 min read
Designing a System to Scale to 100 Million Users: Architecture, Scalability, and Database Strategies
Architects Research Society
Architects Research Society
Jan 7, 2022 · Databases

High‑Availability Clustering Solutions for PostgreSQL

This article explains the concepts of high availability, continuous recovery, and standby databases, then reviews various PostgreSQL clustering options such as DRBD, ClusterControl, Rubyrep, Pgpool‑II, Bucardo, Postgres‑XC, Citus, and PostgresXL, highlighting their features, advantages, and drawbacks.

ClusterControlClusteringDRBD
0 likes · 16 min read
High‑Availability Clustering Solutions for PostgreSQL
dbaplus Community
dbaplus Community
Dec 8, 2021 · Operations

How Xianyu Achieved Multi‑Region High Availability: Architecture, Challenges, and Solutions

This article details Xianyu's transition from a single‑site to a multi‑region deployment, covering scalability limits, disaster‑recovery strategies, traffic routing, data consistency decisions, service and database architecture, and the operational principles that enable low‑cost, high‑availability scaling across regions.

Database Replicationcloud architecturemulti-region deployment
0 likes · 19 min read
How Xianyu Achieved Multi‑Region High Availability: Architecture, Challenges, and Solutions
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 12, 2021 · Databases

Implementing High‑Availability PostgreSQL with Keepalived: Architecture, Setup, and Failover Procedures

This article explains how to use Keepalived together with PostgreSQL to build a two‑node high‑availability cluster, covering Keepalived's VRRP mechanism, host planning, installation steps, asynchronous master‑slave replication configuration, monitoring scripts, and detailed failover drills.

Database ReplicationFailoverHigh Availability
0 likes · 20 min read
Implementing High‑Availability PostgreSQL with Keepalived: Architecture, Setup, and Failover Procedures
Xianyu Technology
Xianyu Technology
Oct 14, 2021 · Cloud Computing

Multi-Region High Availability Architecture for Xianyu Recommendation Service

The Xianyu recommendation service was re‑architected into an active‑active, multi‑region high‑availability system—using a unified access‑layer router, centralizing long‑tail dependencies, keeping data unsharded, refactoring caches and MySQL replication, and adhering to traffic‑closed‑loop and availability‑first principles—to overcome latency, improve scalability, and ensure low‑cost disaster recovery across two regions and three data centers.

Database ReplicationHigh Availabilitymulti-region deployment
0 likes · 15 min read
Multi-Region High Availability Architecture for Xianyu Recommendation Service
dbaplus Community
dbaplus Community
Sep 26, 2021 · Databases

Why MySQL Auto‑Increment Can Leak Data and How Distributed IDs Offer a Safer Alternative

The article examines the 2012 GitHub data‑leak caused by MySQL master‑slave failover and auto_increment misuse, explains why developers' expectations of uniqueness, monotonicity and continuity are unrealistic, and proposes half‑sync replication and distributed ID algorithms like Snowflake as more reliable solutions.

Data ConsistencyDatabase ReplicationMySQL
0 likes · 9 min read
Why MySQL Auto‑Increment Can Leak Data and How Distributed IDs Offer a Safer Alternative
21CTO
21CTO
Aug 14, 2021 · Backend Development

Designing a System That Scales to 100 Million Users: Key Strategies

This guide explains how to build a highly available, scalable architecture for supporting hundreds of millions of users, covering decoupling, redundancy, vertical and horizontal scaling, load balancing, database replication, sharding, caching, CDN, GeoDNS, and best practices for progressive system expansion.

CDNDatabase ReplicationHigh Availability
0 likes · 19 min read
Designing a System That Scales to 100 Million Users: Key Strategies
ITPUB
ITPUB
May 19, 2021 · Databases

Mastering SQL Server AlwaysOn: Enterprise‑Ready High Availability Architecture

This article explains SQL Server's evolution from legacy high‑availability solutions to the modern AlwaysOn architecture, detailing its data‑synchronization process, synchronous and asynchronous commit modes, failover scenarios, and practical deployment recommendations for enterprises handling both moderate and terabyte‑scale workloads.

AlwaysOnDatabase ReplicationEnterprise Architecture
0 likes · 8 min read
Mastering SQL Server AlwaysOn: Enterprise‑Ready High Availability Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
May 17, 2021 · Databases

Using MySQL Federated Storage Engine for Remote Table Access

This article explains how to enable and configure MySQL's Federated storage engine to access remote tables without data synchronization, covering engine architecture, supported features, environment setup, server configuration, table creation, data manipulation, and binlog verification, along with practical code examples.

Database ReplicationFederated EngineMySQL
0 likes · 10 min read
Using MySQL Federated Storage Engine for Remote Table Access
Qingyun Technology Community
Qingyun Technology Community
Apr 26, 2021 · Databases

Sync MySQL to ClickHouse Using QingCloud MySQL Plus & MaterializeMySQL

This article explains how to break the barrier between heterogeneous databases by synchronizing MySQL to ClickHouse using QingCloud MySQL Plus and the MaterializeMySQL engine, covering MySQL replication history, architecture details, HTAP scenarios, and providing practical code examples for setup and operation.

ClickHouseData synchronizationDatabase Replication
0 likes · 13 min read
Sync MySQL to ClickHouse Using QingCloud MySQL Plus & MaterializeMySQL
Architecture Digest
Architecture Digest
Mar 18, 2021 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache: Trigger + UDF and Binlog Parsing (Canal)

The article explains two technical methods for keeping MySQL and Redis in sync—using MySQL triggers with a custom UDF to write directly to Redis, and parsing MySQL binlog streams (or using Alibaba's Canal) to propagate changes, while discussing their suitable scenarios, challenges, and implementation details.

CanalDatabase ReplicationMySQL
0 likes · 5 min read
Two Approaches to Synchronize MySQL Data with Redis Cache: Trigger + UDF and Binlog Parsing (Canal)
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.

Buffer ManagementDatabase InternalsDatabase Replication
0 likes · 7 min read
PostgreSQL Master-Slave Replication Performance Optimization: Solving Drop Table Bottleneck
dbaplus Community
dbaplus Community
Sep 23, 2020 · Databases

How JinS Achieves Multi‑Region Data Consistency and High Performance

Facing scalability limits, disaster risks, and latency in single‑region setups, OPPO built the JinS data‑sync framework, detailing its multi‑region challenges, design principles, modular architecture, consistency models, crash‑safe 2PC mechanisms, file‑queue optimizations, relay‑log handling, and performance gains over open‑source and commercial alternatives.

Data synchronizationDatabase ReplicationJinS
0 likes · 21 min read
How JinS Achieves Multi‑Region Data Consistency and High Performance
Dada Group Technology
Dada Group Technology
Sep 9, 2020 · Cloud Computing

Dada Dual-Cloud Active-Active Disaster Recovery: Architecture, Practices, and Lessons Learned

This article details Dada's dual‑cloud active‑active disaster‑recovery implementation, explaining high availability versus disaster recovery, describing the first‑phase architecture and challenges, and outlining the second‑phase enhancements such as multi‑data‑center Consul, bidirectional database replication, precise load‑balancing, tool adaptations, capacity elasticity, and future plans.

Active-ActiveCloud ComputingConsul
0 likes · 13 min read
Dada Dual-Cloud Active-Active Disaster Recovery: Architecture, Practices, and Lessons Learned
Architect's Tech Stack
Architect's Tech Stack
Sep 9, 2020 · Databases

How Redis Sentinel Implements Automatic Failover

This article explains how Redis Sentinel provides automatic failover by combining multi‑replica deployment, health monitoring, leader election, and distributed consensus to detect master failures, select a new master, promote it, and notify clients, ensuring high availability for Redis databases.

Automatic FailoverDatabase ReplicationHigh Availability
0 likes · 10 min read
How Redis Sentinel Implements Automatic Failover
ITPUB
ITPUB
Sep 8, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency

This article explains the three core MySQL logs—binlog, redo log, and undo log—their structures, formats, configuration parameters, and how they work together to provide replication, crash recovery, and transactional atomicity while balancing performance and consistency.

Database ReplicationMySQLRedo Log
0 likes · 11 min read
Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 12, 2020 · Databases

Evaluating Whether pt-table-checksum Affects Business Performance

This article presents a hands‑on experiment that measures the performance impact of using pt‑table‑checksum on a MySQL master‑slave setup, explains the tool’s design choices such as reduced lock‑wait time and RR isolation, and concludes that its effect on production traffic is minimal when configured properly.

Database ReplicationInnoDBMySQL
0 likes · 4 min read
Evaluating Whether pt-table-checksum Affects Business Performance
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 17, 2020 · Backend Development

Evolution of Large-Scale Website Architecture: Characteristics, Stages, and Best Practices

This article outlines the key characteristics of large‑scale web systems and walks through their architectural evolution—from monolithic beginnings to service separation, caching, clustering, read/write splitting, CDN/reverse‑proxy acceleration, distributed storage, NoSQL, business splitting, and distributed services—while highlighting core values and common design pitfalls.

Database ReplicationLoad Balancingbackend development
0 likes · 12 min read
Evolution of Large-Scale Website Architecture: Characteristics, Stages, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2020 · Databases

Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups

This article analyses why the GTID information recorded by Xtrabackup’s xtrabackup_binlog_info file can differ from the GTID shown by SHOW MASTER STATUS after a restore, comparing the behavior of Xtrabackup 2.4 on MySQL 5.7 and Xtrabackup 8.0 on MySQL 8.0, and explains the underlying backup processes and MySQL internals that cause the discrepancy.

BackupDatabase ReplicationGTID
0 likes · 14 min read
Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups
Efficient Ops
Efficient Ops
Nov 12, 2019 · Operations

Building High‑Availability Systems in Securities: Practices and Tech Choices

This article examines the unique regulatory and operational characteristics of the securities industry and explains how careful technology selection—ranging from native database log replay to third‑party replication and big‑data platforms—enables robust high‑availability architectures, illustrated with real‑world practices from Dongfang Securities.

Database ReplicationHigh AvailabilitySecurities Industry
0 likes · 14 min read
Building High‑Availability Systems in Securities: Practices and Tech Choices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2019 · Databases

Using MySQL 8.0 CLONE Plugin to Create Instance Replicas

This article explains how the MySQL 8.0 CLONE plugin simplifies creating reliable replica instances by installing the plugin, granting necessary privileges, executing the CLONE SQL statement, monitoring progress via performance_schema, and verifying successful completion of all clone stages.

CloneDatabase ReplicationInnoDB
0 likes · 12 min read
Using MySQL 8.0 CLONE Plugin to Create Instance Replicas
dbaplus Community
dbaplus Community
Jul 4, 2019 · Databases

How Tencent’s TDSQL Multi‑Source Sync Achieves High‑Performance, Consistent Data Distribution

This article explains the financial‑industry driven requirements for real‑time data sync, describes the TDSQL‑MULTISRCSYNC architecture—including producer, store, and consumer components—and details core designs such as row‑hash concurrency, idempotent binlog handling, and a lock‑based ordering mechanism that ensure high throughput and consistency.

Data synchronizationDatabase ReplicationIdempotency
0 likes · 13 min read
How Tencent’s TDSQL Multi‑Source Sync Achieves High‑Performance, Consistent Data Distribution
Aikesheng Open Source Community
Aikesheng Open Source Community
May 30, 2019 · Databases

Oracle GoldenGate Migration Guide: Oracle to MySQL Data Replication

This article provides a comprehensive step‑by‑step guide for migrating data from Oracle to MySQL using Oracle GoldenGate, covering architecture overview, environment setup, table and data migration, configuration of source and target processes, handling of common issues, data validation, and reference resources.

Data MigrationDatabase ReplicationOGG
0 likes · 22 min read
Oracle GoldenGate Migration Guide: Oracle to MySQL Data Replication
dbaplus Community
dbaplus Community
Oct 7, 2018 · Databases

How Alibaba Cloud Scaled SQL Server with AlwaysOn for Read/Write Separation

This article details Alibaba Cloud's evolution of SQL Server RDS, covering product growth, the challenges of read/write separation, technical evaluations of AlwaysOn versus Transactional Replication, cloud architecture iterations, and the final productized solution for high‑availability database services.

Alibaba CloudAlwaysOnDatabase Replication
0 likes · 12 min read
How Alibaba Cloud Scaled SQL Server with AlwaysOn for Read/Write Separation
Java Captain
Java Captain
Aug 18, 2018 · Backend Development

Key Characteristics and Architectural Strategies for Large-Scale Websites

The article outlines the defining traits of large‑scale websites—high concurrency, massive traffic, high availability, and huge data volumes—and explains how their architecture evolves from a single‑server setup to layered, distributed systems using caching, load balancing, database read/write splitting, CDN, NoSQL, and service isolation.

Backend ArchitectureDatabase ReplicationLoad Balancing
0 likes · 7 min read
Key Characteristics and Architectural Strategies for Large-Scale Websites
dbaplus Community
dbaplus Community
Aug 13, 2018 · Databases

How MySQL 8.0’s WriteSet Parallel Replication Eliminates Replication Lag

This article explains the evolution of MySQL replication, from the classic master‑slave model to schema‑level and group‑commit parallelism in 5.7, and finally the WriteSet‑based parallel replication introduced in MySQL 8.0, including configuration parameters, conflict‑detection logic, and performance test results.

Database ReplicationMySQLParallel Replication
0 likes · 19 min read
How MySQL 8.0’s WriteSet Parallel Replication Eliminates Replication Lag
Architecture Digest
Architecture Digest
Sep 1, 2017 · Operations

Comprehensive Guide to Scalable Website Architecture from an Operations Perspective

This article presents a step‑by‑step operations‑focused roadmap for evolving a website from a single‑server prototype to a highly available, horizontally scalable architecture using load balancing, caching, database replication, service‑oriented design, DNS round‑robin, CDN, and disaster‑recovery techniques.

Database ReplicationHigh AvailabilityLoad Balancing
0 likes · 10 min read
Comprehensive Guide to Scalable Website Architecture from an Operations Perspective
Qunar Tech Salon
Qunar Tech Salon
Aug 17, 2017 · Databases

Evolution of Meituan-Dianping MySQL High‑Availability Architecture: From MMM to MHA+Zebra and Beyond

This article reviews the evolution of Meituan‑Dianping's MySQL high‑availability architecture over recent years, detailing the transition from the MMM replication manager to MHA, the integration of Zebra and Proxy middleware, and future design considerations such as distributed agents, semi‑synchronous replication, and MySQL Group Replication.

Database ReplicationMHAMySQL
0 likes · 11 min read
Evolution of Meituan-Dianping MySQL High‑Availability Architecture: From MMM to MHA+Zebra and Beyond
WeChat Backend Team
WeChat Backend Team
Aug 3, 2017 · Databases

How PhxSQL Achieves Strong Consistency and High Availability for MySQL

This article explains the design and implementation of PhxSQL, a MySQL‑compatible high‑availability solution that uses a reliable log storage based on Paxos, Proxy request forwarding, automatic master election, and other mechanisms to overcome native MySQL replication flaws and provide strong data consistency and fault‑tolerant performance.

Database ReplicationHigh AvailabilityMySQL
0 likes · 17 min read
How PhxSQL Achieves Strong Consistency and High Availability for MySQL
dbaplus Community
dbaplus Community
Jun 18, 2017 · Fundamentals

Demystifying Paxos: How Distributed Systems Achieve Consensus

This article explains why Paxos is needed for consistency in distributed systems, details its roles and three-phase protocol, illustrates the algorithm with a real‑world analogy, and shows how Paxos underpins high‑availability database replication such as MySQL binlog synchronization.

Database ReplicationHigh AvailabilityPaxos
0 likes · 13 min read
Demystifying Paxos: How Distributed Systems Achieve Consensus
ITPUB
ITPUB
May 2, 2017 · Operations

How to Build Highly Scalable Applications: From Vertical to Horizontal Scaling

This article explains why scalability is a crucial non‑functional requirement, describes vertical (scale‑up) and horizontal (scale‑out) approaches, introduces the AKF model’s X/Y/Z axes, and provides practical guidance for scaling services, databases, caching, and deployment to achieve robust, high‑throughput applications.

AKF modelDatabase ReplicationVertical Scaling
0 likes · 34 min read
How to Build Highly Scalable Applications: From Vertical to Horizontal Scaling
21CTO
21CTO
Apr 28, 2017 · Backend Development

How Small Websites Grow into Scalable Giants: A Step‑by‑Step Architecture Guide

This article walks through the evolution of a website from a single‑server setup to a distributed, high‑performance architecture, covering service separation, caching strategies, server clustering, load balancing, database replication, CDN acceleration, distributed storage, NoSQL adoption, and modular business decomposition.

Database ReplicationLoad Balancingbackend
0 likes · 8 min read
How Small Websites Grow into Scalable Giants: A Step‑by‑Step Architecture Guide
Java Backend Technology
Java Backend Technology
Dec 29, 2016 · Backend Development

Mastering Database Read/Write Splitting with Spring AOP: A Practical Demo

This article explains the concept of read/write splitting in distributed databases, outlines two implementation methods—static dual data sources and dynamic AOP-based switching—provides a complete Spring‑MyBatis demo with configuration files, code snippets, and guidance on setting up master and slave connections.

Database ReplicationMyBatisSpring AOP
0 likes · 7 min read
Mastering Database Read/Write Splitting with Spring AOP: A Practical Demo
MaGe Linux Operations
MaGe Linux Operations
Dec 26, 2016 · Databases

Mastering MySQL High Availability with MHA: Step‑By‑Step Setup Guide

This article introduces MHA (Master High Availability) for MySQL, explains its architecture, outlines required hardware and software configurations, provides detailed commands to set up master and slave nodes, create configuration files, and demonstrates how to start and verify the high‑availability cluster.

Database ReplicationFailoverHigh Availability
0 likes · 8 min read
Mastering MySQL High Availability with MHA: Step‑By‑Step Setup Guide
ITPUB
ITPUB
Sep 19, 2016 · Databases

How Oracle Data Guard’s Maximum Protection Mode Handles Failures and Recovery

This article demonstrates how to enable Oracle Data Guard’s Maximum Protection mode, examines the behavior of primary and standby databases when the standby connection is broken, and walks through the resulting errors, forced shutdown, and step‑by‑step recovery back to normal operation.

Data GuardDatabase ReplicationHigh Availability
0 likes · 12 min read
How Oracle Data Guard’s Maximum Protection Mode Handles Failures and Recovery
dbaplus Community
dbaplus Community
Sep 7, 2016 · Cloud Computing

How Shandong Mobile Achieved Zero‑Downtime Dual‑Active Disaster Recovery in the Cloud

This article details Shandong Mobile's cloud‑based dual‑active architecture, covering virtualization, VMware HA/DRS, Oracle GoldenGate and ADG optimizations, large Layer‑2 network designs, heartbeat mechanisms to avoid split‑brain, comprehensive testing scenarios, and the resulting reductions in downtime and hardware costs.

Database ReplicationDisaster RecoveryNetwork Design
0 likes · 12 min read
How Shandong Mobile Achieved Zero‑Downtime Dual‑Active Disaster Recovery in the Cloud
ITPUB
ITPUB
Aug 10, 2016 · Databases

Step‑by‑Step Manual Setup of Oracle Data Guard on RH Linux

This guide walks through preparing the primary and standby Oracle 11g databases on RH Linux, configuring listeners, tnsnames, force logging, adding standby redo logs, editing parameter files, transferring files with RMAN, verifying roles, activating Active Data Guard, using snapshot standby, switching logs, and setting an archive‑log deletion policy.

Active Data GuardData GuardDatabase Replication
0 likes · 20 min read
Step‑by‑Step Manual Setup of Oracle Data Guard on RH Linux
MaGe Linux Operations
MaGe Linux Operations
Jul 31, 2016 · Databases

Mastering MySQL HA: How MHA Automates Failover and Online Master Switching

This article explains how MHA provides automated master monitoring, rapid failover within 10‑30 seconds, online master switching, various failover modes, extensible scripts, key commands, and best‑practice workflows to achieve high‑availability MySQL replication without performance impact.

AutomationDatabase ReplicationFailover
0 likes · 23 min read
Mastering MySQL HA: How MHA Automates Failover and Online Master Switching
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jun 24, 2016 · Backend Development

Scalable Web Architecture for Startup Companies

This article explains how startup engineers can design and implement a scalable web architecture—covering server clustering, load balancing, distributed caching, database replication, and team organization—to handle rapid user growth without compromising performance or reliability.

Database ReplicationLoad BalancingWeb Scaling
0 likes · 15 min read
Scalable Web Architecture for Startup Companies
21CTO
21CTO
Jun 17, 2016 · Backend Development

How to Build a Scalable Web Architecture for Fast‑Growing Startups

This article explains how startup engineers can design a scalable web system by separating services onto multiple servers, using load balancers, distributed caches, master‑slave replication, and team‑splitting strategies, ensuring performance and reliability as user traffic and data volumes surge.

Database ReplicationLoad Balancingbackend development
0 likes · 15 min read
How to Build a Scalable Web Architecture for Fast‑Growing Startups
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jun 13, 2016 · Backend Development

How to Build a Scalable Web Architecture for Fast‑Growing Startups

This article explains how startup engineers can design and evolve a scalable web architecture—covering server partitioning, load balancing, distributed caching, database replication, and team organization—to handle rapid user growth without compromising performance or reliability.

Database ReplicationLoad Balancingdistributed caching
0 likes · 16 min read
How to Build a Scalable Web Architecture for Fast‑Growing Startups
ITPUB
ITPUB
May 10, 2016 · Databases

Can MySQL Semi‑Sync Replication Keep Up? A Sysbench Performance Test

A performance test using sysbench on a dual‑node DL380 G7 MySQL 5.6 cluster shows that semi‑synchronous replication delivers roughly one‑third the TPS of asynchronous replication and highlights recovery and replication‑lag limitations that can be mitigated with sharding and parallel workers.

Database ReplicationMySQLPerformance Testing
0 likes · 6 min read
Can MySQL Semi‑Sync Replication Keep Up? A Sysbench Performance Test
21CTO
21CTO
May 8, 2016 · Databases

Which MySQL High‑Availability Architecture Is Right for You? A Comprehensive Guide

The article reviews common MySQL high‑availability solutions—including shared‑storage SAN, DRBD disk replication, keepalived/heartbeat, MHA, ZooKeeper‑based HA, Galera/PXC clusters, and proxy middleware—detailing their architectures, advantages, limitations, and suitability for different business and operational requirements.

ClusterDatabase ReplicationFailover
0 likes · 19 min read
Which MySQL High‑Availability Architecture Is Right for You? A Comprehensive Guide
Architect
Architect
Feb 25, 2016 · Databases

Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation

This article explains the design, configuration parameters, core data structures, initialization, coordinator distribution, worker execution, checkpointing, and shutdown procedures of MySQL 5.6's Multi‑Threaded Slave (MTS) parallel replication, providing a code‑level walkthrough for developers and DBAs.

CheckpointDatabase ReplicationMTS
0 likes · 17 min read
Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation
Architecture Digest
Architecture Digest
Feb 16, 2016 · Backend Development

Scalable Web Architecture for Startup Companies

The article explains how internet startups can design and evolve a scalable web architecture—through service separation, clustering, load balancing, distributed caching, database replication, and effective team organization—to handle rapid user growth and avoid performance bottlenecks.

Database ReplicationLoad BalancingWeb Development
0 likes · 15 min read
Scalable Web Architecture for Startup Companies
High Availability Architecture
High Availability Architecture
Jan 18, 2016 · Databases

Database High Availability Challenges and Paxos‑Based Solutions

This article examines the difficulties of achieving strong consistency and continuous availability in database replication, reviews the Paxos consensus protocol and its variants, and explains how Multi‑Paxos and clock‑driven leader election can be applied to build robust high‑availability architectures.

ConsensusDatabase ReplicationLeader Election
0 likes · 17 min read
Database High Availability Challenges and Paxos‑Based Solutions
21CTO
21CTO
Dec 5, 2015 · Databases

How Lync Server Leverages Multiple SQL Instances for High Availability

The article explains that Lync (Skype for Business) Server relies on several SQL Server instances—including CMS, RTC, and Rtcdyn—distributed across front‑end and back‑end servers, using push replication from a master to ensure data consistency and high availability, and discusses deployment considerations for standard versus enterprise editions.

Database ReplicationLync ServerSQL Server
0 likes · 6 min read
How Lync Server Leverages Multiple SQL Instances for High Availability