BestHub
search
Sign in
Tag

Galera

0 views collected around this technical thread.

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.

Database PerformanceFlow ControlGalera
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
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.

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