BestHub
Sign in
Tagged articles
44 articles
Page 1 of 1
Tech Freedom Circle
Tech Freedom Circle
Nov 15, 2025 · Databases

How to Prevent Order Loss in a 100k TPS Flash Sale When the Master DB Crashes – 5 Practical Solutions

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
How to Prevent Order Loss in a 100k TPS Flash Sale When the Master DB Crashes – 5 Practical Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
May 19, 2025 · Databases

Can MySQL Group Replication Power Dual‑Active Data Centers? A Practical Test Script

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-ActiveAutomationGroup Replication
0 likes · 16 min read
Can MySQL Group Replication Power Dual‑Active Data Centers? A Practical Test Script
21CTO
21CTO
Apr 24, 2025 · Databases

What’s New in MySQL 9.3? Backup, JavaScript Support, and Group Replication Explained

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.

Database BackupGroup ReplicationJavaScript Stored Procedures
0 likes · 3 min read
What’s New in MySQL 9.3? Backup, JavaScript Support, and Group Replication Explained
dbaplus Community
dbaplus Community
Oct 17, 2024 · Databases

What’s New in MySQL 9.1.0? A Deep Dive into Latest Features and Fixes

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.

Database FeaturesGroup ReplicationJavaScript Stored Procedures
0 likes · 10 min read
What’s New in MySQL 9.1.0? A Deep Dive into Latest Features and Fixes
ITPUB
ITPUB
Oct 8, 2023 · Databases

Unlocking MySQL GIPKs: How Generated Invisible Primary Keys Simplify Schema Design

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.

Database designGIPKsGenerated Invisible Primary Keys
0 likes · 8 min read
Unlocking MySQL GIPKs: How Generated Invisible Primary Keys Simplify Schema Design
Aikesheng Open Source Community
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.

Database MiddlewareGroup Replicationmysql
0 likes · 7 min read
Read SQL Routed to Master Despite rwSplitMode=3 Configuration
Aikesheng Open Source Community
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 HAGroup ReplicationMySQL replication
0 likes · 14 min read
Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover
ZhiKe AI
ZhiKe AI
Sep 24, 2021 · Databases

How to Manually Re‑Add a Detached MySQL MGR Cluster Node

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.

Database RecoveryGTIDGroup Replication
0 likes · 8 min read
How to Manually Re‑Add a Detached MySQL MGR Cluster Node
vivo Internet Technology
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.

ClusterGroup ReplicationReplication
0 likes · 15 min read
Introduction to MySQL Group Replication (MGR): Features, Evolution, Deployment and Testing
Aikesheng Open Source Community
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 ReplicationTransaction Certificationdatabase
0 likes · 19 min read
Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery
ITPUB
ITPUB
Aug 19, 2021 · Databases

How to Turn a Single MySQL Server into a High‑Availability Cluster

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‑SlaveReplication
0 likes · 20 min read
How to Turn a Single MySQL Server into a High‑Availability Cluster
Aikesheng Open Source Community
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 ReplicationSemi‑synchronous Replication
0 likes · 9 min read
Implementing Conversion Between MySQL Group Replication (MGR) and Semi‑Synchronous Replication
JavaEdge
JavaEdge
Mar 21, 2021 · Databases

From Single MySQL to Cluster: Master‑Slave Replication, High Availability, and Scaling Strategies

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 ReplicationMHAOrchestrator
0 likes · 18 min read
From Single MySQL to Cluster: Master‑Slave Replication, High Availability, and Scaling Strategies
Practical DevOps Architecture
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 ReplicationMGRReplication
0 likes · 6 min read
Features, Fault Detection, Limitations, and Deployment Scripts for MySQL Group Replication (MGR)
Aikesheng Open Source Community
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 ReplicationMulti-Paxos
0 likes · 4 min read
Impact of High Network Latency on MySQL Group Replication Performance
Aikesheng Open Source Community
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 ReplicationNetwork Latency
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
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
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
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 CloudGroup ReplicationPerformance Testing
0 likes · 1 min read
MySQL 8.0.20 Group Replication Overview and Practical Guide
Aikesheng Open Source Community
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.

Database PerformanceGroup ReplicationMessage Cache
0 likes · 5 min read
Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects
Aikesheng Open Source Community
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.

Group ReplicationInnoDB ClusterPython
0 likes · 10 min read
InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management
Aikesheng Open Source Community
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.

ConsistencyGroup ReplicationReplication
0 likes · 13 min read
Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 6, 2019 · Databases

MySQL Group Replication Version Compatibility Policies and Upgrade Guidelines

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 ReplicationVersion Compatibilitydatabase
0 likes · 12 min read
MySQL Group Replication Version Compatibility Policies and Upgrade Guidelines
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 14, 2019 · Databases

Automatic Member Rejoin in MySQL Group Replication (MGR): Features, Configuration, and Monitoring

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 ReplicationPerformance Schema
0 likes · 11 min read
Automatic Member Rejoin in MySQL Group Replication (MGR): Features, Configuration, and Monitoring
Aikesheng Open Source Community
Aikesheng Open Source Community
May 22, 2019 · Databases

Understanding MySQL Group Replication Communication Protocol and New UDF Functions in 8.0.16

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
Understanding MySQL Group Replication Communication Protocol and New UDF Functions in 8.0.16
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 10, 2019 · Databases

MySQL 8.0.14 Group Replication Read/Write Consistency: Parameters, Levels, and Use Cases

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.

Consistency LevelsGroup ReplicationRead Write Consistency
0 likes · 7 min read
MySQL 8.0.14 Group Replication Read/Write Consistency: Parameters, Levels, and Use Cases
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2019 · Databases

Analysis of MySQL Group Replication Data Inconsistency Caused by GTID Mismatch and Paxos Proposal Conflict

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
Analysis of MySQL Group Replication Data Inconsistency Caused by GTID Mismatch and Paxos Proposal Conflict
dbaplus Community
dbaplus Community
Sep 16, 2018 · Databases

How Meituan Dianping Built a Reliable MySQL Group Replication HA Architecture

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.

Database operationsGroup ReplicationMGR
0 likes · 11 min read
How Meituan Dianping Built a Reliable MySQL Group Replication HA Architecture
Java High-Performance Architecture
Java High-Performance Architecture
Apr 15, 2017 · Databases

Unlocking MySQL InnoDB Cluster: Full-Stack High Availability Explained

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
Unlocking MySQL InnoDB Cluster: Full-Stack High Availability Explained
Java High-Performance Architecture
Java High-Performance Architecture
Mar 1, 2017 · Databases

Understanding MySQL Group Replication: Features, Differences, and Use Cases

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 Replicationdatabase-consistencymysql
0 likes · 4 min read
Understanding MySQL Group Replication: Features, Differences, and Use Cases
dbaplus Community
dbaplus Community
Jan 12, 2017 · Databases

Mastering MySQL Group Replication: Full‑Sync Architecture, Benefits, and Step‑by‑Step Setup

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
Mastering MySQL Group Replication: Full‑Sync Architecture, Benefits, and Step‑by‑Step Setup