1Z0-908 practice question 19 of 25
An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()…
Full set: 140 questionsThe error message The active session instance isn’t the most updated... Please use the most up to date instance: ‘host1:3377’ occurs because the dba.rebootClusterFromCompleteOutage() command must be executed from the cluster member that processed the most transactions before the outage. InnoDB Cluster determines this by comparing the Global Transaction Identifier (GTID) sets of all member instances. The instance with the superset of all GTIDs is considered the most up-to-date. The error explicitly states that host1:3377 is this instance. Therefore, the statement that this determination is made by comparing GTID sets is the most accurate technical explanation for the situation presented.
A. Rebuilding from a backup is a manual recovery method, not the standard procedure required by InnoDB Cluster tooling, which is designed to handle resynchronization automatically.
B. The command being executed, dba.rebootClusterFromCompleteOutage(), explicitly indicates that the cluster is not running and is in a state of complete outage.
C. The cluster.addInstance() command is used to add a new instance to an already running and healthy cluster, not to rejoin an existing member during a recovery from an outage.
E. The session to host3:3377 is valid, but the instance itself is not the most up-to-date. Reconnecting to the same outdated instance will result in the same error.
1. MySQL 8.0 Reference Manual, Section 21.5.3.2, "Rebooting a Cluster from a Complete Outage": The documentation states, "It then tries to discover the other members of the cluster and checks which of them has the most recent set of transactions. To do this, it compares the GTID sets of the members. If the instance you are connected to is not the one with the most recent transactions, the operation stops and returns an error." This directly supports that GTID set comparison is the underlying mechanism.
2. MySQL 8.0 Reference Manual, Section 17.1.3.6, "GTID Set Functions": This section describes the GTIDSUBSET() function, which "returns true if all GTIDs in set1 are also in set2." This is the specific function used to perform the comparison of GTID sets to find the most up-to-date member.
3. MySQL 8.0 Reference Manual, Section 21.4.3.1, "Adding an Instance to a Cluster": The documentation for cluster.addInstance(instance) confirms its purpose is to "add a MySQL server instance to a cluster," which is not the operation required in a complete outage recovery scenario for an existing member. This refutes the action proposed in option C.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 2You must run multiple instances of MySQL Server on a single host. Which three methods are…
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
