PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #9
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production…
The correct answer is A. Use Database Migration Service to migrate the databases to Cloud SQL. C. Use replication from an external server to migrate the databases to Cloud SQL. Two approaches together cover the full requirement: (A) Database Migration Service (DMS) natively supports both MySQL and PostgreSQL continuous migrations from on-premises to Cloud SQL with minimal downtime and ongoing sync - ideal given no extra backup capacity. (C)…
Question
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
Options
- AUse Database Migration Service to migrate the databases to Cloud SQL.
- BUse a cross-region read replica to migrate the databases to Cloud SQL.
- CUse replication from an external server to migrate the databases to Cloud SQL.
- DUse an external read replica to migrate the databases to Cloud SQL.
- EUse a read replica to migrate the databases to Cloud SQL.
How the community answered
(35 responses)- A77% (27)
- B3% (1)
- D6% (2)
- E14% (5)
Explanation
Two approaches together cover the full requirement: (A) Database Migration Service (DMS) natively supports both MySQL and PostgreSQL continuous migrations from on-premises to Cloud SQL with minimal downtime and ongoing sync - ideal given no extra backup capacity. (C) Replication from an external server (Cloud SQL external replica) allows MySQL databases to continuously replicate from the on-premises source to Cloud SQL, keeping the cloud instance in sync during the transition window. Cross-region read replicas (B) and standard read replicas (E) are Cloud SQL-to-Cloud SQL features and do not support on-premises sources. External read replicas (D) replicate from Cloud SQL to an external target, which is the opposite of what is needed.
Topics
Community Discussion
No community discussion yet for this question.