Question about MySQL Semisynchronous Replication
4
votes
1
answer
239
views
I was researching about MySQL Semisynchronous Replication , my understanding about the workflow is the follow:
1. Master Receive a successful transaction from a client session.
2. Master write it to his binaty log
3. Master wait for
rpl_semi_sync_master_timeout
milliseconds to receive an acknowledgment from at least one slave
4. Slave pick this successful transaction, write it to his relay log, flush it to disk
5. Slave return an acknowledgment to master
6. Master return successful to his client session.
My question is, at any point, this type of replication ensures that the transaction is executed on slave(SQL_TREAD
applies it). Having in mind that it will add a delay on each transaction and in a case of master failure, is not 100% guaranteed that the slave will be consistent with master, what is the benefit(s) of using this type of replication?
Asked by altmannmarcelo
(1217 rep)
May 5, 2013, 01:08 PM
Last activity: May 5, 2013, 03:18 PM
Last activity: May 5, 2013, 03:18 PM