Bug #62174 A feature for semi-sync replication

Description:
Semi-sync is cool. But in the semi-sync solution, there are “phantom read”: When InnoDB commit a transaction and no slave have accept the binary log, at the time another “new thread” still can read the data generated by this transaction. If database crash and gone(can't startup anymore) at this right time, although we have ever read these data, it's not exist in any slave and we think this transaction is never happened.

In our application architecture, if our “new thread” read “phantom data”, we will try to do some work about user's critical information. So we must not read the “phantom data”.

So,we add a new variables for semi-sync "rpl_semi_sync_master_wait_before_commit".Once you set this variables ON, MySQL(InnoDB) will not commit the transaction until at least one slave get the binary log. By default, it is OFF and semi-sync act as the original way.

How to repeat:
The "phantom read" the nature of original semi-sync.

Suggested fix:
A patch has been commit on Launchpad.net:
https://code.launchpad.net/~orczhou/mysql-server/ESR

Thank you for the feature request and patch contributed.

Enhanced Semi-sync Replication to make sure log sent before *commit*

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: ESR.MySQL.5.5.16.patch (application/octet-stream, text), 19.36 KiB.

MySQL5.5.15 Enhanced Semi-sync Replication to make sure log sent before *commit*

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: ESR.percona.5.5.15.patch (application/octet-stream, text), 20.03 KiB.

Bug fix bug#44058(issue 5)

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: ESR.percona.5.5.15.fix-bug-44058.patch (application/octet-stream, text), 6.43 KiB.

Hi Zhou Zhenxing,

Thank you again for the contributions. Your contributions have not been used, but we wrote a new patch inspired by them.