Re:MySQL InnoDB Cluster GA
by p4lindromica on Wednesday April 12, 2017 @04:20PM
(#14101351)
That's not what semi-sync does. Semi-sync commits the write to the master and then blocks on returning a result to the client until N replicas have received a write OR a timeout is reached. There is no ability to roll back the write on the master once it is committed.
[ Parent
| on HN ]
This was the case for 5.5 and 5.6. MySQL 5.7+ will default to wait for the ack before committing locally:
https://dev.mysql.com/doc/refman/5.7/en/server-system-variab...
Re:MySQL InnoDB Cluster GA
by p4lindromica on Wednesday April 12, 2017 @04:54PM
(#14101653)
Does AFTER_SYNC mean MySQL 5.7+ can have unacknowledged writes appear on the slaves after a master crash and failover?
I believe the answer is "yes" but this problem is not unique to semi-sync. Take a single server example:
You could ask the database to "COMMIT"; it receives the command and processes it, but does not manage to send you notification that it has managed.
There is a further failure state:
The master could be behind when it crashed. So you need to look at it's gtid executed set or re-image it before plugging it back in.
(Not a distributed systems guy; I work on the non HA+replication parts of the server)