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.