SSL for distributed recovery is configured separately from SSL for normal group communications, which is determined by the server's SSL settings and the group_replication_ssl_mode
system variable. For distributed recovery connections, dedicated Group Replication distributed recovery SSL system variables are available to configure the use of certificates and ciphers specifically for distributed recovery.
By default, SSL is not used for distributed recovery connections. To activate it, set group_replication_recovery_use_ssl=ON
, and configure the Group Replication distributed recovery SSL system variables as described in Section 18.6.3, “Securing Distributed Recovery Connections”. You need a replication user that is set up to use SSL.
When distributed recovery is configured to use SSL, Group Replication applies this setting for remote cloning operations, as well as for state transfer from a donor's binary log. Group Replication automatically configures the settings for the clone SSL options (clone_ssl_ca
, clone_ssl_cert
, and clone_ssl_key
) to match your settings for the corresponding Group Replication distributed recovery options (group_replication_recovery_ssl_ca
, group_replication_recovery_ssl_cert
, and group_replication_recovery_ssl_key
).
If you are not using SSL for distributed recovery (so group_replication_recovery_use_ssl
is set to OFF
), and the replication user account for Group Replication authenticates with the caching_sha2_password
plugin (which is the default in MySQL 8.0) or the sha256_password
plugin, RSA key-pairs are used for password exchange. In this case, either use the group_replication_recovery_public_key_path
system variable to specify the RSA public key file, or use the group_replication_recovery_get_public_key
system variable to request the public key from the source, as described in Section 18.6.3.1.1, “Replication User With The Caching SHA-2 Authentication Plugin”.