More Info:

Ensure that SQL Read Replica Instances are encrypted using Customer Managed Keys (CMKs).

Risk Level

Medium

Address

Security

Compliance Standards

HITRUST, GDPR, SOC2, NISTCSF, PCIDSS

Triage and Remediation

Remediation

Sure, I can help you with that. Here are the step-by-step instructions to remediate the issue of SQL Read Replica Instances not being encrypted using Customer Managed Keys (CMKs) in GCP Console:

  1. Open the GCP Console and navigate to the Cloud SQL instances page.

  2. Select the read replica instance that you want to encrypt.

  3. Click on the “Edit” button at the top of the page.

  4. Scroll down to the “Encryption” section and select “Customer-managed key” from the dropdown menu.

  5. Click on the “Select a key” button and choose the desired key from the list of available keys.

  6. If you don’t have a key yet, click on the “Create a key” button and follow the instructions to create a new key.

  7. Once you have selected or created the key, click on the “Save” button to apply the changes.

  8. Wait for the encryption to complete. This may take some time depending on the size of your database.

  9. Once the encryption is complete, verify that the replica is now using customer-managed encryption keys by checking the “Encryption” section of the instance details page.

Congratulations! You have successfully remediated the issue of SQL Read Replica Instances not being encrypted using Customer Managed Keys (CMKs) in GCP Console.