1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ27

Architecture

Five MySQL instances are configured in a functioning Group Replication group. Review the group-members output:

Question Image

Which two statements about network partitioning in the cluster are true?

Choose two
  • A The cluster will shut down to preserve data consistency.
  • B The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
  • C The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
  • D There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
  • E A manual intervention to force group members to be only the working two instances is required.
Explanation

Group Replication requires a majority to reach consensus. With only two reachable members in a five-member group, that partition has no quorum and cannot determine whether the three unreachable members failed or form a separate three-member majority partition. The minority partition should be stopped while the issue is diagnosed. If the other three instances are confirmed failed and the two surviving instances must continue, an administrator must manually force a new group membership containing those two instances.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!