Exam 1z0-908 All QuestionsBrowse all questions from this exam
Go to Exam
Question 74

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?

    Correct Answer: D

    The error message indicates that the active session instance (host3:3377) is not the most updated compared to the ONLINE instances of the cluster's metadata and specifically mentions host1:3377 as the most up-to-date instance. To determine the most up-to-date instance in such a scenario, it is crucial to compare the global transaction identifier (GTID) sets of the instances. The GTID_SUBSET function can be used to compare GTID sets and identify the most up-to-date instance. Therefore, it is possible to determine the most up-to-date instance by comparing different GTID sets with GTID_SUBSET(set1, set2).

Discussion
marklvOption: B

B, the error message mentions an online server

marklv

None of the servers were up before command was executed, So B is not it. The only right might be the last one with GTID_SUBSET