Tagged articles
MGR
16 articles · Page 1 of 1

liandkSep 15, 2026 · Databases
This article explains MySQL Group Replication (MGR), a native high-availability cluster based on Paxos consensus, covering its architecture, single-primary vs multi-primary modes, automatic failover, brain-split prevention via majority voting, production deployment rules, and common pitfalls to avoid for zero-data-loss transactional systems.
Brain SplitDatabase ClusteringGroup Replication
0 likes · 12 min read

This article presents a detailed design, implementation, and automated testing script that evaluates whether MySQL Group Replication can support dual‑data‑center active‑active deployments, covering deployment steps, replication modes, fault simulation, data consistency checks, and key conclusions.
Active-ActiveDatabase High AvailabilityGroup Replication
0 likes · 16 min read


ITPUBSep 8, 2024 · Databases
MySQL 8.4 becomes the new LTS release, offering detailed upgrade‑downgrade compatibility tables, dozens of InnoDB and temporary‑table parameter defaults, MGR and replication enhancements, new commands, and a list of deprecated features to help DBAs plan migrations efficiently.
8.4InnoDBMGR
0 likes · 11 min read

This article provides a comprehensive, step‑by‑step guide for performing an in‑place upgrade of MySQL 8.0 (including MGR clusters) from earlier versions, covering pre‑upgrade checks, backup procedures, configuration changes, data dictionary upgrade, server upgrade, verification, rollback, and common pitfalls.
MGRMySQLReplication
0 likes · 15 min read

The article walks through a MySQL MGR failover incident, analyzes the InnoDB assertion failure shown in the error log, pinpoints the problematic code at row0pread.cc line 727, compares the fix in MySQL 8.0.28, and references the related bug report for future troubleshooting.
DebuggingInnoDBMGR
0 likes · 7 min read

The article analyzes a MySQL MGR cluster failover incident caused by a VM pause and system time jump, explains the underlying detection mechanisms, presents detailed source code excerpts, and demonstrates through debugging that time changes alone do not trigger MGR failover.
FailoverGroup ReplicationMGR
0 likes · 40 min read

This article examines why single-node databases no longer meet modern internet workloads, explores MySQL replication models (master‑slave, asynchronous, semi‑synchronous, group replication), discusses high‑availability solutions such as MHA, MGR and Orchestrator, and outlines vertical and horizontal sharding techniques along with their trade‑offs.
Database ArchitectureHigh AvailabilityMGR
0 likes · 13 min read

This article explains MySQL high‑availability concepts, defines HA, RPO and RTO, outlines common HA architectures such as master‑slave+VIP, MHA and MGR+Proxy, and details AutoHome's evolution from simple master‑slave setups to a container‑based MGR solution with automated failover and monitoring platforms.
High AvailabilityKubernetesMGR
0 likes · 11 min read

This article explains the role of distributed architecture for high‑performance internet systems, introduces GreatSQL as a native distributed relational database, compares it with MySQL, and provides step‑by‑step Docker‑Compose instructions to set up, start, and verify a three‑node MGR cluster, plus integration with the PIG microservice platform.
Distributed DatabaseDocker ComposeGreatSQL
0 likes · 8 min read

This article outlines MySQL Group Replication’s key features, fault-detection mechanism, limitations, required environment, and step-by-step deployment scripts, providing a practical guide for setting up a high-availability MySQL cluster on CentOS using the provided shell scripts and configuration files.
Group ReplicationHigh AvailabilityMGR
0 likes · 6 min read

This article explains how MySQL Group Replication (MGR) can provide zero‑RPO high‑availability within a city‑scale data center, why it needs asynchronous replication for WAN‑scale disaster recovery, and walks through a step‑by‑step setup—including code examples—for automatic failover of asynchronous replication channels.
Database High AvailabilityFailoverMGR
0 likes · 6 min read

This article documents an experiment using three virtual machines running MySQL 5.7.20 MGR to capture and analyze network traffic with a custom Wireshark dissector, revealing how the primary node updates views, removes a failed node, and re‑establishes cluster state after a crash.
Database ClusteringGroup ReplicationMGR
0 likes · 4 min read


ITPUBApr 27, 2020 · Databases
A production MySQL 8.0.15 MGR cluster suffered from massive internal temporary‑table file leaks due to a known bug, which was diagnosed through log analysis and Oracle documentation and resolved by upgrading to MySQL 8.0.16, confirming the issue is version‑specific and not MGR‑related.
MGRMySQLUpgrade
0 likes · 11 min read

This article details Meituan Dianping's practical experience deploying MySQL Group Replication (MGR) for CMDB high availability, covering background, MGR fundamentals, configuration limits, parameter tuning, architecture design, deployment timeline, typical issues, a custom Python client, and daily operational practices.
Group ReplicationHigh AvailabilityMGR
0 likes · 11 min read

This tutorial explains the principles of MySQL Group Replication, compares single‑primary and multi‑primary modes, lists its key features and limitations, and provides a complete, code‑rich walkthrough for setting up a three‑node MGR cluster on MySQL 5.7.17.
Database ClusterGroup ReplicationHigh Availability
0 likes · 10 min read

This article introduces two open‑source script collections—dbm_lite for Oracle database administration and mysql_mgr_test for rapid MySQL Group Replication deployment—detailing their features, supported platforms, usage instructions, and how to obtain them from GitHub.
MGRShell Scriptsdatabases
0 likes · 9 min read
