MySQL 8.0 Database Administrator — Question 54

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

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.
• 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: A, F

Explanation

Option A is correct because SSL group communication must be enabled during the cluster's creation by using the specified parameter. Option F is also correct as SSL group communication necessitates specific recovery parameters. The other options are incorrect because they either misstate the requirements for existing clusters or incorrectly describe SSL behavior in the context of InnoDB Clusters.