MySQL 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第21题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询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.