Tagged articles
Percona XtraDB Cluster
13 articles · Page 1 of 1
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

This article investigates a recurring crash in Percona XtraDB Cluster 8.0.41 caused by the removal of the wsrep_group_commit_queue component, analyzes error logs and core dumps with GDB, reveals a circular deadlock among internal threads, and provides reproducible steps and debugging tips for DBAs.
Group CommitMySQLPercona XtraDB Cluster
0 likes · 27 min read

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 ReplicationGaleraHigh Availability
0 likes · 10 min read

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.
Database ClusteringGaleraMHA
0 likes · 10 min read

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.
Database ClusteringDocker SwarmHAProxy
0 likes · 10 min read

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 ControlGaleraMySQL
0 likes · 11 min read

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.
InnoDBMyISAMMySQL
0 likes · 14 min read

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.
GTIDGaleraMySQL
0 likes · 17 min read

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.
GaleraHigh AvailabilityMySQL
0 likes · 36 min read

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.
HAProxyInstance SplittingMySQL
0 likes · 14 min read

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 ControlGaleraMySQL
0 likes · 9 min read


ITPUBAug 2, 2016 · Databases
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.
HAProxyHigh AvailabilityKeepalived
0 likes · 13 min read


ITPUBMar 15, 2016 · Databases
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.
High AvailabilityMySQLOLTP
0 likes · 9 min read
