BestHub
Sign in
Tagged articles
12 articles
Page 1 of 1
Raymond Ops
Raymond Ops
Oct 27, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera

This article examines three MySQL high‑availability solutions—MHA, Percona XtraDB Cluster, and Galera Cluster—detailing their architectures, advantages, limitations, deployment scenarios, and best‑practice recommendations to help engineers choose the most suitable approach for continuous, reliable database operations.

Cluster DeploymentDatabase ReplicationGalera
0 likes · 11 min read
Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera
Liangxu Linux
Liangxu Linux
Jun 5, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera

An in‑depth comparison of three popular MySQL high‑availability architectures—MHA, Percona XtraDB Cluster (PXC), and Galera Cluster—covers their principles, architectures, strengths, limitations, deployment scenarios, and best‑practice recommendations to help you select the optimal solution for your production environment.

Database ReplicationGaleraMHA
0 likes · 10 min read
Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera
MaGe Linux Operations
MaGe Linux Operations
May 25, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, PXC or Galera Cluster

An in‑depth guide compares three MySQL high‑availability solutions—MHA, Percona XtraDB Cluster, and Galera Cluster—detailing their architectures, pros and cons, deployment scenarios, and best‑practice recommendations to help engineers choose the optimal HA strategy for their workloads.

GaleraMHAPercona XtraDB Cluster
0 likes · 10 min read
Choosing the Right MySQL HA Solution: MHA, PXC or Galera Cluster
Qunar Tech Salon
Qunar Tech Salon
Oct 28, 2021 · Databases

Analysis of a Percona XtraDB Cluster (PXC) Flow‑Control Incident Triggered by Disk I/O and Large TEXT Fields

This article examines a real‑world Percona XtraDB Cluster (PXC) fault where simultaneous write‑node connection spikes were caused by flow‑control triggered by 100% disk I/O on a shared read node, ultimately traced to slow sorting queries involving a mediumtext column, and offers diagnostic steps and mitigation strategies.

Flow ControlGaleraPXC
0 likes · 11 min read
Analysis of a Percona XtraDB Cluster (PXC) Flow‑Control Incident Triggered by Disk I/O and Large TEXT Fields
Qunar Tech Salon
Qunar Tech Salon
Nov 24, 2020 · Databases

Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar

This article examines how differences between Galera GTID and MySQL GTID caused replication interruptions during a Percona XtraDB Cluster (PXC) split at Qunar, details the migration procedure, reproduces the problem with step‑by‑step commands, explains GTID concepts, and proposes operational improvements to avoid data inconsistency.

Database operationsGTIDGalera
0 likes · 17 min read
Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar
dbaplus Community
dbaplus Community
Oct 14, 2019 · Databases

Mastering Percona XtraDB Cluster: High Availability, Monitoring, and Backup Strategies

This comprehensive guide explains Galera‑based Percona XtraDB Cluster architecture, high‑availability mechanisms, state‑transfer methods, flow‑control, deployment patterns, routine inspection, monitoring variables, backup management, common failure scenarios, and real‑world case studies for MySQL clusters.

BackupGaleraPercona XtraDB Cluster
0 likes · 36 min read
Mastering Percona XtraDB Cluster: High Availability, Monitoring, and Backup Strategies
dbaplus Community
dbaplus Community
Feb 15, 2017 · Databases

How to Diagnose and Fix a Galera Cluster Node Failure in Percona XtraDB

This article walks through a real‑world Galera cluster outage, explains the replication and flow‑control mechanisms, details the step‑by‑step analysis of thread‑running spikes and wsrep delays, identifies a network‑induced port latency as the root cause, and describes the recovery actions taken to restore the Percona XtraDB Cluster.

Flow ControlGaleraNetwork Latency
0 likes · 9 min read
How to Diagnose and Fix a Galera Cluster Node Failure in Percona XtraDB
Architect
Architect
Sep 14, 2015 · Databases

MySQL High Availability Solutions: Selection Guide

This article reviews various MySQL high‑availability architectures—including master‑slave replication with keepalived or MHA, Galera‑based clusters, and other approaches—detailing their deployment methods, advantages, limitations, and practical considerations for selecting an appropriate HA solution.

GaleraMHAReplication
0 likes · 9 min read
MySQL High Availability Solutions: Selection Guide