Question

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 metadat a. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).

An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()…

Take the free 1Z0-908 practice test

Other 1Z0-908 practice questions