BestHub
Sign in
Tagged articles
13 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
MaGe Linux Operations
MaGe Linux Operations
Nov 23, 2023 · Databases

Deploy Percona XtraDB Cluster (PXC) on Docker Swarm with Load Balancing

This guide walks through setting up a Percona XtraDB Cluster (PXC) version 5.7.43 on three Docker‑installed machines, configuring hostnames, loading images, creating a Swarm overlay network, deploying the cluster, adjusting MySQL settings, handling common failures, and adding load balancing with Nginx or HAProxy.

Docker SwarmHAProxyNginx
0 likes · 10 min read
Deploy Percona XtraDB Cluster (PXC) on Docker Swarm with Load Balancing
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
Oct 11, 2021 · Databases

Resolving Data Inconsistency in Percona XtraDB Cluster Caused by MyISAM Tables and Applying pt-online-schema-change

This article documents a real‑world incident where a MyISAM table in a Percona XtraDB Cluster caused data inconsistency and node self‑shutdown, analyzes the root cause, and describes how using pt-online-schema-change together with proper engine conversion restored consistency across the cluster.

Database operationsInnoDBMyISAM
0 likes · 14 min read
Resolving Data Inconsistency in Percona XtraDB Cluster Caused by MyISAM Tables and Applying pt-online-schema-change
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
Sep 18, 2018 · Databases

How to Split a Percona XtraDB Cluster into Multiple Instances on a Single Node

This article details a real‑world engineering case where a Percona XtraDB Cluster (PXC) was re‑architected to run separate OP and CLM MySQL instances on the same physical server, covering background, problem analysis, design choices, port configuration, directory restructuring, configuration files, step‑by‑step commands, automation script updates, and post‑change verification.

Database operationsHAProxyInstance Splitting
0 likes · 14 min read
How to Split a Percona XtraDB Cluster into Multiple Instances on a Single Node
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
ITPUB
ITPUB
Aug 2, 2016 · Databases

How to Build a Highly Available MySQL Cluster with HAProxy and Keepalived on OpenStack

This guide walks through configuring a Percona XtraDB Cluster on three OpenStack nodes, disabling SELinux and firewalls, installing and tuning MySQL, setting up HAProxy for load balancing, deploying Keepalived for failover, and verifying high‑availability with practical test steps.

HAProxyOpenStackPercona XtraDB Cluster
0 likes · 13 min read
How to Build a Highly Available MySQL Cluster with HAProxy and Keepalived on OpenStack
ITPUB
ITPUB
Mar 15, 2016 · Databases

Choosing the Right MySQL OLTP Architecture: PXC, MHA, or Dual‑Master?

Before migrating enterprise OLTP workloads to open‑source MySQL, this guide evaluates three high‑availability architectures—Percona XtraDB Cluster, MHA, and native dual‑master—by outlining key pre‑migration questions, their advantages, drawbacks, and practical deployment considerations.

OLTPPercona XtraDB Clusterhigh availability
0 likes · 9 min read
Choosing the Right MySQL OLTP Architecture: PXC, MHA, or Dual‑Master?