1z0-908 Exam QuestionsBrowse all questions from this exam

1z0-908 Exam - Question 17


Examine this MySQL Shell command:

dba.rebootClusterFromCompleteOutage()

Which two statements are true? (Choose two.)

Show Answer
Correct Answer: A,B,D,G

The command dba.rebootClusterFromCompleteOutage() is used to recover an InnoDB Cluster after a complete outage where all members are down. It reconfigures InnoDB Cluster if the cluster was stopped, which is necessary to bring the cluster back to its operational state. Additionally, it picks the minimum number of instances necessary to rebuild the quorum and reconfigures the InnoDB Cluster, allowing the cluster to become operational even if not all instances are reachable.

Discussion

2 comments
Sign in to comment
marklvOptions: CD
Sep 29, 2023

C and D. It doesn't restart. Only a majority are needed to start the cluster. It just starts nodes.

FelipeKOptions: AG
Jan 14, 2024

A. It reconfigures InnoDB Cluster if the cluster was stopped. This function is specifically designed to recover a cluster after a complete outage, which means that group replication has stopped on all member instances. G. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster. The function retrieves the cluster metadata and topology from the current instance, checks which instances of the cluster are currently reachable, and recovers the cluster based on the metadata stored in that instance. If any member is currently unreachable, the function fails, but this check can be bypassed with the force option.

marklv
Jul 15, 2024

I don't know if it reconfigures anything.