Tagged articles
Galera
12 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

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 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 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

A large‑scale delete operation in a MySQL PXC cluster caused transaction rollback, table locks, and flow control, leading to service slowdown, and was resolved by redesigning the cleanup mechanism with partitioned tables, stored procedures, and scheduled events.
Flow ControlGaleraMySQL
0 likes · 13 min read

The Galera MySQL 5.7.17 SST fails when a pre‑initialized node is added because the rsync‑based SST filter omits the independent undo‑log tablespace files (undo*), causing InnoDB to roll back uncommitted transactions; adding an undo* rule to the filter copies the missing files and resolves the error, a fix now upstream.
GaleraMySQLSST
0 likes · 4 min read

This article presents a comprehensive overview of MySQL high‑availability solutions, covering classic HA architectures, synchronization tools such as MHA, MMM, HA‑JDBC, Galera and Group Replication, and shares NetEase's practical implementations using distributed databases and keepalive‑based failover.
Distributed DatabaseGaleraGroup Replication
0 likes · 16 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

This guide explains how to back up a MySQL Galera Cluster by leveraging the State Snapshot Transfer (SST) mechanism, detailing the default and custom scripts, required parameters, execution flow, and the key benefits of using SST for point‑in‑time, non‑intrusive backups.
GaleraMySQLReplication
0 likes · 9 min read

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