This plugin was introduced in MySQL 5.5. The plugin needs to be installed on both the Master and Slave. Once enabled, a thread on the Master that performs a transaction commit is getting blocked, which is depicted in the following diagram:
It is interesting to note here that the transaction on the Master gets committed, but the client thread and is blocked until it receives an answer from at least one Slave server. The Slave acknowledges that it has received all events for a transaction and is written to relay the log, as well as written to disk, but not necessary executed on the Slave.
This mechanism also does ...
