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.)
Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 30
Correct Answer: D, E
With three out of five nodes being unreachable, there is a high chance of network partitioning. In such cases, there could be both a 2-node and a 3-node group replication still running, making it necessary to shut down group replication and diagnose the issue to avoid data inconsistency and conflict. Moreover, because the group is unable to progress or secure a majority quorum due to the loss of most group members, manual intervention is needed to force group members to include only the working two instances. This ensures the stability and consistency of the remaining group.
Discussion
FelipeKOptions: DE
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
xjllll
Why not C
marklvOptions: DE
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