Tag - constraint violation

Percona XtraDB Cluster Transaction Replay Anomaly

wsrep-stages

In this blog post, we’ll look at a transaction replay anomaly in Percona XtraDB Cluster.
Introduction
Percona XtraDB Cluster/Galera replays a transaction if the data is non-conflicting but, the transaction happens to have conflicting locks.
Anomaly
Let’s understand this with an example:

Let’s assume a two-node cluster (node-1 and node-2)
Base table “t” is created as follows:

Shell

create database test;
use test;
create […]

Read more