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 Cloud SQL, which is a fully managed database service. Option B suggests using the mysqldump utility to take a backup of the existing on-premises database and then importing it into Cloud SQL. This method is straightforward but may involve some downtime during the import process. Option D, however, suggests creating an external replica and using Cloud SQL to synchronize the data to the replica. This method is more aligned with Google's recommended practices for minimal downtime migrations, as it allows for continuous synchronization of data from the on-premises database to Cloud SQL, significantly reducing downtime. Therefore, the correct answer is 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 while minimizing downtime, reducing the cost and overhead of nightly incremental backups, and adhering to Google's recommended practices?
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.