There are five MySQL instances configured with a working group replication. Examine the output of the group members: Which two statements are true about network partitioning in the cluster? (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.
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. In a situation where there is a network partition, the remaining nodes are not able to tell if the unreachable servers have crashed or whether a network partition has isolated these nodes alone and therefore the group cannot be reconfigured automatically1. This could potentially lead to both a 2 node and 3 node group replication still running.
E. A manual intervention to force group members to be only the working two instances is required. When a majority of group members is lost, the group is unable to progress and blocks because it cannot secure majority or quorum1. In this case, manual intervention may be required to reconfigure the group with only the working instances.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
D, the 3 unreachable nodes could be together in a group
E, If you want to up nodes in a cluster, you need to remove the other 3
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
FelipeK
9 months, 3 weeks agoxjllll
7 months, 3 weeks agomarklv
10 months ago