Google Cloud Platform
Hide
Google Cloud SQL
Write Feedback

Editing Instances

After you create an instance, you can edit the instance at any time to change its settings. For example, you might want to change the backup window or the billing plan of the instance as your application needs change. For all instance settings except instance size (tier), Google Cloud SQL applies the change immediately. For changes to the instance size, Google Cloud SQL automatically starts and stops the instance for a few moments to make the change. During this time, applications will not be able to connect to the instance. This is typically not a problem for applications designed to deal with temporary disruptions to database connectivity.

To edit general instance settings:

Developers Console

  1. Go to the Google Developers Console and select a project by clicking on the project name.
  2. In the sidebar on the left, click Storage > Cloud SQL to show a list of Cloud SQL instances for the project.
  3. Select an instance to edit by clicking the instance name.
  4. Click Edit.
  5. Make your changes to the instance settings.
    You can configure:
    • Tiers and billing plans, see Packages Billing Plan.
    • Preferred location, which can be either a Google Compute Engine zone or a Google App Engine application. When you choose a location, Google guarantees low latency between the location and your Cloud SQL instance.
    • Backups and point-in-time recovery, see Backups and Recovery.
    • Replication modes, see the FAQ.
    • Access to your instance, see Configuring Application Access Control.
    • Custom MySQL flags for your instance, see Setting MySQL Flags.
  6. Click Save to apply the changes.

Cloud SDK

  1. Install the Cloud SQL command line if you haven't already (see Managing Instances Using the Cloud SDK).
  2. Set the project to the one that contains the instance to edit. 
    $ gcloud config set project YOUR_PROJECT_ID
  3. Use the instances patch command and specify the flags for the settings you want to edit.

    For example, the following command modifies the backup start time, the pricing plan, and the tier.

    $ gcloud sql instances patch YOUR_INSTANCE_NAME \
  --backup-start-time 16:00 --pricing-plan PACKAGE --tier D2

    If the patch modifies a value that requires your instance to be restarted, you will be prompted to proceed with the change or cancel.

    For details about all the options you can specify in the instances patch command, run gcloud sql instances patch --help or see the instances patch command in the Cloud SDK documentation.

To edit access control settings:

Developers Console

  1. Go to the Google Developers Console and select a project by clicking on the project name.
  2. In the sidebar on the left, click Storage > Cloud SQL to show a list of Cloud SQL instances for the project.
  3. Select an instance to edit by clicking the instance name.
  4. Select the Access Control tab.
  5. Make your changes to the access control settings.
    From this panel, you can:

Cloud SDK

  1. If needed, set the project to the one that contains the instance to edit. 
    $ gcloud config set project YOUR_PROJECT_ID
  2. Use the instances patch command and specify the flags for the access control settings you want to edit.

    Access control setting include instance IPv4 address, authorized networks, authorized App Engine applications, and SSL configuration. For example, the following command assigns an IP address and authorizes the specified IP address range.

    $ gcloud sql instances patch YOUR_INSTANCE_NAME \
  --assign-ip --authorized-networks 192.168.100.0/24

    For details about all the options you can specify in the instances patch command, run gcloud sql instances patch --help or see the instances patch command in the Cloud SDK documentation.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License, and code samples are licensed under the Apache 2.0 License. For details, see our Site Policies.