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 questions
Answer options
A: SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
B: Configuring SSL group communication also configures SSL distributed recovery. Correct answer
C: An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
D: SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
E: If only some InnoDB Cluster members are enabled for SSL group communication, and --ssl- mode=PREFERRED, communication will fall back to unencrypted connection.
F: SSL group communication requires the use of an additional set of parameters group_replication_recovery_*. Correct answer
Correct Answer:
B. Configuring SSL group communication also configures SSL distributed recovery.; F. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
Explanation

When 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.

Why Incorrect

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.

References

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.

Scroll to Top