Implementing a Secure and Scalable Database Solution with Cloud SQL and Spanner

ADVANCED
120 minutes
5 tasks

In this advanced lab, you will build a secure and scalable database infrastructure using Google Cloud SQL and Cloud Spanner. The lab focuses on integrating these database services to handle a high volume of transactions with low latency while providing robust security configurations such as IAM and CMEK. By completing this lab, you'll gain hands-on experience in setting up databases that balance cost, performance, and security for enterprise environments.

Scenario

Imagine you work for a growing e-commerce company, TechTrade, which processes thousands of customer transactions per day. The company needs to ensure that their database architecture can scale to meet future growth projections and handle peak shopping periods. TechTrade aims for an SLA of 99.9% uptime with failover capabilities in place to minimize downtime.

Learning Objectives

  • Set up Cloud SQL with high availability and replicas
  • Configure Cloud Spanner for strong consistency and low latency
  • Implement IAM policies for secure database access
  • Utilize CMEK for encryption at rest

tasks (5)

task 1: Create a Cloud SQL instance with HA and read replicas

30 min

task 2: Setup a Cloud Spanner instance with appropriate configurations

30 min

task 3: Implement IAM policies for securing databases

20 min

task 4: Encrypt databases using Customer-Managed Encryption Keys (CMEK)

20 min

task 5: Monitor and optimize database performance

30 min

Prerequisites

  • Basic understanding of SQL and Spanner concepts
  • Familiarity with Google Cloud Platform services
  • Understanding IAM roles and permissions

Skills Tested

Configure high availability and replicas in Cloud SQLSet up Cloud Spanner with strong consistencyImplement IAM policies for database securityUtilize customer-managed encryption keys for databasesDeploy monitoring and alerting for database performance
    Implementing a Secure and Scalable Database Solution with Cloud SQL and Spanner - Hands-On Lab - CertiPass