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.