Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to…

Question

Options

• A
  1. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to
• B
  1. Create migration job using Database Migration Service.
• C
  1. Create migration job using Database Migration Service.
• D
  1. Use the mysqldump utility to manually initiate a backup of MySQL during the application

• A
  11% (5)
• B
  81% (38)
• C
  2% (1)
• D
  6% (3)

Explanation

Database Migration Service (DMS) is Google's purpose-built tool for migrating databases to Cloud SQL with minimal downtime. It uses Change Data Capture (CDC) to continuously replicate changes from the source database to Cloud SQL in real time. This means the cutover window is extremely short - only the time needed to stop writes, verify replication is caught up, and redirect the application. A manual mysqldump (D) of a 500 GB database would require a long maintenance window for the dump, transfer, and import, making it unsuitable for minimizing downtime. DMS handles the bulk load and ongoing CDC in a managed, Google-recommended workflow specifically designed for this migration pattern.

No community discussion yet for this question.