Advanced MySQL 8

Distributed first commit wins rule

The following diagram shows an error: modifying the same tuple across primary at the same time:

As you can see from the previous diagram, transaction 1 started execution on Node 1, and transaction 2 on Node 3. Both of them are updating the same tuple in this case. The certification process has detected this, allowed the first transaction to make the change, and failed the other.