Some or all of the information on this page might not apply to Cloud de Confiance by S3NS. See Differences from Google Cloud for more details.

About data migration in Cloud SQL

MySQL | PostgreSQL | SQL Server

This page describes data migration options in Cloud SQL.

Replicate from an external server

Another option for migrating data from an external server into Cloud SQL is to use replication. Cloud SQL supports various replication modes to migrate data into your instance.

For more information, see About replicating from an external server.

To set up Cloud SQL for data migration by using replication, see Configure Cloud SQL and the external server for replication.

Cloud SQL for MySQL also supports the migration of external MySQL databases from Percona XtraBackup physical files. By using physical files to set up replication instead of logical dump files, you can migrate your external MySQL databases into Cloud SQL for MySQL instances up to 3 times faster than using logical dump files in a parallel migration and up to 10 times faster than using logical dump files in a single-threaded migration.

For more information, see Migrate to Cloud SQL from an XtraBackup physical file.

Limitations

If your instance has customized backup settings (for example, a custom backup location), then after you promote the instance, we recommend that you customize your backup settings again. During the promotion process, Cloud SQL resets your backup settings to their default values.