CertiPass LogoCertiPass

Deploying High Availability Cloud SQL Solutions

ADVANCED
180 minutes
5 tasks

In this lab, students will design and implement a highly available database architecture using Cloud SQL. They will configure read replicas for load balancing, set up failover replicas for high availability, and implement point-in-time recovery (PITR) to ensure data durability. Participants will learn to evaluate costs and performance trade-offs in their configurations.

Sandbox access coming soon

Scenario

Your company, DataSecure Inc., is transitioning from an on-premises SQL Server environment to Google Cloud. The IT department needs a solution that allows for seamless scaling, ensures high availability, and supports disaster recovery with minimal downtime. They must handle 50,000 transactions per minute with a database latency of under 100 ms.

Learning Objectives

  • Design a high availability architecture for Cloud SQL
  • Implement read replicas and failover replicas
  • Enable point-in-time recovery (PITR)
  • Evaluate trade-offs between performance and cost

tasks (5)

task 1: Create a Cloud SQL instance with high availability

40 min

task 2: Enable Point-In-Time Recovery for Cloud SQL

30 min

task 3: Configure SQL Insights for performance monitoring

30 min

task 4: Perform a failover test to ensure high availability

40 min

task 5: Evaluate cost implications of the database architecture

40 min

Prerequisites

  • •Basic understanding of Cloud SQL and high availability concepts

Skills Tested

Designing high availability for Cloud SQLImplementing replication and PITR on Cloud SQLMonitoring performance with SQL Insights

References