Mastering Database Migration with Cloud SQL and DMS

ADVANCED

180 minutes

5 tasks

In this lab, you will execute a comprehensive database migration strategy using Cloud SQL and the Database Migration Service (DMS). You'll design downtime-optimized migration plans, implement reverse replication, and evaluate different migration tools. Your focus will be on real-world scenarios where minimal service disruption is paramount.

Scenario

A hosting provider, DataSafe Inc., is migrating its client databases to Google Cloud to improve reliability and performance. They need to perform the migration with minimal downtime to comply with SLAs promising 99.9% uptime. Your task is to migrate multiple PostgreSQL databases from their existing infrastructure to Google Cloud using Cloud SQL while ensuring that all data integrations are maintained during and after the migration.

Learning Objectives

Design an optimized database migration plan for minimal downtime using DMS
Implement reverse replication from Cloud SQL to on-premise databases
Evaluate and select appropriate database migration tools

tasks (5)

task 1: Create a Cloud SQL PostgreSQL Instance

30 min

task 2: Configure Database Migration Service (DMS) for Minimal Downtime

45 min

task 3: Implement Reverse Replication from Cloud SQL

35 min

task 4: Evaluate and Document Migration Tools Used

40 min

task 5: Optimize Cloud SQL Settings for Cost and Performance