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.