Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sql/docs/mysql/migrate-data-to-cloud-sql-instance below:

About data migration in Cloud SQL | Cloud SQL for MySQL

Stay organized with collections Save and categorize content based on your preferences.

This page describes data migration options in Cloud SQL.

To migrate data from an external server into Cloud SQL, you can use Database Migration Service.

When you use Database Migration Service, you can create the destination Cloud SQL instance when you create a migration job. Database Migration Service uses migration jobs to migrate data from your source database instance to the destination Cloud SQL instance. For more information, see Create a migration job to a new destination instance.

However, you might want to create your destination Cloud SQL instance outside of Database Migration Service. For example, you can use Terraform or other Infrastructure-As-Code (IaC) tools. In that case, after creating the Cloud SQL instance, you can still use Database Migration Service to migrate data to it. For more information, see Create a migration job to an existing destination instance.

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.

• Migrating data to a Cloud SQL instance that either has Private Service Connect enabled or already contains data isn't supported. Migrating data to an instance that has a read replica requires that the GTID_MODE on the source instance is set to ON.
• 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.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-14 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-14 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4