ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
分类： Mysql/postgreSQL
2021-01-18 10:32:23
Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第10题
Choose the best answer.
Examine these commands, which execute successfully on the ic1 host:
mysqlsh> dba.createCluster( 'cluster1' , {memberWeight:35})
mysqlsh> var mycluster = dba.getCluster ()
mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25})
mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50})
Now examine this configuration setting, which is the same on all nodes:
group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER
Which statement is true if primary node ic1 fails?
A) Node ic2 becomes the new primary and existing transactions are considered stale and rolled back.
B) Node ic3 becomes the new primary and existing transactions are considered stale and rolled back.
C) Node ic3 becomes the new primary and is ignored until any backlog of transactions is completed.
D) Only two nodes remain so the election process is uncertain and must be done manually.
E) Node ic2 becomes the new primary and is ignored until any backlog of transactions is completed.
