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 questionsThe 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.
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.
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.
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 9Examine this command, which executes successfully: shell> mysqldump --master-data=2 --sin…
