QuestionQ22

VerifiedMigrate data solutions

You are migrating a critical production database from Amazon RDS for MySQL to Cloud SQL for MySQL using Google Cloud's Database Migration Service. You want to minimize disruption to the production database while also optimizing migration performance. What should you do?

Explanation

Data dump parallelism accelerates the initial migration load, but it increases load on the source database. Using an Amazon RDS MySQL read replica as the migration source isolates that work from the production primary, and setting Initial Load Parallelism to Maximum maximizes initial-load throughput. Google Cloud also documents using a read replica when locking or disrupting the source is not acceptable.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!