Tagged articles
5 articles
Page 1 of 1
Liangxu Linux
Liangxu Linux
Jul 29, 2024 · Databases

How to Build a Reliable MySQL Master‑Master Cluster with Keepalived Failover

This guide walks through the complete process of creating a MySQL dual‑master replication cluster, configuring replication users, synchronizing binary logs, setting up keepalived for virtual IP failover, and testing both data consistency and high‑availability monitoring.

Master-Master Replicationdatabase clusteringhigh availability
0 likes · 8 min read
How to Build a Reliable MySQL Master‑Master Cluster with Keepalived Failover
Efficient Ops
Efficient Ops
Oct 16, 2023 · Databases

Why Master‑Master MySQL Replication Is Risky and How to Avoid Its Pitfalls

This article explains why the dbops tool does not support MySQL master‑master architecture, describes the two common dual‑master patterns, outlines their drawbacks such as role‑confusion, dirty‑data risk, split‑brain, and update loss, and provides practical workarounds and step‑by‑step deployment instructions to safely implement or avoid dual‑master setups.

GTIDMaster-Master Replicationdbops
0 likes · 17 min read
Why Master‑Master MySQL Replication Is Risky and How to Avoid Its Pitfalls
ITPUB
ITPUB
Jun 24, 2022 · Databases

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

This article walks through the complete process of creating a highly available MySQL master‑master cluster using Docker containers, MySQL replication, and Keepalived for automatic health checks, virtual IP failover, and seamless traffic switching, while also sharing common pitfalls and their solutions.

Database operationsDockerLinux
0 likes · 24 min read
How to Build MySQL Master‑Master HA with Keepalived: A Step‑by‑Step Guide
Sanyou's Java Diary
Sanyou's Java Diary
Jun 15, 2022 · Databases

How to Build MySQL Master‑Master HA with Keepalived and Docker

This tutorial walks through setting up a highly available MySQL master‑master cluster using Docker containers, configuring MySQL replication, and employing Keepalived for automatic failover and virtual IP management, complete with step‑by‑step commands, configuration files, and troubleshooting tips.

DockerLinuxMaster-Master Replication
0 likes · 23 min read
How to Build MySQL Master‑Master HA with Keepalived and Docker
21CTO
21CTO
May 1, 2016 · Databases

How to Build MySQL Master‑Master HA with LVS and Keepalived

This guide explains how to achieve high‑availability MySQL master‑master replication by combining LVS load balancing with Keepalived failover, covering installation, configuration, script creation, service management, testing, and a concise summary of the solution.

LVSMaster-Master Replicationkeepalived
0 likes · 14 min read
How to Build MySQL Master‑Master HA with LVS and Keepalived