MySQL 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第23题

23、

Choose the best answer.

An attempt to recover an InnoDB Cluster fails.

Examine this set of messages and responses:

host3: 3377 ssl JS > DBA.rebootClusterFromCompleteOutage ()

Reconfiguring the default cluster from complete outage. . .

The instance ' host1:3377' was part of the cluster configuration.

Would you like to rejoin it to the cluster? [y/N] : y

The instance ' host2:3377' was part of the cluster configuration.

Would you like to rejoin it to the cluster? [y/N] : y

Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata.

Please use the most up to date instance: ' host1:3377'. (RuntimeError)

Which statement is true?

A) The cluster is running and there is at least one ONLINE instance.

B) The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').

C) It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET (set1, set2).

D) The active session instanceis invalid and must be re-created by using the command shell.connect ('host3:3377').

E) The instance deployed on host3 must be rebuilt with a backup from the primary instance.