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?
ANode ic2 becomes the new primary and existing transactions are considered stale and rolled back.
BNode ic3 becomes the new primary and existing transactions are considered stale and rolled back.
CNode ic3 becomes the new primary and is ignored until any backlog of transactions is completed.
DOnly two nodes remain so the election process is uncertain and must be done manually.
ENode ic2 becomes the new primary and is ignored until any backlog of transactions is completed.