- NAME
- gcloud-sql-instances-patch - Updates the settings of a Cloud SQL instance.
- SYNOPSIS
-
gcloud sql instances patch INSTANCE [--activation-policy ACTIVATION_POLICY] [--assign-ip] [--authorized-gae-apps AUTHORIZED_GAE_APPS [AUTHORIZED_GAE_APPS …]] [--authorized-networks AUTHORIZED_NETWORKS [AUTHORIZED_NETWORKS …]] [--backup-start-time BACKUP_START_TIME] [--clear-authorized-networks] [--clear-database-flags] [--clear-gae-apps] [--database-flags DATABASE_FLAGS [DATABASE_FLAGS …]] [--enable-bin-log] [--follow-gae-app FOLLOW_GAE_APP] [--format FORMAT] [--gce-zone GCE_ZONE] [--help] [--no-assign-ip] [--no-backup] [--no-enable-bin-log] [--no-require-ssl] [--pricing-plan PRICING_PLAN, -p PRICING_PLAN] [--project PROJECT] [--quiet, -q] [--replication REPLICATION] [--require-ssl] [--tier TIER, -t TIER] [-h]
- POSITIONAL ARGUMENTS
-
-
INSTANCE
- Cloud SQL instance ID.
-
- FLAGS
-
-
--activation-policy
ACTIVATION_POLICY
- The activation policy for this instance. This specifies when the instance should be activated and is applicable only when the instance state is RUNNABLE.
-
--assign-ip
- Specified if the instance must be assigned an IP address.
-
--authorized-gae-apps
AUTHORIZED_GAE_APPS [AUTHORIZED_GAE_APPS …]
- A list of App Engine app IDs that can access this instance.
-
--authorized-networks
AUTHORIZED_NETWORKS [AUTHORIZED_NETWORKS …]
-
The list of external networks that are allowed to connect to the instance. Specified in CIDR notation, also known as
slash
notation (e.g. 192.168.100.0/24). -
--backup-start-time
BACKUP_START_TIME
- The start time of daily backups, specified in the 24 hour format - HH:MM, in the UTC timezone.
-
--clear-authorized-networks
- Clear the list of external networks that are allowed to connect to the instance.
-
--clear-database-flags
- Clear the database flags set on the instance. WARNING: Instance will be restarted.
-
--clear-gae-apps
- Specified to clear the list of App Engine apps that can access this instance.
-
--database-flags
DATABASE_FLAGS [DATABASE_FLAGS …]
-
A space-separated list of database flags to set on the instance. Use an equals sign to separate flag name and value. Flags without values, like skip_grant_tables, can be written out without a value after, e.g.,
skip_grant_tables=
. Use on/off for booleans. View the Instance Resource API for allowed flags. (e.g.,--database-flags max_allowed_packet=55555 skip_grant_tables= log_output=1
) -
--enable-bin-log
- Specified if binary log should be enabled. If backup configuration is disabled, binary log should be disabled as well.
-
--follow-gae-app
FOLLOW_GAE_APP
- The App Engine app this instance should follow. It must be in the same region as the instance. WARNING: Instance may be restarted.
-
--format
FORMAT
- Specify a format for printed output. By default, a command-specific human-friendly output format is used. Setting this flag to one of the available options will serialize the result of the command in the chosen format and print it to stdout. Supported formats are: "json", "text", "yaml".
-
--gce-zone
GCE_ZONE
- The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b, etc.). WARNING: Instance may be restarted.
-
--help
- Display detailed help.
-
--no-assign-ip
- Specified if the assigned IP address must be revoked.
-
--no-backup
- Specified if daily backup should be disabled.
-
--no-enable-bin-log
- Specified if binary log should be disabled.
-
--no-require-ssl
-
Specified if the mysqld should not default to
REQUIRE X509
for users connecting over IP. -
--pricing-plan
PRICING_PLAN
- The pricing plan for this instance.
-
--project
PROJECT
- Google Cloud Platform project to use for this invocation.
-
--quiet
- Disable all interactive prompts when running gcloud commands. If input is required, defaults will be used, or an error will be raised.
-
--replication
REPLICATION
- The type of replication this instance uses.
-
--require-ssl
-
Specified if the mysqld should default to
REQUIRE X509
for users connecting over IP. -
--tier
TIER
- The tier of service for this instance, for example D0, D1. WARNING: Instance will be restarted.
-
-h
- Print a summary help and exit.
-
gcloud sql instances patch
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 .
Last updated August 11, 2014.