Advanced MySQL 8

Detecting failure

Group membership is a service as part of the group replication plugin. It maintains a view of a group, which contains a list of all the members of the group, channels, member IDs, their hostname, port, state, role, and MySQL Version. The view is consistent across all members of the group.

For any state change in any members, voluntarily or not, a group reconfiguration event is triggered. All members need to agree upon is to allow a server to join or leave the group and trigger the change of view. If a member suddenly becomes unavailable, then the failure detection mechanism realizes the fact and reconfiguration of the group is proposed, without the failed member. For any change, the majority of the group's members should ...