MySQL 8.0 Database Administrator — Question 67

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path
Which activity is performed?

Answer options

• A. MySQL Router is configured based on the information in files in directory_path.
• B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
• C. MySQL Router is restarted.
• D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

Correct answer: B

Explanation

The correct answer is B because the --bootstrap option initializes MySQL Router using metadata from the InnoDB cluster, allowing it to configure itself accordingly. Options A and D are incorrect because they incorrectly imply that the configuration is based on local files or only for cluster nodes, while C is wrong as the command does not indicate a restart of MySQL Router.