Tagged articles
Group Replication
46 articles · Page 1 of 1
MySQL 9.7 LTS introduces writable JSON Duality Views and the Hypergraph optimizer in the community edition, enhances replication observability and high‑availability automation, adds audit log rotation and stronger password hashing, but warns that the new optimizer requires regression testing due to mixed performance impact.
Group ReplicationHypergraph optimizerJSON Duality Views
0 likes · 6 min read


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

The article dissects a high‑traffic flash‑sale interview question—how to guarantee zero order loss at 100,000 TPS when the master MySQL instance fails—by explaining the underlying performance‑consistency conflict, the three skills interviewers assess, and presenting five concrete, code‑driven solutions ranging from MySQL parameter tuning to semi‑sync replication, local message tables, group replication, and Redis‑Kafka traffic shaping.
Data ConsistencyGroup ReplicationKafka
0 likes · 28 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


21CTOApr 24, 2025 · Databases
MySQL 9.3 introduces powerful backup enhancements, JavaScript stored‑procedure support, advanced query optimization, and a new Group Replication primary‑election feature, all aimed at improving reliability, performance, and developer flexibility, making it a compelling upgrade for enterprises and developers alike.
Group ReplicationJavaScript stored proceduresMySQL
0 likes · 3 min read

MySQL Innovation Edition 9.1.0, released on October 15 2024, introduces atomic DDL operations, enhanced audit and firewall handling, numerous compiler and SQL function fixes, JavaScript stored‑procedure improvements, new vector support, updated keyring security, pluggable authentication fixes, expanded GROUP REPLICATION logging, and several EXPLAIN and performance‑schema enhancements.
Group ReplicationJavaScript stored proceduresMySQL
0 likes · 10 min read


ITPUBOct 8, 2023 · Databases
Starting with MySQL 8.0.30, the Generated Invisible Primary Keys (GIPKs) feature automatically adds an invisible bigint auto‑increment column named my_row_id when a table lacks an explicit primary key, simplifying schema design, easing DBA‑developer conflicts, and offering flexible handling in MGR and replication environments, while noting its limitations and usage commands.
GIPKsGenerated Invisible Primary KeysGroup Replication
0 likes · 8 min read

This article walks through a practical MySQL Group Replication case study, demonstrating how failure detection works, how network partitions affect node states, the role of XCom Cache, and the impact of configuration parameters on cluster availability and performance.
Failure DetectionGroup ReplicationMySQL
0 likes · 21 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

The article investigates why read queries are sent to the master node when Dble is configured with rwSplitMode=3, analyzes reproductions on standard replication and MySQL Group Replication, identifies heartbeat and replication status issues, and provides troubleshooting steps and recommendations.
Database MiddlewareGroup ReplicationMySQL
0 likes · 7 min read

This guide demonstrates how to deploy a ProxySQL instance alongside six MySQL servers (three for traditional replication and three for MySQL Group Replication), configure users, set up read/write splitting rules, and enable automatic failover for both replication topologies.
Database HAFailoverGroup Replication
0 likes · 14 min read

This article explains the fundamentals, architecture, deployment patterns, recovery procedures, performance tuning, and common troubleshooting of MySQL Group Replication (MGR) as a high‑availability solution for private deployments, illustrated with real‑world examples and practical SQL commands.
Group ReplicationHigh AvailabilityMySQL
0 likes · 16 min read

This article provides a detailed, online, in‑place upgrade procedure for MySQL InnoDB Cluster (MGR) from version 5.7.25 single‑primary mode to version 8.0.26, covering preparation, backup, node‑by‑node upgrade, configuration changes, and communication‑protocol updates.
Database MigrationGroup ReplicationInnoDB Cluster
0 likes · 7 min read

This guide walks through exporting business databases, re‑initializing the MySQL instance, importing data, extracting GTID information, creating replication and monitoring accounts with helper functions, resetting logs, and finally re‑joining the node to a MySQL Group Replication cluster.
GTIDGroup ReplicationMySQL
0 likes · 8 min read

MySQL Group Replication, introduced in 2016, delivers high‑availability, strong consistency, fault‑tolerant and scalable MySQL clusters through a Paxos‑based, plugin‑driven architecture that supports both single‑primary and multi‑primary modes, with detailed installation, configuration, deployment and testing guidance, while noting its limited current adoption due to ecosystem maturity.
ClusterDatabase High AvailabilityGroup Replication
0 likes · 15 min read

