Advanced MySQL 8

Use cases for group replication

MySQL's group replication feature provides a way to build a highly available MySQL service, as long as the group has the majority of the servers functioning. We can achieve this because it replicates the same state of the system to all members in a group. A majority of the group's members should agree on the change of the state of MySQL members, message delivery, and state updates. Group replication has a built-in service for failure detection, which maintains a view of members subscribed to the group. At any given point when a member server leaves or joins the group, the view should be updated after the approval of the majority of the members in the group. Although MySQL is highly available as a service, if ...