Data Inconsistency

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.

Data InconsistencyDatabase OperationsInnoDB

0 likes · 14 min read

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

Aikesheng Open Source Community

Mar 20, 2019 · Databases

Analysis of MySQL Group Replication Data Inconsistency Caused by GTID Mismatch and Paxos Proposal Conflict

This article examines a real‑world MySQL Group Replication failure where network jitter caused a primary INSERT not to replicate, leading to GTID divergence, a secondary node leaving the cluster, and explains the underlying Paxos‑based proposal conflict with detailed code examples.

Data InconsistencyDatabase HAGTID

0 likes · 11 min read

Analysis of MySQL Group Replication Data Inconsistency Caused by GTID Mismatch and Paxos Proposal Conflict