QuestionQ92

VerifiedMigrate data solutions

You must perform a one-time migration of data from an active Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices that minimize performance impact on the running instance. What should you do?

Explanation

For a one-time export, Cloud SQL serverless export creates a separate temporary instance that performs the export, allowing the primary instance to continue serving queries and operating at its usual performance rate. The resulting SQL dump is stored in Cloud Storage and can be imported into the new Cloud SQL for MySQL instance.

Learn more

Community Discussion

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