More Info:

Ensures that SQL instances have a failover replica to be cross-AZ for high availability. Creating SQL instances in with a single AZ creates a single point of failure for all systems relying on that database. All SQL instances should be created in multiple AZs to ensure proper failover.

Risk Level

Medium

Address

Reliability, Operational Maturity, Security

Compliance Standards

HITRUST, SOC2, NISTCSF, PCIDSS

Triage and Remediation

Remediation

In GCP, the equivalent of Multi-AZ in AWS is called “Instance Group”. Here are the step-by-step instructions to remediate the misconfiguration:

  1. Open the GCP console and navigate to the Compute Engine section.
  2. Select the instance that needs to be remediated.
  3. Click on the “Edit” button at the top of the page.
  4. Scroll down to the “Availability Policy” section.
  5. Check the box next to “Create a new instance group” and select the region where the group will be created.
  6. Choose the “Regional” option for the instance group type.
  7. In the “Size” field, enter the number of instances you want to create in the group.
  8. Click on “Save” to create the instance group.

Once the instance group is created, the instance will automatically be replicated across multiple zones within the selected region, providing Multi-AZ functionality.

Additional Reading: