Group Replication

Aikesheng Open Source Community

Oct 10, 2022 · Databases

Investigation of MySQL Group Replication Failover Triggered by System Time Anomaly and VM Suspension

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.

Database OperationsFailoverGroup Replication

0 likes · 40 min read

Investigation of MySQL Group Replication Failover Triggered by System Time Anomaly and VM Suspension

Aikesheng Open Source Community

May 24, 2022 · Databases

Read SQL Routed to Master Despite rwSplitMode=3 Configuration

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.

DBLEDatabase MiddlewareGroup Replication

0 likes · 7 min read

Read SQL Routed to Master Despite rwSplitMode=3 Configuration

Aikesheng Open Source Community

Dec 22, 2021 · Databases

Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover

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

Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover

Laiye Technology Team

Oct 30, 2021 · Databases

Introduction to MySQL Group Replication (MGR) and Its Application in Private Deployments

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

Introduction to MySQL Group Replication (MGR) and Its Application in Private Deployments

Aikesheng Open Source Community

Oct 19, 2021 · Databases

Step-by-Step Guide to Upgrading MySQL Group Replication (MGR) from 5.7 to 8.0.26

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.

Group ReplicationInnoDB ClusterMySQL

0 likes · 7 min read

Step-by-Step Guide to Upgrading MySQL Group Replication (MGR) from 5.7 to 8.0.26

vivo Internet Technology

Aug 25, 2021 · Databases

Introduction to MySQL Group Replication (MGR): Features, Evolution, Deployment and Testing

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

Introduction to MySQL Group Replication (MGR): Features, Evolution, Deployment and Testing

Aikesheng Open Source Community

Aug 24, 2021 · Databases

Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery

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

Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery

Aikesheng Open Source Community

Jul 23, 2021 · Databases

Implementing Conversion Between MySQL Group Replication (MGR) and Semi‑Synchronous Replication

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

Implementing Conversion Between MySQL Group Replication (MGR) and Semi‑Synchronous Replication

Practical DevOps Architecture

Nov 28, 2020 · Databases

Features, Fault Detection, Limitations, and Deployment Scripts for MySQL Group Replication (MGR)

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

Features, Fault Detection, Limitations, and Deployment Scripts for MySQL Group Replication (MGR)

Aikesheng Open Source Community

Oct 16, 2020 · Databases

Impact of High Network Latency on MySQL Group Replication Performance

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.

Distributed SystemsGroup ReplicationMySQL

0 likes · 4 min read

Impact of High Network Latency on MySQL Group Replication Performance

Aikesheng Open Source Community

Oct 13, 2020 · Databases

Testing the Impact of group_replication_member_expel_timeout on MySQL Group Replication under Network Latency

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

Testing the Impact of group_replication_member_expel_timeout on MySQL Group Replication under Network Latency

Aikesheng Open Source Community

Sep 24, 2020 · Databases

MySQL High Availability vs Oracle High Availability: Can MySQL Replace Oracle in the Financial Industry?

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

MySQL High Availability vs Oracle High Availability: Can MySQL Replace Oracle in the Financial Industry?

Aikesheng Open Source Community

Sep 3, 2020 · Databases

Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”

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

Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”

Aikesheng Open Source Community

Aug 21, 2020 · Databases

MySQL 8.0.20 Group Replication Overview and Practical Guide

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

MySQL 8.0.20 Group Replication Overview and Practical Guide

Aikesheng Open Source Community

Aug 21, 2020 · Databases

Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects

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.

Group ReplicationHigh AvailabilityMessage Cache

0 likes · 5 min read

Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects

Aikesheng Open Source Community

Jul 20, 2020 · Databases

InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management

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.

Database AdministrationGroup ReplicationInnoDB Cluster

0 likes · 10 min read

InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management

Aikesheng Open Source Community

Jul 3, 2020 · Databases

Analyzing MySQL Group Replication Node Failure Handling with Wireshark

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

Analyzing MySQL Group Replication Node Failure Handling with Wireshark

Efficient Ops

Jun 15, 2020 · Databases

Understanding MySQL Group Replication: Evolution, Transaction Lifecycle, and Conflict Detection

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.

Conflict DetectionGroup ReplicationMySQL

0 likes · 12 min read

Understanding MySQL Group Replication: Evolution, Transaction Lifecycle, and Conflict Detection

Aikesheng Open Source Community

May 18, 2020 · Databases

Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)

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.

Group ReplicationMySQLReplication

0 likes · 13 min read

Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)

Aikesheng Open Source Community

Oct 29, 2019 · Databases

Automatic Member Fencing with OFFLINE_MODE in MySQL Group Replication

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.

Database AdministrationGroup ReplicationHigh Availability

0 likes · 5 min read

Automatic Member Fencing with OFFLINE_MODE in MySQL Group Replication