Scale Highly Available Databases with Cloud SQL

ADVANCED
130 minutes
5 tasks

In this lab, you will configure a highly available Cloud SQL instance with read replicas and failover capabilities. You will also automate failover testing and integrate Cloud SQL Insights for robust monitoring. This exercise aims to mimic real-world scenarios where high availability is critical, such as financial services or e-commerce platforms. By the end of this lab, you will have hands-on experience with leveraging Cloud SQL's high availability features to meet stringent uptime SLAs of 99.95%.

Scenario

A global e-commerce platform requires a database solution that can handle millions of transactions daily while ensuring high availability across regional outages. The company needs to set up a Cloud SQL environment to support a multi-region deployment with automatic failover and strong monitoring capabilities, meeting an SLA of 99.95% uptime with a budget under $10 per hour for database operations.

Learning Objectives

  • Configure a highly available Cloud SQL instance with read replicas.
  • Automate failover testing for disaster recovery.
  • Integrate Cloud SQL Insights for enhanced database monitoring.

tasks (5)

task 1: Configure Cloud SQL Instance for High Availability

30 min

task 2: Automate Failover Testing for Cloud SQL

25 min

task 3: Integrate Cloud SQL Insights for Monitoring

20 min

task 4: Configure Multi-Regional Database Deployment

35 min

task 5: Automate Instance Monitoring Setup

20 min

Prerequisites

  • Basic knowledge of Cloud SQL configuration
  • Understanding of GCP IAM roles

Skills Tested

Provisioning highly available Cloud SQL databasesAutomating failover processes using GCP functionsConfiguring and using Cloud SQL Insights for monitoring