An in‑depth analysis of MySQL Group Replication (MGR) transaction certification failures, covering error symptoms, root‑cause investigation, replication‑group transaction set mismatches, and step‑by‑step recovery procedures with code examples and best‑practice recommendations to keep MGR clusters clean.
Group ReplicationMySQLTransaction Certification
0 likes · 19 min read


ITPUBAug 19, 2021 · Databases
This article explains why a single MySQL instance becomes insufficient as data volume and concurrency grow, and walks through master‑slave replication, asynchronous and semi‑synchronous modes, group replication, and various high‑availability solutions such as MHA, MySQL InnoDB Cluster, and Orchestrator, while also covering read/write splitting techniques and practical implementation tips.
Group ReplicationMaster‑SlaveMySQL
0 likes · 20 min read

This guide demonstrates how to switch a MySQL 5.7.32 deployment between Group Replication (MGR) and semi‑synchronous replication, covering environment checks, node configuration, plugin installation, replication setup, validation, and the limitations encountered when combining the two modes.
ConfigurationGroup ReplicationHigh Availability
0 likes · 9 min read

This article explains why growing MySQL workloads require moving from a single instance to a clustered architecture, details the mechanics of master‑slave replication, asynchronous, semi‑synchronous and group replication, and evaluates various high‑availability solutions and read‑write splitting techniques.
Group ReplicationHigh AvailabilityMHA
0 likes · 18 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

An experiment with a three‑node MySQL Group Replication (MGR) cluster shows that even when flow control is disabled, adding significant network latency to a single node reduces overall throughput, because MGR’s multi‑paxos protocol makes the delayed node a performance bottleneck during its turn as leader.
Group ReplicationMulti-PaxosMySQL
0 likes · 4 min read

This article investigates how the MySQL 8.0 group_replication_member_expel_timeout parameter influences node expulsion in a group replication cluster when network latency is introduced, describing the test environment, methodology, commands, observations, and configuration recommendations.
Database ClusterGroup ReplicationMySQL
0 likes · 7 min read

The livestream discusses MySQL's high‑availability architectures compared with Oracle's, analyzes share‑nothing versus share‑everything designs, logical versus physical logging, and concludes that MySQL's share‑nothing and logical binlog replication are better suited for modern financial‑industry workloads, while also covering audience Q&A and upcoming topics.
Database ArchitectureFinancial IndustryGroup Replication
0 likes · 10 min read

The first episode of the “MySQL Chōng Chōng Chōng” livestream discusses why now is an excellent time to upgrade to MySQL 8.0, covering fast add‑column, Atomic DDL, Hash Join, Group Replication, authentication changes, and includes thanks to sponsors and a preview of the next show.
Atomic DDLDatabase UpgradeFast Add Column
0 likes · 9 min read

This article introduces MySQL 8.0.20 Group Replication, covering single‑master and multi‑master modes, monitoring, failover procedures, abnormal recovery, flow control, performance testing, encountered issues, and limitations, and provides a downloadable PDF with detailed documentation hosted on Baidu Cloud.
Baidu CloudFailoverGroup Replication
0 likes · 1 min read

This article examines how MySQL Group Replication's message cache fills under load, the impact of the group_replication_message_cache_size and group_replication_member_expel_timeout parameters, and provides experimental observations and practical recommendations for balancing reliability, memory usage, and data consistency.
Database PerformanceGroup ReplicationHigh Availability
0 likes · 5 min read

This tutorial walks through the test environment and demonstrates how InnoDB Cluster's built‑in functions—such as get_cluster, describe, list_routers, set_option, options, set_instance_option, set_primary_instance, switch_to_multi_primary_mode, switch_to_single_primary_mode, status, and dissolve—simplify the deployment, monitoring, and administration of MySQL group replication, complete with code snippets and visual results.
Group ReplicationInnoDB ClusterMySQL
0 likes · 10 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

This article explains MySQL Group Replication (MGR), covering its evolution from traditional replication, the full transaction lifecycle within an MGR cluster, and the detailed conflict‑detection mechanism that ensures data consistency and automatic failover.
Database ReplicationGroup ReplicationMySQL
0 likes · 12 min read

This article explains the MySQL group_replication_consistency parameter, describes its five possible values, demonstrates the three most common consistency modes (EVENTUAL, BEFORE, AFTER) with practical multi‑node examples, and discusses their advantages, drawbacks, and impact on query latency and data integrity.
ConsistencyGroup ReplicationMySQL
0 likes · 13 min read

