Answer-first summary for fast verification
Answer: Create an external replica, and use Cloud SQL to synchronize the data to the replica.
To migrate a MySQL database to Google Cloud with minimal downtime and following Google-recommended practices, the best approach is to use Database Migration Service (DMS) or similar services that allow for live migration. However, among the given options, creating an external replica and using Cloud SQL to synchronize the data to the replica (Option D) is the most aligned with minimizing downtime and leveraging Google Cloud's managed services. This method allows for the existing on-premises database to continue serving live traffic while the replica is being synchronized, thus ensuring minimal downtime. Options A, B, and C involve taking a dump of the database, which would require downtime during the import process and do not leverage Google's managed database services as effectively as Option D.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you migrate an on-premises MySQL database with read replicas to Google Cloud following Google-recommended practices to minimize downtime, while addressing the high cost and maintenance overhead of nightly incremental backups?
A
Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
B
Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
C
Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
D
Create an external replica, and use Cloud SQL to synchronize the data to the replica.
No comments yet.