Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Overview
If the master server of the cluster changes mid-session, it should be possible for the slave servers to use this new server. For Galera clusters, node corruption due to master migration is not possible. Master-slave clusters are also free of node corruption if the master failover is performed in a way that blocks new writes for occurring on the old master e.g. with SET GLOBAL read_only=ON.
Task Details
A new master can be taken into use if and only if:
- Autocommit is enabled
- No transactions are open on the old master
Write queries with autocommit enabled that are already in progress when the switch happens do not prevent the master migration from taking place.