In this blog post, we’ll look at a transaction replay anomaly in Percona XtraDB Cluster.
Percona XtraDB Cluster/Galera replays a transaction if the data is non-conflicting but, the transaction happens to have conflicting locks.
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:
create database test;