Cloning instances

This page explains cloning, and describes how to clone an instance.

When you clone a Cloud SQL instance, you create a new instance that is a copy of the source instance, but is completely independent. After cloning is complete, changes to the source instance are not reflected in the clone, and changes in the clone are not reflected in the source instance.

The source instance configuration (activation policy, database flags, connectivity, and so on) is copied to the clone. Instance IP addresses are not copied; you must configure these items explicitly on the clone. Cloning an instance does not clone any existing backups.

You can clone an instance that was cloned from another instance.

Cloning an instance

Console

  1. Go to the Cloud SQL Instances page in the Google Cloud Console.

    Go to the Cloud SQL Instances page

  2. Find the row of the instance to clone. At the right end of the row, click the More Actions menu.
  3. Click Create clone.
  4. On the Create a clone page, update the instance ID if needed, and click Create clone.

    You are returned to the instance listing page while the clone initializes.

gcloud

Clone the instance:

gcloud sql instances clone [SOURCE_INSTANCE_NAME] [TARGET_INSTANCE_NAME]

REST v1beta4

Clone the instance.

Before using any of the request data below, make the following replacements:

  • project-id: The project ID
  • source-instance-id: The source instance ID
  • target-instance-id: The target instance ID

HTTP method and URL:

POST https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone

Request JSON body:

{
  "cloneContext":
  {
    "destinationInstanceName": "target-instance-id"
  }
}

To send your request, expand one of these options:

You should receive a JSON response similar to the following: