PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #8
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the…
The correct answer is C. Use Cloud SQL for MySQL external replica. Cloud SQL for MySQL external replica allows you to create a fully managed Cloud SQL instance that acts as a read replica of your on-premises MySQL source. This scales reads and offloads management overhead to Google Cloud without requiring you to manage the replica…
Question
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
Options
- AUse external server replication.
- BUse Data Migration Service.
- CUse Cloud SQL for MySQL external replica.
- DUse the mysqldump utility and binary logs.
How the community answered
(33 responses)- A6% (2)
- B3% (1)
- C73% (24)
- D18% (6)
Explanation
Cloud SQL for MySQL external replica allows you to create a fully managed Cloud SQL instance that acts as a read replica of your on-premises MySQL source. This scales reads and offloads management overhead to Google Cloud without requiring you to manage the replica infrastructure yourself. External server replication (A) refers to replicating FROM an external source INTO Cloud SQL - which is a migration pattern, not an ongoing replica for scaling reads. Data Migration Service (B) is a one-time migration tool, not a long-term replica solution. The mysqldump utility with binary logs (D) can set up replication manually but requires significant manual management and is not the recommended approach.
Topics
Community Discussion
No community discussion yet for this question.