1Z0-908 practice question 5 of 25
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. You must configure InnoDB Cluster to use SSL for group communication. Which two statements are true? (Choose two.)
Full set: 140 questionsWhen managing an InnoDB Cluster, the MySQL Shell AdminAPI is the standard tool. When you configure the cluster to use SSL for member communication (by setting the memberSslMode option to REQUIRED), the AdminAPI automatically configures SSL for the distributed recovery channel as well. This makes statement (B) correct. For a comprehensively secure cluster, if group communication messages are encrypted, the distributed recovery process, which can transfer the entire dataset to a joining member, must also be encrypted. This requires the use of the groupreplicationrecovery SSL parameters on the underlying Group Replication members, making statement (F) a true requirement for a secure setup.
A. This is incorrect. SSL for group communication can be enabled on an existing cluster using the cluster.setOption('memberSslMode', 'REQUIRED') command. It is not mandatory to configure it only at creation time.
C. This is incorrect. An existing InnoDB Cluster does not need to be dissolved. The cluster.setOption() command in MySQL Shell allows for online modification of the SSL mode for the cluster.
D. This is incorrect. While technically possible to change the variable on one server, this is not the proper procedure and would lead to inconsistent configurations, likely causing the member to fail to connect to the group. Changes must be applied consistently across the cluster using the AdminAPI.
E. This is incorrect. The groupreplicationsslmode variable, which controls SSL for group communication, does not have a PREFERRED value. Valid values are DISABLED, REQUIRED, VERIFYCA, and VERIFYIDENTITY.
1. MySQL 8.0 Reference Manual, Section 21.3.2, "Securing InnoDB Cluster": This section explicitly states, "When you create or configure an InnoDB Cluster to use SSL for connections between the cluster members (by setting the memberSslMode option to REQUIRED), MySQL Shell automatically configures the Group Replication distributed recovery channel to use SSL as well." This directly supports answer B.
2. MySQL 8.0 Reference Manual, Section 18.5.2.2, "Securing Distributed Recovery Connections": This section details the requirement for separate SSL configuration for the recovery channel. It states, "To use a secure connection for distributed recovery, you must configure the appropriate SSL options for this on the joining member," and lists the groupreplicationrecoveryssl parameters. This supports answer F.
3. MySQL Shell 8.0, Section 7.6, "AdminAPI InnoDB Cluster Options": The documentation for the memberSslMode option states, "Can be set with createCluster() or setOption()." This confirms that SSL does not have to be configured at creation time, invalidating answers A and 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 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…
- Question 9Examine this command, which executes successfully: shell> mysqldump --master-data=2 --sin…
