File: //snap/google-cloud-cli/current/help/man/man1/gcloud_beta_sql_instances_create.1
.TH "GCLOUD_BETA_SQL_INSTANCES_CREATE" 1
.SH "NAME"
.HP
gcloud beta sql instances create \- creates a new Cloud SQL instance
.SH "SYNOPSIS"
.HP
\f5gcloud beta sql instances create\fR \fIINSTANCE\fR [\fB\-\-activation\-policy\fR=\fIACTIVATION_POLICY\fR] [\fB\-\-active\-directory\-dns\-servers\fR=[\fIDNS_SERVER_IP_ADDRESS\fR,...]] [\fB\-\-active\-directory\-domain\fR=\fIACTIVE_DIRECTORY_DOMAIN\fR] [\fB\-\-active\-directory\-mode\fR=\fIACTIVE_DIRECTORY_MODE\fR] [\fB\-\-active\-directory\-organizational\-unit\fR=\fIACTIVE_DIRECTORY_ORGANIZATIONAL_UNIT\fR] [\fB\-\-active\-directory\-secret\-manager\-key\fR=\fIACTIVE_DIRECTORY_SECRET_MANAGER_KEY\fR] [\fB\-\-allocated\-ip\-range\-name\fR=\fIALLOCATED_IP_RANGE_NAME\fR] [\fB\-\-[no\-]assign\-ip\fR] [\fB\-\-async\fR] [\fB\-\-audit\-bucket\-path\fR=\fIAUDIT_BUCKET_PATH\fR] [\fB\-\-audit\-retention\-interval\fR=\fIAUDIT_RETENTION_INTERVAL\fR] [\fB\-\-audit\-upload\-interval\fR=\fIAUDIT_UPLOAD_INTERVAL\fR] [\fB\-\-authorized\-networks\fR=\fINETWORK\fR,[\fINETWORK\fR,...]] [\fB\-\-availability\-type\fR=\fIAVAILABILITY_TYPE\fR] [\fB\-\-no\-backup\fR] [\fB\-\-backup\-location\fR=\fIBACKUP_LOCATION\fR] [\fB\-\-backup\-start\-time\fR=\fIBACKUP_START_TIME\fR] [\fB\-\-cascadable\-replica\fR] [\fB\-\-clear\-active\-directory\-dns\-servers\fR] [\fB\-\-collation\fR=\fICOLLATION\fR] [\fB\-\-connection\-pool\-flags\fR=\fIFLAG\fR=\fIVALUE\fR,[\fIFLAG\fR=\fIVALUE\fR,...]] [\fB\-\-connector\-enforcement\fR=\fICONNECTOR_ENFORCEMENT\fR] [\fB\-\-cpu\fR=\fICPU\fR] [\fB\-\-custom\-subject\-alternative\-names\fR=\fIDNS\fR,[\fIDNS\fR,[\fIDNS\fR]]] [\fB\-\-database\-flags\fR=\fIFLAG\fR=\fIVALUE\fR,[\fIFLAG\fR=\fIVALUE\fR,...]] [\fB\-\-database\-version\fR=\fIDATABASE_VERSION\fR;\ default=\f5"MYSQL_8_0"\fR] [\fB\-\-[no\-]deletion\-protection\fR] [\fB\-\-deny\-maintenance\-period\-end\-date\fR=\fIDENY_MAINTENANCE_PERIOD_END_DATE\fR] [\fB\-\-deny\-maintenance\-period\-start\-date\fR=\fIDENY_MAINTENANCE_PERIOD_START_DATE\fR] [\fB\-\-deny\-maintenance\-period\-time\fR=\fIDENY_MAINTENANCE_PERIOD_TIME\fR] [\fB\-\-edition\fR=\fIEDITION\fR] [\fB\-\-enable\-auto\-upgrade\-minor\-version\fR] [\fB\-\-enable\-bin\-log\fR] [\fB\-\-[no\-]enable\-connection\-pooling\fR] [\fB\-\-[no\-]enable\-data\-cache\fR] [\fB\-\-[no\-]enable\-dataplex\-integration\fR] [\fB\-\-[no\-]enable\-google\-ml\-integration\fR] [\fB\-\-enable\-google\-private\-path\fR] [\fB\-\-enable\-password\-policy\fR] [\fB\-\-enable\-point\-in\-time\-recovery\fR] [\fB\-\-enforce\-new\-sql\-network\-architecture\fR] [\fB\-\-failover\-replica\-name\fR=\fIFAILOVER_REPLICA_NAME\fR] [\fB\-\-[no\-]final\-backup\fR] [\fB\-\-final\-backup\-retention\-days\fR=\fIFINAL_BACKUP_RETENTION_DAYS\fR] [\fB\-\-[no\-]insights\-config\-query\-insights\-enabled\fR] [\fB\-\-insights\-config\-query\-plans\-per\-minute\fR=\fIINSIGHTS_CONFIG_QUERY_PLANS_PER_MINUTE\fR] [\fB\-\-insights\-config\-query\-string\-length\fR=\fIINSIGHTS_CONFIG_QUERY_STRING_LENGTH\fR] [\fB\-\-[no\-]insights\-config\-record\-application\-tags\fR] [\fB\-\-[no\-]insights\-config\-record\-client\-address\fR] [\fB\-\-instance\-type\fR=\fIINSTANCE_TYPE\fR] [\fB\-\-labels\fR=[\fIKEY\fR=\fIVALUE\fR,...]] [\fB\-\-maintenance\-release\-channel\fR=\fIMAINTENANCE_RELEASE_CHANNEL\fR] [\fB\-\-maintenance\-window\-day\fR=\fIMAINTENANCE_WINDOW_DAY\fR] [\fB\-\-maintenance\-window\-hour\fR=\fIMAINTENANCE_WINDOW_HOUR\fR] [\fB\-\-master\-instance\-name\fR=\fIMASTER_INSTANCE_NAME\fR] [\fB\-\-memory\fR=\fIMEMORY\fR] [\fB\-\-network\fR=\fINETWORK\fR] [\fB\-\-node\-count\fR=\fINODE_COUNT\fR] [\fB\-\-password\-policy\-complexity\fR=\fIPASSWORD_POLICY_COMPLEXITY\fR] [\fB\-\-[no\-]password\-policy\-disallow\-username\-substring\fR] [\fB\-\-password\-policy\-min\-length\fR=\fIPASSWORD_POLICY_MIN_LENGTH\fR] [\fB\-\-password\-policy\-password\-change\-interval\fR=\fIPASSWORD_POLICY_PASSWORD_CHANGE_INTERVAL\fR] [\fB\-\-password\-policy\-reuse\-interval\fR=\fIPASSWORD_POLICY_REUSE_INTERVAL\fR] [\fB\-\-psc\-auto\-connections\fR=[\fInetwork\fR=\fINETWORK\fR],[\fIproject\fR=\fIPROJECT\fR]] [\fB\-\-[no\-]recreate\-replicas\-on\-primary\-crash\fR] [\fB\-\-replica\-type\fR=\fIREPLICA_TYPE\fR] [\fB\-\-replication\fR=\fIREPLICATION\fR] [\fB\-\-replication\-lag\-max\-seconds\-for\-recreate\fR=\fIREPLICATION_LAG_MAX_SECONDS_FOR_RECREATE\fR] [\fB\-\-require\-ssl\fR] [\fB\-\-[no\-]retain\-backups\-on\-delete\fR] [\fB\-\-retained\-backups\-count\fR=\fIRETAINED_BACKUPS_COUNT\fR] [\fB\-\-retained\-transaction\-log\-days\fR=\fIRETAINED_TRANSACTION_LOG_DAYS\fR] [\fB\-\-root\-password\fR=\fIROOT_PASSWORD\fR] [\fB\-\-server\-ca\-mode\fR=\fISERVER_CA_MODE\fR] [\fB\-\-server\-ca\-pool\fR=\fISERVER_CA_POOL\fR] [\fB\-\-ssl\-mode\fR=\fISSL_MODE\fR] [\fB\-\-[no\-]storage\-auto\-increase\fR] [\fB\-\-storage\-auto\-increase\-limit\fR=\fISTORAGE_AUTO_INCREASE_LIMIT\fR] [\fB\-\-storage\-provisioned\-iops\fR=\fISTORAGE_PROVISIONED_IOPS\fR] [\fB\-\-storage\-provisioned\-throughput\fR=\fISTORAGE_PROVISIONED_THROUGHPUT\fR] [\fB\-\-storage\-size\fR=\fISTORAGE_SIZE\fR] [\fB\-\-storage\-type\fR=\fISTORAGE_TYPE\fR] [\fB\-\-tags\fR=\fITAG\fR=\fIVALUE\fR,[\fITAG\fR=\fIVALUE\fR,...]] [\fB\-\-threads\-per\-core\fR=\fITHREADS_PER_CORE\fR] [\fB\-\-tier\fR=\fITIER\fR,\ \fB\-t\fR\ \fITIER\fR] [\fB\-\-time\-zone\fR=\fITIME_ZONE\fR] [\fB\-\-timeout\fR=\fITIMEOUT\fR;\ default=3600] [\fB\-\-allowed\-psc\-projects\fR=\fIPROJECT\fR,[\fIPROJECT\fR,...]\ \fB\-\-enable\-private\-service\-connect\fR] [\fB\-\-disk\-encryption\-key\fR=\fIDISK_ENCRYPTION_KEY\fR\ :\ \fB\-\-disk\-encryption\-key\-keyring\fR=\fIDISK_ENCRYPTION_KEY_KEYRING\fR\ \fB\-\-disk\-encryption\-key\-location\fR=\fIDISK_ENCRYPTION_KEY_LOCATION\fR\ \fB\-\-disk\-encryption\-key\-project\fR=\fIDISK_ENCRYPTION_KEY_PROJECT\fR] [\fB\-\-master\-dump\-file\-path\fR=\fIMASTER_DUMP_FILE_PATH\fR\ \fB\-\-master\-username\fR=\fIMASTER_USERNAME\fR\ :\ [\fB\-\-master\-ca\-certificate\-path\fR=\fIMASTER_CA_CERTIFICATE_PATH\fR\ :\ \fB\-\-client\-certificate\-path\fR=\fICLIENT_CERTIFICATE_PATH\fR\ \fB\-\-client\-key\-path\fR=\fICLIENT_KEY_PATH\fR]\ \fB\-\-master\-password\fR=\fIMASTER_PASSWORD\fR\ |\ \fB\-\-prompt\-for\-master\-password\fR] [\fB\-\-[no\-]auto\-scale\-disable\-scale\-in\fR\ \fB\-\-[no\-]auto\-scale\-enabled\fR\ \fB\-\-auto\-scale\-in\-cooldown\-seconds\fR=\fIAUTO_SCALE_IN_COOLDOWN_SECONDS\fR\ \fB\-\-auto\-scale\-max\-node\-count\fR=\fIAUTO_SCALE_MAX_NODE_COUNT\fR\ \fB\-\-auto\-scale\-min\-node\-count\fR=\fIAUTO_SCALE_MIN_NODE_COUNT\fR\ \fB\-\-auto\-scale\-out\-cooldown\-seconds\fR=\fIAUTO_SCALE_OUT_COOLDOWN_SECONDS\fR\ \fB\-\-auto\-scale\-target\-metrics\fR=[\fIMETRIC\fR=\fIVALUE\fR,...]] [\fB\-\-region\fR=\fIREGION\fR;\ default="us\-central"\ |\ \fB\-\-gce\-zone\fR=\fIGCE_ZONE\fR\ |\ \fB\-\-secondary\-zone\fR=\fISECONDARY_ZONE\fR\ \fB\-\-zone\fR=\fIZONE\fR] [\fB\-\-source\-ip\-address\fR=\fISOURCE_IP_ADDRESS\fR\ :\ \fB\-\-source\-port\fR=\fISOURCE_PORT\fR;\ default=3306] [\fIGCLOUD_WIDE_FLAG\ ...\fR]
.SH "DESCRIPTION"
\fB(BETA)\fR Creates a new Cloud SQL instance.
.SH "EXAMPLES"
To create a MySQL 8.0 instance with ID \f5\fIprod\-instance\fR\fR that has 2
CPUs, 4 GB of RAM, and is in the region \f5\fIus\-central1\fR\fR (a zone will be
auto\-assigned), where the 'root' user has its password set to
\f5\fIpassword123\fR\fR, run:
.RS 2m
$ gcloud beta sql instances create prod\-instance \e
\-\-database\-version=MYSQL_8_0 \-\-cpu=2 \-\-memory=4GB \e
\-\-region=us\-central1 \-\-root\-password=password123
.RE
To create a Postgres 15 instance with ID \f5\fIprod\-instance\fR\fR that has 2
CPUs, 8 GiB of RAM, and is in the zone \f5\fIus\-central1\-a\fR\fR, where the
\'postgres' user has its password set to \f5\fIpassword123\fR\fR, run:
.RS 2m
$ gcloud beta sql instances create prod\-instance \e
\-\-database\-version=POSTGRES_15 \-\-cpu=2 \-\-memory=8GiB \e
\-\-zone=us\-central1\-a \-\-root\-password=password123
.RE
To create a SQL Server 2022 Express instance with ID \f5\fIprod\-instance\fR\fR
that has 2 CPUs, 3840MiB of RAM, and is in the zone \f5\fIus\-central1\-a\fR\fR,
where the 'sqlserver' user has its password set to \f5\fIpassword123\fR\fR, run:
.RS 2m
$ gcloud beta sql instances create prod\-instance \e
\-\-database\-version=SQLSERVER_2022_EXPRESS \-\-cpu=2 \e
\-\-memory=3840MiB \-\-zone=us\-central1\-a \e
\-\-root\-password=password123
.RE
.SH "POSITIONAL ARGUMENTS"
.RS 2m
.TP 2m
\fIINSTANCE\fR
Cloud SQL instance ID.
.RE
.sp
.SH "FLAGS"
.RS 2m
.TP 2m
\fB\-\-activation\-policy\fR=\fIACTIVATION_POLICY\fR
Activation policy for this instance. This specifies when the instance should be
activated and is applicable only when the instance state is \f5RUNNABLE\fR. The
default is \f5always\fR. More information on activation policies can be found
here:
https://cloud.google.com/sql/docs/mysql/start\-stop\-restart\-instance#activation_policy.
\fIACTIVATION_POLICY\fR must be one of: \fBalways\fR, \fBnever\fR.
.TP 2m
\fB\-\-active\-directory\-dns\-servers\fR=[\fIDNS_SERVER_IP_ADDRESS\fR,...]
A comma\-separated list of the DNS servers to be used for Active Directory. Only
available for SQL Server instances. E.g: 10.0.0.1,10.0.0.2
.TP 2m
\fB\-\-active\-directory\-domain\fR=\fIACTIVE_DIRECTORY_DOMAIN\fR
Managed Service for Microsoft Active Directory domain this instance is joined
to. Only available for SQL Server instances.
.TP 2m
\fB\-\-active\-directory\-mode\fR=\fIACTIVE_DIRECTORY_MODE\fR
Defines the Active Directory mode. Only available for SQL Server instances.
\fIACTIVE_DIRECTORY_MODE\fR must be one of: \fBMANAGED_ACTIVE_DIRECTORY\fR,
\fBCUSTOMER_MANAGED_ACTIVE_DIRECTORY\fR.
.TP 2m
\fB\-\-active\-directory\-organizational\-unit\fR=\fIACTIVE_DIRECTORY_ORGANIZATIONAL_UNIT\fR
Defines the organizational unit to be used for Active Directory. Only available
for SQL Server instances. E.g: OU=Cloud,DC=ad,DC=example,DC=com
.TP 2m
\fB\-\-active\-directory\-secret\-manager\-key\fR=\fIACTIVE_DIRECTORY_SECRET_MANAGER_KEY\fR
The secret manager key storing administrator credentials. Only available for SQL
Server instances.
.TP 2m
\fB\-\-allocated\-ip\-range\-name\fR=\fIALLOCATED_IP_RANGE_NAME\fR
The name of the IP range allocated for a Cloud SQL instance with private network
connectivity. For example: 'google\-managed\-services\-default'. If set, the
instance IP is created in the allocated range represented by this name.
.TP 2m
\fB\-\-[no\-]assign\-ip\fR
Assign a public IP address to the instance. This is a public, externally
available IPv4 address that you can use to connect to your instance when
properly authorized. Use \fB\-\-assign\-ip\fR to enable and
\fB\-\-no\-assign\-ip\fR to disable.
.TP 2m
\fB\-\-async\fR
Return immediately, without waiting for the operation in progress to complete.
.TP 2m
\fB\-\-audit\-bucket\-path\fR=\fIAUDIT_BUCKET_PATH\fR
The location, as a Cloud Storage bucket, to which audit files are uploaded. The
URI is in the form gs://bucketName/folderName. Only available for SQL Server
instances.
.TP 2m
\fB\-\-audit\-retention\-interval\fR=\fIAUDIT_RETENTION_INTERVAL\fR
The number of days for audit log retention on disk, for example, 3dfor 3 days.
Only available for SQL Server instances.
.TP 2m
\fB\-\-audit\-upload\-interval\fR=\fIAUDIT_UPLOAD_INTERVAL\fR
How often to upload audit logs (audit files), for example, 30mfor 30 minutes.
Only available for SQL Server instances.
.TP 2m
\fB\-\-authorized\-networks\fR=\fINETWORK\fR,[\fINETWORK\fR,...]
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).
.TP 2m
\fB\-\-availability\-type\fR=\fIAVAILABILITY_TYPE\fR
Specifies level of availability. \fIAVAILABILITY_TYPE\fR must be one of:
.RS 2m
.TP 2m
\fBregional\fR
Provides high availability and is recommended for production instances; instance
automatically fails over to another zone within your selected region.
.TP 2m
\fBzonal\fR
Provides no failover capability. This is the default.
.RE
.sp
.TP 2m
\fB\-\-backup\fR
Enables daily backup. Enabled by default, use \fB\-\-no\-backup\fR to disable.
.TP 2m
\fB\-\-backup\-location\fR=\fIBACKUP_LOCATION\fR
Choose where to store your backups. Backups are stored in the closest
multi\-region location to you by default. Only customize if needed.
.TP 2m
\fB\-\-backup\-start\-time\fR=\fIBACKUP_START_TIME\fR
Start time of daily backups, specified in the HH:MM format, in the UTC timezone.
.TP 2m
\fB\-\-cascadable\-replica\fR
Specifies whether a SQL Server replica is a cascadable replica. A cascadable
replica is a SQL Server cross\-region replica that supports replica(s) under it.
This flag only takes effect when the \f5\-\-master\-instance\-name\fR flag is
set, and the replica under creation is in a different region than the primary
instance.
.TP 2m
\fB\-\-clear\-active\-directory\-dns\-servers\fR
Removes the list of DNS Servers from the Active Directory Config.
.TP 2m
\fB\-\-collation\fR=\fICOLLATION\fR
Cloud SQL server\-level collation setting, which specifies the set of rules for
comparing characters in a character set.
.TP 2m
\fB\-\-connection\-pool\-flags\fR=\fIFLAG\fR=\fIVALUE\fR,[\fIFLAG\fR=\fIVALUE\fR,...]
Comma\-separated list of connection pool flags to set on the instance connection
pool. Use an equals sign to separate flag name and value. More information on
available flags can be found here:
https://cloud.google.com/sql/docs/mysql/managed\-connection\-pooling#configuration\-options
for MySQL and
https://cloud.google.com/sql/docs/postgres/managed\-connection\-pooling#configuration\-options
for PostgreSQL. (e.g., \f5\-\-connection\-pool\-flags
max_pool_size=1000,max_client_connections=20\fR)
.TP 2m
\fB\-\-connector\-enforcement\fR=\fICONNECTOR_ENFORCEMENT\fR
Cloud SQL Connector enforcement mode. It determines how Cloud SQL Connectors are
used in the connection. See the list of modes here
(https://cloud.google.com/sql/docs/mysql/admin\-api/rest/v1beta4/instances#connectorenforcement).
\fICONNECTOR_ENFORCEMENT\fR must be one of:
.RS 2m
.TP 2m
\fBCONNECTOR_ENFORCEMENT_UNSPECIFIED\fR
The requirement for Cloud SQL connectors is unknown.
.TP 2m
\fBNOT_REQUIRED\fR
Does not require Cloud SQL connectors.
.TP 2m
\fBREQUIRED\fR
Requires all connections to use Cloud SQL connectors, including the Cloud SQL
Auth Proxy and Cloud SQL Java, Python, and Go connectors. Note: This disables
all existing authorized networks.
.RE
.sp
.TP 2m
\fB\-\-cpu\fR=\fICPU\fR
Whole number value indicating how many cores are desired in the machine. Both
\-\-cpu and \-\-memory must be specified if a custom machine type is desired,
and the \-\-tier flag must be omitted.\-\-cpu and \-\-memory flags are not
compatible with the Enterprise Plus edition. These flags should not be used when
creating an Enterprise Plus edition, as the machine configuration is determined
by the \-\-tier flag instead.
.TP 2m
\fB\-\-custom\-subject\-alternative\-names\fR=\fIDNS\fR,[\fIDNS\fR,[\fIDNS\fR]]
A comma\-separated list of DNS names to add to the instance's SSL certificate. A
custom SAN is a structured way to add additional DNS names (host names) that are
not managed by Cloud SQL to an instance. It allows for hostname verification
during establishment of a database connection using the DNS name over SSL/TLS.
When you create and/or update an instance, you can add a comma\-separated list
of up to three DNS names to the server certificate of your instance.
.TP 2m
\fB\-\-database\-flags\fR=\fIFLAG\fR=\fIVALUE\fR,[\fIFLAG\fR=\fIVALUE\fR,...]
Comma\-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.,
\f5skip_grant_tables=\fR. Use on/off for booleans. View the Instance Resource
API for allowed flags. (e.g., \f5\-\-database\-flags
max_allowed_packet=55555,skip_grant_tables=,log_output=1\fR)
.TP 2m
\fB\-\-database\-version\fR=\fIDATABASE_VERSION\fR; default=\f5"MYSQL_8_0"\fR
The database engine type and versions. If left unspecified, MYSQL_8_0 is used.
See the list of database versions at
https://cloud.google.com/sql/docs/mysql/admin\-api/rest/v1beta4/SqlDatabaseVersion.
.TP 2m
\fB\-\-[no\-]deletion\-protection\fR
Enable deletion protection on a Cloud SQL instance. Use
\fB\-\-deletion\-protection\fR to enable and \fB\-\-no\-deletion\-protection\fR
to disable.
.TP 2m
\fB\-\-deny\-maintenance\-period\-end\-date\fR=\fIDENY_MAINTENANCE_PERIOD_END_DATE\fR
Date when the deny maintenance period ends, that is \f5\fI2021\-01\-10\fR\fR.
.TP 2m
\fB\-\-deny\-maintenance\-period\-start\-date\fR=\fIDENY_MAINTENANCE_PERIOD_START_DATE\fR
Date when the deny maintenance period begins, that is \f5\fI2020\-11\-01\fR\fR.
.TP 2m
\fB\-\-deny\-maintenance\-period\-time\fR=\fIDENY_MAINTENANCE_PERIOD_TIME\fR
Time when the deny maintenance period starts or ends, that is
\f5\fI05:00:00\fR\fR.
.TP 2m
\fB\-\-edition\fR=\fIEDITION\fR
Specifies the edition of Cloud SQL instance. \fIEDITION\fR must be one of:
\fBenterprise\fR, \fBenterprise\-plus\fR.
.TP 2m
\fB\-\-enable\-auto\-upgrade\-minor\-version\fR
Enables auto\-upgrade for MySQL 8.0 minor versions. The MySQL version must be
8.0.35 or higher.
.TP 2m
\fB\-\-enable\-bin\-log\fR
Allows for data recovery from a specific point in time, down to a fraction of a
second. Must have automatic backups enabled to use. Make sure storage can
support at least 7 days of logs.
.TP 2m
\fB\-\-[no\-]enable\-connection\-pooling\fR
Enable connection pooling for the instance. Use
\fB\-\-enable\-connection\-pooling\fR to enable and
\fB\-\-no\-enable\-connection\-pooling\fR to disable.
.TP 2m
\fB\-\-[no\-]enable\-data\-cache\fR
Enable use of data cache for accelerated read performance. This flag is only
available for Enterprise_Plus edition instances. Use
\fB\-\-enable\-data\-cache\fR to enable and \fB\-\-no\-enable\-data\-cache\fR to
disable.
.TP 2m
\fB\-\-[no\-]enable\-dataplex\-integration\fR
Enable Dataplex integration for Google Cloud SQL. Use
\fB\-\-enable\-dataplex\-integration\fR to enable and
\fB\-\-no\-enable\-dataplex\-integration\fR to disable.
.TP 2m
\fB\-\-[no\-]enable\-google\-ml\-integration\fR
Enable Vertex AI integration for Google Cloud SQL. You can integrate Vertex AI
with Cloud SQL for MySQL and Cloud SQL for PostgreSQL instances only. Use
\fB\-\-enable\-google\-ml\-integration\fR to enable and
\fB\-\-no\-enable\-google\-ml\-integration\fR to disable.
.TP 2m
\fB\-\-enable\-google\-private\-path\fR
Enable a private path for Google Cloud services. This flag specifies whether the
instance is accessible to internal Google Cloud services such as BigQuery. This
is only applicable to MySQL and PostgreSQL instances that don't use public IP.
Currently, SQL Server isn't supported.
.TP 2m
\fB\-\-enable\-password\-policy\fR
Enable the password policy, which enforces user password management with the
policies configured for the instance. This flag is only available for Postgres.
.TP 2m
\fB\-\-enable\-point\-in\-time\-recovery\fR
Allows for data recovery from a specific point in time, down to a fraction of a
second, via write\-ahead logs. Must have automatic backups enabled to use. Make
sure storage can support at least 7 days of logs.
.TP 2m
\fB\-\-enforce\-new\-sql\-network\-architecture\fR
Force the instance to use the new network architecture.
.TP 2m
\fB\-\-failover\-replica\-name\fR=\fIFAILOVER_REPLICA_NAME\fR
Also create a failover replica with the specified name.
.TP 2m
\fB\-\-[no\-]final\-backup\fR
Enables the final backup to be taken at the time of instance deletion. Use
\fB\-\-final\-backup\fR to enable and \fB\-\-no\-final\-backup\fR to disable.
.TP 2m
\fB\-\-final\-backup\-retention\-days\fR=\fIFINAL_BACKUP_RETENTION_DAYS\fR
Specifies number of days to retain final backup. The valid range is between 1
and 365. For instances managed by BackupDR, the valid range is between 1 day and
99 years. Default value is 30 days.
.TP 2m
\fB\-\-[no\-]insights\-config\-query\-insights\-enabled\fR
Enable query insights feature to provide query and query plan analytics.
Use \fB\-\-insights\-config\-query\-insights\-enabled\fR to enable and
\fB\-\-no\-insights\-config\-query\-insights\-enabled\fR to disable.
.TP 2m
\fB\-\-insights\-config\-query\-plans\-per\-minute\fR=\fIINSIGHTS_CONFIG_QUERY_PLANS_PER_MINUTE\fR
Number of query plans to sample every minute. Default value is 5. Allowed range:
0 to 20.
.TP 2m
\fB\-\-insights\-config\-query\-string\-length\fR=\fIINSIGHTS_CONFIG_QUERY_STRING_LENGTH\fR
Sets the default query length limit. For Cloud SQL Enterprise edition, the range
is from 256 to 4500 (in bytes) and the default query length is 1024 bytes. For
Cloud SQL Enterprise Plus edition, the range is from 1024 to 100,000 (in bytes)
and the default query length is 10,000 bytes.
.TP 2m
\fB\-\-[no\-]insights\-config\-record\-application\-tags\fR
Allow application tags to be recorded by the query insights feature.
Use \fB\-\-insights\-config\-record\-application\-tags\fR to enable and
\fB\-\-no\-insights\-config\-record\-application\-tags\fR to disable.
.TP 2m
\fB\-\-[no\-]insights\-config\-record\-client\-address\fR
Allow the client address to be recorded by the query insights feature.
Use \fB\-\-insights\-config\-record\-client\-address\fR to enable and
\fB\-\-no\-insights\-config\-record\-client\-address\fR to disable.
.TP 2m
\fB\-\-instance\-type\fR=\fIINSTANCE_TYPE\fR
The type of the instance. \fIINSTANCE_TYPE\fR must be one of:
.RS 2m
.TP 2m
\fBCLOUD_SQL_INSTANCE\fR
A primary instance.
.TP 2m
\fBREAD_POOL_INSTANCE\fR
A read pool instance.
.TP 2m
\fBREAD_REPLICA_INSTANCE\fR
A read replica instance.
.RE
.sp
.TP 2m
\fB\-\-labels\fR=[\fIKEY\fR=\fIVALUE\fR,...]
List of label KEY=VALUE pairs to add.
Keys must start with a lowercase character and contain only hyphens (\f5\-\fR),
underscores (\f5_\fR), lowercase characters, and numbers. Values must contain
only hyphens (\f5\-\fR), underscores (\f5_\fR), lowercase characters, and
numbers.
.TP 2m
\fB\-\-maintenance\-release\-channel\fR=\fIMAINTENANCE_RELEASE_CHANNEL\fR
Which channel's updates to apply during the maintenance window. If not
specified, Cloud SQL chooses the timing of updates to your instance.
\fIMAINTENANCE_RELEASE_CHANNEL\fR must be one of:
.RS 2m
.TP 2m
\fBpreview\fR
Preview updates release prior to production updates. You may wish to use the
preview channel for dev/test applications so that you can preview their
compatibility with your application prior to the production release.
.TP 2m
\fBproduction\fR
Production updates are stable and recommended for applications in production.
.TP 2m
\fBweek5\fR
week5 updates release after the production updates. Use the week5 channel to
receive a 5 week advance notification about the upcoming maintenance, so you can
prepare your application for the release.
.RE
.sp
.TP 2m
\fB\-\-maintenance\-window\-day\fR=\fIMAINTENANCE_WINDOW_DAY\fR
Day of week for maintenance window, in UTC time zone.
\fIMAINTENANCE_WINDOW_DAY\fR must be one of: \fBSUN\fR, \fBMON\fR, \fBTUE\fR,
\fBWED\fR, \fBTHU\fR, \fBFRI\fR, \fBSAT\fR.
.TP 2m
\fB\-\-maintenance\-window\-hour\fR=\fIMAINTENANCE_WINDOW_HOUR\fR
Hour of day for maintenance window, in UTC time zone.
.TP 2m
\fB\-\-master\-instance\-name\fR=\fIMASTER_INSTANCE_NAME\fR
Name of the instance which will act as master in the replication setup. The
newly created instance will be a read replica of the specified master instance.
.TP 2m
\fB\-\-memory\fR=\fIMEMORY\fR
Whole number value indicating how much memory is desired in the machine. A size
unit should be provided (eg. 3072MiB or 9GiB) \- if no units are specified, GiB
is assumed. Both \-\-cpu and \-\-memory must be specified if a custom machine
type is desired, and the \-\-tier flag must be omitted. \-\-cpu and \-\-memory
flags are not compatible with the Enterprise Plus edition. These flags should
not be used when creating an Enterprise Plus edition, as the machine
configuration is determined by the \-\-tier flag instead.
.TP 2m
\fB\-\-network\fR=\fINETWORK\fR
Network in the current project that the instance will be part of. To specify
using a network with a shared VPC, use the full URL of the network. For an
example host project, 'testproject', and shared network, 'testsharednetwork',
this would use the form:
\f5\-\-network\fR=\f5projects/testproject/global/networks/testsharednetwork\fR
.TP 2m
\fB\-\-node\-count\fR=\fINODE_COUNT\fR
The number of nodes in the pool. This option is only available for read pools.
.TP 2m
\fB\-\-password\-policy\-complexity\fR=\fIPASSWORD_POLICY_COMPLEXITY\fR
The complexity of the password. This flag is available only for PostgreSQL.
\fIPASSWORD_POLICY_COMPLEXITY\fR must be one of:
.RS 2m
.TP 2m
\fBCOMPLEXITY_DEFAULT\fR
A combination of lowercase, uppercase, numeric, and non\-alphanumeric
characters.
.TP 2m
\fBCOMPLEXITY_UNSPECIFIED\fR
The default value if COMPLEXITY_DEFAULT is not specified. It implies that
complexity check is not enabled.
.RE
.sp
.TP 2m
\fB\-\-[no\-]password\-policy\-disallow\-username\-substring\fR
Disallow username as a part of the password. Use
\fB\-\-password\-policy\-disallow\-username\-substring\fR to enable and
\fB\-\-no\-password\-policy\-disallow\-username\-substring\fR to disable.
.TP 2m
\fB\-\-password\-policy\-min\-length\fR=\fIPASSWORD_POLICY_MIN_LENGTH\fR
Minimum number of characters allowed in the password.
.TP 2m
\fB\-\-password\-policy\-password\-change\-interval\fR=\fIPASSWORD_POLICY_PASSWORD_CHANGE_INTERVAL\fR
Minimum interval after which the password can be changed, for example, 2m for 2
minutes. See <a href="/sdk/gcloud/reference/topic/datetimes"> $ gcloud topic
datetimes</a> for information on duration formats. This flag is available only
for PostgreSQL.
.TP 2m
\fB\-\-password\-policy\-reuse\-interval\fR=\fIPASSWORD_POLICY_REUSE_INTERVAL\fR
Number of previous passwords that cannot be reused. The valid range is 0 to 100.
.TP 2m
\fB\-\-psc\-auto\-connections\fR=[\fInetwork\fR=\fINETWORK\fR],[\fIproject\fR=\fIPROJECT\fR]
A comma\-separated list of networks or network\-project pairs. Each project is
represented by a project number (numeric) or by a project ID (alphanumeric).
This allows Private Service Connect connections to be created automatically for
the specified networks. For example, this connection uses "the form
\f5psc\-auto\-connections\fR=\f5network=projects/testproject1/global/networks/testnetwork1\fR"
or "the form
\f5psc\-auto\-connections\fR=\f5project=testproject1,network=projects/testproject1/global/networks/testnetwork1\fR".
Sets \f5psc_auto_connections\fR value.
.RS 2m
.TP 2m
\fBnetwork\fR
Required, sets \f5network\fR value.
.TP 2m
\fBproject\fR
Sets \f5project\fR value.
.RE
.sp
\fBShorthand Example:\fR
.RS 2m
\-\-psc\-auto\-connections=network=string,project=string
.RE
\fBJSON Example:\fR
.RS 2m
\-\-psc\-auto\-connections='{"network": "string", "project": "string"}'
.RE
\fBFile Example:\fR
.RS 2m
\-\-psc\-auto\-connections=path_to_file.(yaml|json)
.RE
.TP 2m
\fB\-\-[no\-]recreate\-replicas\-on\-primary\-crash\fR
Allow/Disallow replica recreation when a primary MySQL instance operating in
reduced durability mode crashes. Not recreating the replicas might lead to data
inconsistencies between the primary and its replicas. This setting is only
applicable for MySQL instances and is enabled by default. Use
\fB\-\-recreate\-replicas\-on\-primary\-crash\fR to enable and
\fB\-\-no\-recreate\-replicas\-on\-primary\-crash\fR to disable.
.TP 2m
\fB\-\-replica\-type\fR=\fIREPLICA_TYPE\fR
The type of replica to create. \fIREPLICA_TYPE\fR must be one of: \fBREAD\fR,
\fBFAILOVER\fR.
.TP 2m
\fB\-\-replication\fR=\fIREPLICATION\fR
Type of replication this instance uses. The default is synchronous.
\fIREPLICATION\fR must be one of: \fBsynchronous\fR, \fBasynchronous\fR.
.TP 2m
\fB\-\-replication\-lag\-max\-seconds\-for\-recreate\fR=\fIREPLICATION_LAG_MAX_SECONDS_FOR_RECREATE\fR
Set a maximum replication lag for a MySQL read replica in seconds. If the
replica lag exceeds the specified value, the readreplica(s) will be recreated.
Min value=300 seconds,Max value=31536000 seconds, default value=31536000
seconds.
.TP 2m
\fB\-\-require\-ssl\fR
Specified if users connecting over IP must use SSL.
.TP 2m
\fB\-\-[no\-]retain\-backups\-on\-delete\fR
Retain automated/ondemand backups of the instance after the instance is deleted.
Use \fB\-\-retain\-backups\-on\-delete\fR to enable and
\fB\-\-no\-retain\-backups\-on\-delete\fR to disable.
.TP 2m
\fB\-\-retained\-backups\-count\fR=\fIRETAINED_BACKUPS_COUNT\fR
How many backups to keep. The valid range is between 1 and 365. Default value is
7 for Enterprise edition instances. For Enterprise_Plus, default value is 15.
Applicable only if \-\-no\-backups is not specified.
.TP 2m
\fB\-\-retained\-transaction\-log\-days\fR=\fIRETAINED_TRANSACTION_LOG_DAYS\fR
How many days of transaction logs to keep. The valid range is between 1 and 35.
Only use this option when point\-in\-time recovery is enabled. If logs are
stored on disk, storage size for transaction logs could increase when the number
of days for log retention increases. For Enterprise, default and max retention
values are 7 and 7 respectively. For Enterprise_Plus, default and max retention
values are 14 and 35.
.TP 2m
\fB\-\-root\-password\fR=\fIROOT_PASSWORD\fR
Root Cloud SQL user's password.
.TP 2m
\fB\-\-server\-ca\-mode\fR=\fISERVER_CA_MODE\fR
Set the server CA mode of the instance. \fISERVER_CA_MODE\fR must be one of:
.RS 2m
.TP 2m
\fBCUSTOMER_MANAGED_CAS_CA\fR
Customer\-managed CA hosted on Google Cloud's Certificate Authority Service
(CAS).
.TP 2m
\fBGOOGLE_MANAGED_CAS_CA\fR
Google\-managed regional CA part of root CA hierarchy hosted on Google Cloud's
Certificate Authority Service (CAS).
.TP 2m
\fBGOOGLE_MANAGED_INTERNAL_CA\fR
Google\-managed self\-signed internal CA.
.RE
.sp
.TP 2m
\fB\-\-server\-ca\-pool\fR=\fISERVER_CA_POOL\fR
Set the server CA pool of the instance.
.TP 2m
\fB\-\-ssl\-mode\fR=\fISSL_MODE\fR
Set the SSL mode of the instance. \fISSL_MODE\fR must be one of:
.RS 2m
.TP 2m
\fBALLOW_UNENCRYPTED_AND_ENCRYPTED\fR
Allow non\-SSL and SSL connections. For SSL connections, client certificate will
not be verified.
.TP 2m
\fBENCRYPTED_ONLY\fR
Only allow connections encrypted with SSL/TLS.
.TP 2m
\fBTRUSTED_CLIENT_CERTIFICATE_REQUIRED\fR
Only allow connections encrypted with SSL/TLS and with valid client
certificates.
.RE
.sp
.TP 2m
\fB\-\-[no\-]storage\-auto\-increase\fR
Storage size can be increased, but it cannot be decreased; storage increases are
permanent for the life of the instance. With this setting enabled, a spike in
storage requirements can result in permanently increased storage costs for your
instance. However, if an instance runs out of available space, it can result in
the instance going offline, dropping existing connections. This setting is
enabled by default. Use \fB\-\-storage\-auto\-increase\fR to enable and
\fB\-\-no\-storage\-auto\-increase\fR to disable.
.TP 2m
\fB\-\-storage\-auto\-increase\-limit\fR=\fISTORAGE_AUTO_INCREASE_LIMIT\fR
Allows you to set a maximum storage capacity, in GB. Automatic increases to your
capacity will stop once this limit has been reached. Default capacity is
\fBunlimited\fR.
.TP 2m
\fB\-\-storage\-provisioned\-iops\fR=\fISTORAGE_PROVISIONED_IOPS\fR
Indicates how many IOPS to provision for the data disk. This sets the number of
I/O operations per second that the disk can handle.
.TP 2m
\fB\-\-storage\-provisioned\-throughput\fR=\fISTORAGE_PROVISIONED_THROUGHPUT\fR
Indicates how much throughput to provision for the data disk. This sets the
throughput in MB per second that the disk can handle.
.TP 2m
\fB\-\-storage\-size\fR=\fISTORAGE_SIZE\fR
Amount of storage allocated to the instance. Must be an integer number of GB.
The default is 10GB. Information on storage limits can be found here:
https://cloud.google.com/sql/docs/quotas#storage_limits
.TP 2m
\fB\-\-storage\-type\fR=\fISTORAGE_TYPE\fR
The storage type for the instance. The default is SSD. \fISTORAGE_TYPE\fR must
be one of: \fBSSD\fR, \fBHDD\fR, \fBHYPERDISK_BALANCED\fR.
.TP 2m
\fB\-\-tags\fR=\fITAG\fR=\fIVALUE\fR,[\fITAG\fR=\fIVALUE\fR,...]
Comma\-separated list of tags to set on the instance. Use an equals signto
separate tag name and value.(e.g., \f5\-\-tags tag1:value1,tag2=value2\fR)
.TP 2m
\fB\-\-threads\-per\-core\fR=\fITHREADS_PER_CORE\fR
The number of threads per core. The value of this flag can be 1 or 2. To disable
SMT, set this flag to 1. Only available in Cloud SQL for SQL Server instances.
.TP 2m
\fB\-\-tier\fR=\fITIER\fR, \fB\-t\fR \fITIER\fR
Machine type for a shared\-core instance e.g. \f5\fIdb\-g1\-small\fR\fR. For all
other instances, instead of using tiers, customize your instance by specifying
its CPU and memory. You can do so with the \f5\-\-cpu\fR and \f5\-\-memory\fR
flags. Learn more about how CPU and memory affects pricing:
https://cloud.google.com/sql/pricing.
.TP 2m
\fB\-\-time\-zone\fR=\fITIME_ZONE\fR
Set a non\-default time zone. Only available for SQL Server instances.
.TP 2m
\fB\-\-timeout\fR=\fITIMEOUT\fR; default=3600
Time to synchronously wait for the operation to complete, after which the
operation continues asynchronously. Ignored if \-\-async flag is specified. By
default, set to 3600s. To wait indefinitely, set to \fBunlimited\fR.
.TP 2m
\fB\-\-allowed\-psc\-projects\fR=\fIPROJECT\fR,[\fIPROJECT\fR,...]
A comma\-separated list of projects. Each project in this list might be
represented by a project number (numeric) or by a project ID (alphanumeric).
This allows Private Service Connect connections to be established from specified
consumer projects.
.TP 2m
\fB\-\-enable\-private\-service\-connect\fR
Enable connecting to the Cloud SQL instance with Private Service Connect.
.TP 2m
Key resource \- The Cloud KMS (Key Management Service) cryptokey that will be
used to protect the instance. The 'Compute Engine Service Agent' service account
must hold permission 'Cloud KMS CryptoKey Encrypter/Decrypter'. The arguments in
this group can be used to specify the attributes of this resource.
.RS 2m
.TP 2m
\fB\-\-disk\-encryption\-key\fR=\fIDISK_ENCRYPTION_KEY\fR
ID of the key or fully qualified identifier for the key.
To set the \f5kms\-key\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\fR on the command line.
.RE
.sp
This flag argument must be specified if any of the other arguments in this group
are specified.
.TP 2m
\fB\-\-disk\-encryption\-key\-keyring\fR=\fIDISK_ENCRYPTION_KEY_KEYRING\fR
The KMS keyring of the key.
To set the \f5kms\-keyring\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\fR on the command line with a
fully specified name;
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\-keyring\fR on the command
line.
.RE
.sp
.TP 2m
\fB\-\-disk\-encryption\-key\-location\fR=\fIDISK_ENCRYPTION_KEY_LOCATION\fR
The Google Cloud location for the key.
To set the \f5kms\-location\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\fR on the command line with a
fully specified name;
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\-location\fR on the command
line.
.RE
.sp
.TP 2m
\fB\-\-disk\-encryption\-key\-project\fR=\fIDISK_ENCRYPTION_KEY_PROJECT\fR
The Google Cloud project for the key.
To set the \f5kms\-project\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\fR on the command line with a
fully specified name;
.IP "\(bu" 2m
provide the argument \f5\-\-disk\-encryption\-key\-project\fR on the command
line;
.IP "\(bu" 2m
set the property \f5core/project\fR.
.RE
.sp
.RE
.sp
.TP 2m
Options for creating an internal replica of an external data source.
.RS 2m
.TP 2m
\fB\-\-master\-dump\-file\-path\fR=\fIMASTER_DUMP_FILE_PATH\fR
Path to the MySQL dump file in Google Cloud Storage from which the seed import
is made. The URI is in the form gs://bucketName/fileName. Compressed gzip files
(.gz) are also supported.
This flag argument must be specified if any of the other arguments in this group
are specified.
.TP 2m
\fB\-\-master\-username\fR=\fIMASTER_USERNAME\fR
Name of the replication user on the external data source.
This flag argument must be specified if any of the other arguments in this group
are specified.
.TP 2m
Client and server credentials.
.RS 2m
.TP 2m
\fB\-\-master\-ca\-certificate\-path\fR=\fIMASTER_CA_CERTIFICATE_PATH\fR
Path to a file containing the X.509v3 (RFC5280) PEM encoded certificate of the
CA that signed the external data source's certificate.
This flag argument must be specified if any of the other arguments in this group
are specified.
.TP 2m
Client credentials.
.RS 2m
.TP 2m
\fB\-\-client\-certificate\-path\fR=\fICLIENT_CERTIFICATE_PATH\fR
Path to a file containing the X.509v3 (RFC5280) PEM encoded certificate that
will be used by the replica to authenticate against the external data source.
This flag argument must be specified if any of the other arguments in this group
are specified.
.TP 2m
\fB\-\-client\-key\-path\fR=\fICLIENT_KEY_PATH\fR
Path to a file containing the unencrypted PKCS#1 or PKCS#8 PEM encoded private
key associated with the clientCertificate.
This flag argument must be specified if any of the other arguments in this group
are specified.
.RE
.RE
.sp
.TP 2m
Password group.
At most one of these can be specified:
.RS 2m
.TP 2m
\fB\-\-master\-password\fR=\fIMASTER_PASSWORD\fR
Password of the replication user on the external data source.
.TP 2m
\fB\-\-prompt\-for\-master\-password\fR
Prompt for the password of the replication user on the external data source. The
password is all typed characters up to but not including the RETURN or ENTER
key.
.RE
.RE
.sp
.TP 2m
Options for configuring read pool auto scale.
.RS 2m
.TP 2m
\fB\-\-[no\-]auto\-scale\-disable\-scale\-in\fR
Disables automatic read pool scale\-in. When disabled, read pool auto scaling
only supports increasing the read pool node count. By default, both automatic
read pool scale\-in and scale\-out are enabled. Use
\fB\-\-auto\-scale\-disable\-scale\-in\fR to enable and
\fB\-\-no\-auto\-scale\-disable\-scale\-in\fR to disable.
.TP 2m
\fB\-\-[no\-]auto\-scale\-enabled\fR
Enables read pool auto scaling. Supports automatically increasing and decreasing
the read pool's node count based on need. Use \fB\-\-auto\-scale\-enabled\fR to
enable and \fB\-\-no\-auto\-scale\-enabled\fR to disable.
.TP 2m
\fB\-\-auto\-scale\-in\-cooldown\-seconds\fR=\fIAUTO_SCALE_IN_COOLDOWN_SECONDS\fR
The cooldown period for automatic read pool scale\-in. Minimum time between
scale\-in events. Must be an integer value. For example, if the value is 60,
then a scale\-in event will not be triggered within 60 seconds of the last
scale\-in event.
.TP 2m
\fB\-\-auto\-scale\-max\-node\-count\fR=\fIAUTO_SCALE_MAX_NODE_COUNT\fR
Maximum number of read pool nodes to be maintained.
.TP 2m
\fB\-\-auto\-scale\-min\-node\-count\fR=\fIAUTO_SCALE_MIN_NODE_COUNT\fR
Minimum number of read pool nodes to be maintained.
.TP 2m
\fB\-\-auto\-scale\-out\-cooldown\-seconds\fR=\fIAUTO_SCALE_OUT_COOLDOWN_SECONDS\fR
The cooldown period for automatic read pool scale\-out. Minimum time between
scale\-out events. Must be an integer value. For example, if the value is 60,
then a scale\-out event will not be triggered within 60 seconds of the last
scale\-out event.
.TP 2m
\fB\-\-auto\-scale\-target\-metrics\fR=[\fIMETRIC\fR=\fIVALUE\fR,...]
Target metrics for read pool auto scaling. Options are: AVERAGE_CPU_UTILIZATION
and AVERAGE_DB_CONNECTIONS. Example:
\-\-auto\-scale\-target\-metrics=AVERAGE_CPU_UTILIZATION=0.8
.RE
.sp
.TP 2m
At most one of these can be specified:
.RS 2m
.TP 2m
\fB\-\-region\fR=\fIREGION\fR; default="us\-central"
Regional location (e.g. asia\-east1, us\-east1). See the full list of regions at
https://cloud.google.com/sql/docs/instance\-locations.
.TP 2m
At most one of these can be specified:
.RS 2m
.TP 2m
\fB\-\-gce\-zone\fR=\fIGCE_ZONE\fR
(DEPRECATED) Preferred Compute Engine zone (e.g. us\-central1\-a,
us\-central1\-b, etc.).
Flag \f5\-\-gce\-zone\fR is deprecated and will be removed by release 255.0.0.
Use \f5\-\-zone\fR instead.
.TP 2m
\fB\-\-secondary\-zone\fR=\fISECONDARY_ZONE\fR
Preferred secondary Compute Engine zone (e.g. us\-central1\-a, us\-central1\-b,
etc.).
.TP 2m
\fB\-\-zone\fR=\fIZONE\fR
Preferred Compute Engine zone (e.g. us\-central1\-a, us\-central1\-b, etc.).
.RE
.RE
.sp
.TP 2m
Options for creating a wrapper for an external data source.
.RS 2m
.TP 2m
\fB\-\-source\-ip\-address\fR=\fISOURCE_IP_ADDRESS\fR
Public IP address used to connect to and replicate from the external data
source.
This flag argument must be specified if any of the other arguments in this group
are specified.
.TP 2m
\fB\-\-source\-port\fR=\fISOURCE_PORT\fR; default=3306
Port number used to connect to and replicate from the external data source.
.RE
.RE
.sp
.SH "GCLOUD WIDE FLAGS"
These flags are available to all commands: \-\-access\-token\-file, \-\-account,
\-\-billing\-project, \-\-configuration, \-\-flags\-file, \-\-flatten,
\-\-format, \-\-help, \-\-impersonate\-service\-account, \-\-log\-http,
\-\-project, \-\-quiet, \-\-trace\-token, \-\-user\-output\-enabled,
\-\-verbosity.
Run \fB$ gcloud help\fR for details.
.SH "NOTES"
This command is currently in beta and might change without notice. These
variants are also available:
.RS 2m
$ gcloud sql instances create
.RE
.RS 2m
$ gcloud alpha sql instances create
.RE