10.1 Ensure All Group Replication Traffic is Secured

Information

MySQL Group communication connections and distributed recovery connections can be secured using SSL.

SSL encryption ensures data cannot be seen over the network for Group Replication.

Solution

Edit my.cnf and set group_replication_ssl_mode for example:

group_replication_ssl_mode=REQUIRED

Acceptable values are:

- REQUIRED - Establish a secure connection if the server supports secure connections.
- VERIFY_CA - Like REQUIRED but additionally verify the server TLS certificate against the configured Certificate Authority (CA) certificates.
- VERIFY_IDENTITY - Like VERIFY_CA but additionally verify that the server certificate matches the host to which the connection is being established.

See Also

https://workbench.cisecurity.org/benchmarks/15504

Item Details

Category: ACCESS CONTROL, IDENTIFICATION AND AUTHENTICATION, SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|AC-17(2), 800-53|IA-5, 800-53|IA-5(1), 800-53|SC-8, 800-53|SC-8(1), CSCv7|14.4

Plugin: MySQLDB

Control ID: 759beee23f9b5767528dff99fbe0ca69e44875cb2a51adc1a7adb2748266daee