What should you do?

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime.

What should you do?
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.

View Answer

Answer: D

Explanation:

https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external