The article explains how MySQL Group Replication handles unintended member exits, introduces the OFFLINE_MODE option added in 8.0.18, and shows how DBAs can configure and query the system to maintain high availability during failures.
Group ReplicationHigh AvailabilityMySQL
0 likes · 5 min read

This article reviews MySQL replication concepts, compares asynchronous, semi‑synchronous, group, and Percona XtraDB Cluster solutions, explains row‑based versus statement‑based replication, and clears up common misconceptions about replication, clustering, backup, and load balancing.
Group ReplicationMySQLPercona
0 likes · 9 min read

Starting with MySQL 8.0.17, Group Replication introduces patch‑level version compatibility policies that govern primary‑member election, write‑ability, donor selection, and upgrade procedures for mixed‑version clusters, ensuring safe operation during rolling upgrades and multi‑primary mode transitions.
Group ReplicationHigh AvailabilityMySQL
0 likes · 12 min read

Starting with MySQL 8.0.16, Group Replication introduces an automatic member rejoin feature that allows expelled or disconnected nodes to attempt reconnection without manual intervention, configurable via the group_replication_autorejoin_tries variable, with monitoring via Performance Schema and trade‑offs compared to expel timeout.
Auto RejoinGroup ReplicationHigh Availability
0 likes · 11 min read

The article explains MySQL Group Replication 8.0.16's new segmented communication protocol, version‑compatibility rules for adding members, and introduces two UDFs that allow administrators to set and query the protocol version to maintain high‑availability across mixed‑version clusters.
Communication ProtocolDatabase VersioningGroup Replication
0 likes · 6 min read

MySQL 8.0.16 adds a message‑fragmentation feature to Group Replication that splits oversized broadcast messages into smaller chunks, allowing administrators to set a maximum message size and preventing false member expulsions caused by large payloads.
Database High AvailabilityGroup ReplicationMessage Fragmentation
0 likes · 5 min read

MySQL 8.0.14 introduces a read/write consistency feature for Group Replication, explaining why MGR can still be inconsistent, detailing the group_replication_consistency parameter with its five levels, their advantages, disadvantages, and appropriate application scenarios, plus example session settings.
Group ReplicationMySQLRead Write Consistency
0 likes · 7 min read

This article examines a real‑world MySQL Group Replication failure where network jitter caused a primary INSERT not to replicate, leading to GTID divergence, a secondary node leaving the cluster, and explains the underlying Paxos‑based proposal conflict with detailed code examples.
Database HAGTIDGroup Replication
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

A practical benchmark on three identical servers shows MySQL Group Replication achieving higher TPS than Semi‑Sync despite larger network traffic, and explains how Paxos‑based parallel log transmission gives it an edge over the single‑threaded Semi‑Sync approach.
Database ReplicationGroup ReplicationMySQL
0 likes · 6 min read

This article presents a comprehensive overview of MySQL high‑availability solutions, covering classic HA architectures, synchronization tools such as MHA, MMM, HA‑JDBC, Galera and Group Replication, and shares NetEase's practical implementations using distributed databases and keepalive‑based failover.
Distributed DatabaseGaleraGroup Replication
0 likes · 16 min read

This article introduces MySQL's newly released InnoDB Cluster GA version, outlines its three core components—Group Replication‑enabled servers, MySQL Shell with AdminAPI, and MySQL Router—and explains how they together provide fault‑tolerant, automatically failover‑capable, and scalable high‑availability database solutions.
Group ReplicationInnoDB ClusterMySQL
0 likes · 3 min read

This article provides a comprehensive, step-by-step tutorial for downloading, installing, and configuring three MySQL 5.7.17 instances on a single server, creating users, setting up Group Replication, adding members, and verifying data synchronization across the replication group.
Group ReplicationLinuxMySQL
0 likes · 12 min read

MySQL 5.7.17 introduced Group Replication, a feature that ensures full data consistency across multiple MySQL nodes by synchronizing changes, offering high consistency, fault tolerance, elasticity, and flexible single‑master or multi‑master modes, making it suitable for elastic replication, high‑availability sharding, and as a replacement for traditional master‑slave replication.
Group ReplicationMySQLdatabase consistency
0 likes · 4 min read

This article explains MySQL's asynchronous, semi‑synchronous, and Group Replication mechanisms, compares their trade‑offs, details Group Replication’s certification‑based full‑sync workflow, lists its features and limitations, and provides a complete configuration and maintenance guide for a three‑node cluster.
ClusterConfigurationGroup Replication
0 likes · 13 min read
