Answer-first summary for fast verification
Answer: Use Cloud SQL for MySQL external replica.
To scale reads and offload part of the management operations in a hybrid configuration using Compute Engine on Google Cloud and your data center, the best approach is to use Cloud SQL for MySQL external replica. This option allows you to create a replica of your MySQL database in Cloud SQL, which is fully managed by Google Cloud, thus offloading management operations. It also enables you to scale reads by directing read queries to the replica. External server replication (Option A) is not as managed or seamless as using Cloud SQL. Data Migration Service (Option B) is more suited for migrating data rather than creating replicas for scaling reads. Using the mysqldump utility and binary logs (Option D) is a manual and less efficient method compared to using Cloud SQL for MySQL external replica.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you create replicas for your hybrid MySQL databases, managed across Compute Engine on Google Cloud and your data center, to scale reads and offload management operations?
A
Use external server replication.
B
Use Data Migration Service.
C
Use Cloud SQL for MySQL external replica.
D
Use the mysqldump utility and binary logs.