MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ21Ìâ

MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ21Ìâ

21¡¢

Choose two.

There are five MySQL instances configured with a working group replication.

Examine the output of the group members:

MySQL> SELECT MEMBER_ID, MEMBER_STATE FROM performance_schema.replication_group_members;

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

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

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

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

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) The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.