Skip to content

Latest commit

 

History

History
27 lines (23 loc) · 2.2 KB

db-multiple-az.md

File metadata and controls

27 lines (23 loc) · 2.2 KB
Raw

CloudSploit

GOOGLE / SQL / DB Multiple AZ

Quick Info
Plugin Title DB Multiple AZ
Cloud GOOGLE
Category SQL
Description Ensures that SQL instances have a failover replica to be cross-AZ for high availability
More Info 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.
GOOGLE Link https://cloud.google.com/sql/docs/mysql/instance-settings
Recommended Action Ensure that all database instances have a DB replica enabled in a secondary AZ.

Detailed Remediation Steps

  1. Log into the Google Cloud Platform Console.
  2. Scroll down the left navigation panel and choose the "SQL" option under the "Storage."
  3. On the "SQL" page , click on the "Instance ID" as a link option to select the "SQL" instance.
  4. On the "SQL" page, scroll down and check the "Sugegsted actions" and if it's showing "Enable High availability", then the selected SQL instance is not as per the recommended guidelines of GCP.
  5. Repeat steps number 2 - 5 to check other SQL instance in the account.
  6. Navigate to the "SQL" option under the "Storage", choose the "SQL Instance" and click on the "Edit" button at the top.
  7. On the "Edit instance" page, scroll down and click on the "Auto backups and high availability" under the "Configuration options."
  8. On the "db-automated-backups" tab, click on the checkbox next to "High Availability" under the "Availability" section.
  9. Click on the "Save" button to make the changes.
  10. Repeat steps number 6 - 9 to ensure that all database instances have a DB replica enabled in a secondary AZ.