Advanced MySQL 8

Total order delivery

To maintain the same state on all of the members of the group, it is very important that execution of the transaction happens in the same order. As shown in the previous diagram, server 1 is executing a transaction first, but the transaction that is executed on server 5 gets certified first, and that will be queued first. The same order of the transactions will be preserved and followed by the slaves. For advanced users, the execution of threads on slaves can be parallelized for transactions with the disjoint sets of the writeset.

The following diagram represents the ordered delivery of certified transactions: