PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #197
You have several on-premises Percona Server for MySQL 8.0 instances used for mission-critical applications. The workload is read-heavy with 80%+ reads and each instance has several TBs of data. You…
The correct answer is D. Use Database Migration Service to migrate to Cloud SQL Enterprise Plus. Since the source is Percona Server for MySQL 8.0, the closest managed equivalent in Google Cloud is Cloud SQL for MySQL. To ensure high performance and reliability for a mission-critical, read-heavy workload with multi-TB data, the correct choice is Cloud SQL Enterprise Plus…
Question
You have several on-premises Percona Server for MySQL 8.0 instances used for mission-critical applications. The workload is read-heavy with 80%+ reads and each instance has several TBs of data. You want to migrate to Google Cloud with minimal downtime and the fewest changes possible. What should you do-
Options
- AUse Database Migration Service to migrate to Alloy DB.
- BUse Datastream to migrate to Cloud SQL Enterprise
- CUse the spanner-migration-tool to migrate to Spanner.
- DUse Database Migration Service to migrate to Cloud SQL Enterprise Plus.
How the community answered
(17 responses)- A6% (1)
- C12% (2)
- D82% (14)
Explanation
Since the source is Percona Server for MySQL 8.0, the closest managed equivalent in Google Cloud is Cloud SQL for MySQL. To ensure high performance and reliability for a mission-critical, read-heavy workload with multi-TB data, the correct choice is Cloud SQL Enterprise Plus edition, which offers advanced scalability, performance, and availability features. Using Database Migration Service (DMS) provides a minimal-downtime migration path with the fewest application
Topics
Community Discussion
No community discussion yet for this question.