BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
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
ITPUB
ITPUB
Sep 8, 2024 · Databases

What’s New in MySQL 8.4? Key Changes, Compatibility, and Upgrade Guide

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
What’s New in MySQL 8.4? Key Changes, Compatibility, and Upgrade Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 30, 2023 · Databases

Step‑by‑Step In‑Place Upgrade Guide for MySQL 8.0 (MGR Cluster)

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.

Database AdministrationMGRReplication
0 likes · 15 min read
Step‑by‑Step In‑Place Upgrade Guide for MySQL 8.0 (MGR Cluster)
IT Architects Alliance
IT Architects Alliance
Sep 4, 2022 · Databases

Mastering MySQL: From Replication to High Availability and Sharding Strategies

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 ArchitectureMGRMHA
0 likes · 13 min read
Mastering MySQL: From Replication to High Availability and Sharding Strategies
HomeTech
HomeTech
Apr 6, 2022 · Databases

MySQL High Availability Architecture and Practices at AutoHome

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.

KubernetesMGRMHA
0 likes · 11 min read
MySQL High Availability Architecture and Practices at AutoHome
Java Architecture Diary
Java Architecture Diary
Aug 30, 2021 · Databases

How to Build a High‑Availability GreatSQL MGR Cluster with Docker‑Compose

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.

Docker ComposeGreatSQLMGR
0 likes · 8 min read
How to Build a High‑Availability GreatSQL MGR Cluster with Docker‑Compose
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 30, 2020 · Databases

Configuring MySQL MGR with Asynchronous Replication Automatic Failover for Multi‑Site Disaster Recovery

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.

Asynchronous ReplicationMGRdatabase high availability
0 likes · 6 min read
Configuring MySQL MGR with Asynchronous Replication Automatic Failover for Multi‑Site Disaster Recovery
ITPUB
ITPUB
Apr 27, 2020 · Databases

Why MySQL 8.0.15 Leaks Internal Temp Files and How Upgrading to 8.0.16 Fixes It

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.

MGRbuginternal temporary tables
0 likes · 11 min read
Why MySQL 8.0.15 Leaks Internal Temp Files and How Upgrading to 8.0.16 Fixes It
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
dbaplus Community
dbaplus Community
Sep 19, 2017 · Databases

Unlock Faster DB Maintenance with dbm_lite and mysql_mgr_test Scripts

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
Unlock Faster DB Maintenance with dbm_lite and mysql_mgr_test Scripts