Answer-first summary for fast verification
Answer: 1. Use Database Migration Service to connect to your on-premises database, and choose continuous replication. 2. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
The correct approach for migrating a critical, on-premises MySQL database to Cloud SQL for MySQL while preserving transactions and minimizing downtime is to use the Database Migration Service with continuous replication. This method ensures that transactions are preserved and downtime is minimized by continuously replicating data from the on-premises database to Cloud SQL. Once the migration is complete, the Cloud SQL instance can be promoted and applications can be connected to it. Option A describes this approach accurately. Options B, C, and D involve methods that either do not ensure transaction preservation (B) or require significant downtime (C and D), making them less suitable for the given requirements.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you migrate an on-premises MySQL database to Cloud SQL for MySQL with minimal downtime while ensuring transaction consistency, given that the on-premises database runs a supported MySQL version and uses the InnoDB storage engine?
A
B
C
D
1 Pause the on-premises applications. 2. Use the mysqldump utility to dump the database content in CSV format. 3. Run gsutil –m to move the dump file to Cloud Storage. 4. Use the Cloud SQL for MySQL import option. 5. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.