Google Professional Cloud Database Engineer Question 219
Select 3Google Cloud PlatformYour company has decided to migrate an on-premises MySQL database to Google Cloud SQL. The database contains a large amount of critical data, and downtime must be kept to a minimum. You are tasked with planning the migration strategy. Which steps should you include to ensure a successful migration with minimal downtime?
- A
Use Database Migration Service (DMS) to perform a continuous data replication from the source MySQL to Cloud SQL.
- B
Export the on-premises MySQL database to a SQL dump file and import it into Cloud SQL during a scheduled maintenance window.
- C
Perform a schema conversion and validate compatibility between the source MySQL and Cloud SQL before migrating data.
- D
Develop a rollback plan that involves restoring the SQL dump file to the on-premises database in case of migration failure.
- E
Manually copy the MySQL binary files to a Cloud Storage bucket and import them into Cloud SQL.
Show answer and explanation
Correct answers: A, C, D
Explanation
To migrate a MySQL database with minimal downtime, you should use Database Migration Service (DMS) for continuous replication, which keeps the target database up to date with the source. Performing a schema conversion and compatibility validation ensures a smooth transition, while a rollback plan provides a safety net in case of migration failure. Other methods, such as exporting and importing data using SQL dump files or copying binary files, are not suitable for low-downtime migrations.
- A. Correct.
This is correct. Google Cloud's Database Migration Service (DMS) supports continuous replication, which helps minimize downtime by keeping the target database up to date with changes in the source database during the migration process.
- B. Incorrect.
This is incorrect. Exporting to a SQL dump file and importing it into Cloud SQL can result in significant downtime, especially for large databases, as this process is not suitable for low-downtime migrations.
- C. Correct.
This is correct. Performing a schema conversion and validating compatibility ensures the database structure and features are compatible with Cloud SQL, reducing the risk of errors during migration.
- D. Correct.
This is correct. A rollback plan is essential for any migration strategy to mitigate risks. Restoring the SQL dump file to the on-premises database is a common fallback approach if the migration fails.
- E. Incorrect.
This is incorrect. Manually copying MySQL binary files is not a supported method for migrating to Cloud SQL and can lead to inconsistencies and errors.