1Z0-908 practice question 8 of 25

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

Full set: 140 questions
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. Correct answer
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. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
Explanation

The mysqlrouter --bootstrap command is used for the initial setup of a MySQL Router instance to work with an InnoDB Cluster. When executed, the router connects to a specified member of the InnoDB Cluster (the hostname:port). It then queries the InnoDB Cluster metadata schema on that server to retrieve the current topology of the cluster, including the primary and secondary instances. Using this information, it automatically generates its own configuration file (mysqlrouter.conf) in the specified --directory, which contains the necessary routing rules to direct client traffic appropriately.

Why Incorrect

A. This is incorrect. The --bootstrap option creates the configuration files in directorypath; it does not read from them. Reading an existing configuration is done with the --config option.
C. This is incorrect. The bootstrap process only creates the configuration. It does not start or restart the MySQL Router service. This must be done as a separate step after bootstrapping is complete.
D. This is incorrect. MySQL Router's role is to route traffic to the cluster nodes. It does not have the capability or permissions to configure the MySQL server instances that form the cluster.

References

1. MySQL 8.0 Reference Manual

Section 22.3.1

"Bootstrapping MySQL Router":

"Bootstrapping MySQL Router connects it to an InnoDB Cluster or InnoDB ReplicaSet and creates the configuration files required to run it. When you bootstrap MySQL Router against an InnoDB Cluster's metadata server

it fetches the metadata and uses it to configure itself." This directly supports answer B.

The manual shows the command syntax shell> mysqlrouter --bootstrap @: --directory

which matches the question's command.

2. MySQL 8.0 Reference Manual

Section 8.6

"Using MySQL Router with InnoDB Cluster":

"To deploy MySQL Router with your Cluster

you must bootstrap it against the Cluster. Bootstrapping connects MySQL Router to the Cluster

and creates the configuration files required to run it... MySQL Router fetches the Cluster's metadata

which contains the topology of the Cluster

and uses it to configure itself." This reinforces that the router retrieves information from the cluster to configure itself.

Scroll to Top