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.

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

    Deploying High Availability Cloud SQL Solutions - Hands-On Lab - CertiPass