Migrate data between Cloud SQL and external servers

This page describes how you can move the location of your primary instance to an external, self-managed server with a minimum of downtime.

Migrate data to an external server

To migrate the primary copy of your data from Cloud SQL to an external server with the least downtime, you set up your external server as an external replica, then demote the Cloud SQL instance to become the replica of the external server.

This procedure requires you to complete the following high-level steps:

  1. Create an external replica for your Cloud SQL instance, following the steps in Configuring External Replicas.
  2. When the replica is fully synchronized with the Cloud SQL primary, take your applications offline, and update the applications to point to the external server.
  3. Follow the instructions provided in Demoting the primary instance of an external replica to demote the Cloud SQL primary instance. Demoting the primary instance also promotes the external server, making it the new primary instance.