You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
A.
Export the data from the existing database, and load the data into a new Cloud SQL database.
B.
Use Migrate for Compute Engine to complete the migration.
C.
Use Datastream to complete the migration.
D.
Use Database Migration Service to complete the migration.
D.
The key is minimal downtime. That eliminates A. Migrate for Compute Engine operates at the VM level. That eliminates B. Migrating from a GCE VM to Cloud SQL is a classic use case for the Database Migration Service. D is the best answer.
A: Export the data from the existing database, and load the data into a new Cloud SQL database.
For a standard export from Cloud SQL, the export is run while the database is online. When the data being exported is smaller, the impact is likely to be minimal. However, when there are large databases, or large objects, such as BLOBs in the database, there's the possibility that the export might degrade database performance. This might impact the time it takes to perform database queries and operations against the database. After you start an export, it's not possible to stop it if your database starts to respond slowly.
There are three main approaches to database migration: big bang data migration, trickle data migration, and zero downtime migration.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chelbsik
Highly Voted 1 year, 10 months agoPKookNN
Most Recent 9 months, 2 weeks agoCloudKida
1 year, 4 months agodynamic_dba
1 year, 7 months agopk349
1 year, 10 months ago