QuestionQ111

VerifiedManaging implementation

You are migrating an application that uses MySQL from on-premises to Google Cloud. The application will run on Compute Engine and use Cloud SQL. You want to cut over to the Compute Engine deployment with minimal downtime and without customer data loss. You also want to migrate the application with minimal modifications and determine the cutover strategy.

What should you do?

Explanation

Cloud SQL replication from an external MySQL server is designed to migrate self-managed MySQL data to Google Cloud with minimal downtime. Keeping the Compute Engine application connected to the on-premises database while Cloud SQL replicates preserves normal writes; after replication catches up, stopping the application, promoting the Cloud SQL replica to a standalone primary, and repointing the application provides a short, controlled cutover without data loss.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!