Tackling Data Consistency: Master‑Slave, Master‑Master & Leaderless Architectures

The article examines why distributed systems inevitably face data‑consistency challenges and breaks down three common service‑architecture patterns—master‑slave, master‑master, and leaderless—detailing their replication mechanisms, advantages, drawbacks, and practical solutions such as synchronous, semi‑synchronous, asynchronous replication, quorum handling, node‑failure recovery, and conflict resolution strategies.

Data ConsistencyDistributed SystemsMaster‑Slave

0 likes · 14 min read

Tackling Data Consistency: Master‑Slave, Master‑Master & Leaderless Architectures

Tencent Cloud Developer

Mar 26, 2024 · Databases

Data Consistency in Distributed Systems: Master‑Slave, Master‑Master, and Leaderless Architectures

The article compares master‑slave, master‑master, and leaderless distributed architectures, explaining how synchronous, semi‑synchronous, and asynchronous replication affect consistency, latency and scalability, and showing that each pattern trades write throughput, conflict‑resolution complexity, and availability against strong data correctness.

Data ConsistencyDistributed SystemsMaster‑Slave

0 likes · 15 min read

Data Consistency in Distributed Systems: Master‑Slave, Master‑Master, and Leaderless Architectures

dbaplus Community

Sep 20, 2023 · Databases

Why MySQL Master‑Master Isn't Recommended and How to Build a Safe Dual‑Master Setup with dbops

The article explains why master‑master MySQL architectures are discouraged, outlines the pitfalls of dual‑write setups, and provides step‑by‑step instructions using dbops to deploy a master‑slave topology and manually create a reversible master‑master configuration for testing.

Database ArchitectureGTIDdbops

0 likes · 15 min read

Why MySQL Master‑Master Isn't Recommended and How to Build a Safe Dual‑Master Setup with dbops

dbaplus Community

Jun 22, 2022 · Databases

How to Build a MySQL Master‑Master HA Cluster with Keepalived: Step‑by‑Step Guide

This article walks through setting up a high‑availability MySQL environment using master‑master replication and Keepalived on two Ubuntu servers, covering architecture design, Docker container preparation, MySQL configuration, Keepalived installation, failover testing, and troubleshooting common issues.

DockerHALinux

0 likes · 23 min read

How to Build a MySQL Master‑Master HA Cluster with Keepalived: Step‑by‑Step Guide

Wukong Talks Architecture

May 17, 2022 · Databases

Implementing MySQL Master‑Master High Availability with Keepalived: A Step‑by‑Step Guide

This article provides a comprehensive, English‑language tutorial on building MySQL master‑master high availability using Keepalived, covering architecture design, Docker‑based MySQL deployment, replication configuration, Keepalived installation, virtual IP setup, failover testing, and a detailed list of encountered pitfalls and their solutions.

Dockerhigh-availabilitymaster-master

0 likes · 22 min read

Implementing MySQL Master‑Master High Availability with Keepalived: A Step‑by‑Step Guide

Full-Stack Internet Architecture

May 13, 2021 · Databases

Database High‑Availability Architectures: Master‑Slave, Master‑Master, and Automatic Failover

This article explains common database high‑availability designs—including master‑slave, master‑master, and automatic failover architectures—their topologies, advantages, disadvantages, and practical considerations such as replication lag, manual intervention, and data consistency challenges.

Master‑SlaveReplicationdatabase

0 likes · 7 min read

Database High‑Availability Architectures: Master‑Slave, Master‑Master, and Automatic Failover