Google Professional Cloud Database Engineer
Get started today
Ultimate access to all questions.
How can you migrate a 500 GB MySQL database instance to Cloud SQL with minimal downtime while transitioning your company's highly transactional application infrastructure to Google Cloud?
How can you migrate a 500 GB MySQL database instance to Cloud SQL with minimal downtime while transitioning your company's highly transactional application infrastructure to Google Cloud?
Exam-Like
- Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL. 2. Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination. 3. Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.
- Create migration job using Database Migration Service. 2. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode. 3. Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete. 4. Update your application connections to the new instance.
A
13.0%
B
Comments
Loading comments...