Question22:

There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

image.png

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

A) A manual intervention to force group members to be only the working two instances is required.

B) The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

C) 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.

D) The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

E) The cluster will shut down to preserve data consistency.