- NAME
-
- gcloud alpha database-migration connection-profiles create cloudsql - create a Database Migration Service connection profile for Cloud SQL
- SYNOPSIS
-
-
gcloud alpha database-migration connection-profiles create cloudsql(CONNECTION_PROFILE:--region=REGION)--database-version=DATABASE_VERSION--source-id=SOURCE_ID--tier=TIER[--activation-policy=ACTIVATION_POLICY] [--no-async] [--authorized-networks=NETWORK,[NETWORK,…]] [--no-auto-storage-increase] [--availability-type=AVAILABILITY_TYPE] [--data-disk-size=DATA_DISK_SIZE] [--data-disk-type=DATA_DISK_TYPE] [--database-flags=[FLAG=VALUE,…]] [--display-name=DISPLAY_NAME] [--no-enable-ip-v4] [--labels=[KEY=VALUE,…]] [--private-network=PRIVATE_NETWORK] [--provider=PROVIDER] [--require-ssl] [--root-password=ROOT_PASSWORD] [--secondary-zone=SECONDARY_ZONE] [--storage-auto-resize-limit=STORAGE_AUTO_RESIZE_LIMIT] [--user-labels=[KEY=VALUE,…]] [--zone=ZONE] [GCLOUD_WIDE_FLAG …]
-
- DESCRIPTION
-
(ALPHA)Create a Database Migration Service destination connection profile for Cloud SQL. This will create a Cloud SQL replica. Used for PostgreSQL and MySQL migrations. - EXAMPLES
-
To create a connection profile for Cloud SQL with database version MySQL 5.6:
gcloud alpha database-migration connection-profiles create cloudsql my-profile --region=us-central1 --database-version=MYSQL_5_6 --source-id=cp1 --tier=db-n1-standard-1To create a connection profile for Cloud SQL and a Cloud SQL replica with database version PostgreSQL 10:
gcloud alpha database-migration connection-profiles create cloudsql my-profile --region=us-central1 --database-version=POSTGRES_10 --source-id=cp1 --tier=db-custom-1-3840 --zone=us-central1-a - POSITIONAL ARGUMENTS
-
-
Connection profile resource - The connection profile to create. The arguments in
this group can be used to specify the attributes of this resource. (NOTE) Some
attributes are not given arguments in this group but can be set in other ways.
To set the
projectattribute:-
provide the argument
connection_profileon the command line with a fully specified name; -
provide the argument
--projecton the command line; -
set the property
core/project.
This must be specified.
CONNECTION_PROFILE-
ID of the connection_profile or fully qualified identifier for the
connection_profile.
To set the
connection_profileattribute:-
provide the argument
connection_profileon the command line.
This positional argument must be specified if any of the other arguments in this group are specified.
-
provide the argument
--region=REGION-
The Cloud region for the connection_profile.
To set the
regionattribute:-
provide the argument
connection_profileon the command line with a fully specified name; -
provide the argument
--regionon the command line.
-
provide the argument
-
provide the argument
-
Connection profile resource - The connection profile to create. The arguments in
this group can be used to specify the attributes of this resource. (NOTE) Some
attributes are not given arguments in this group but can be set in other ways.
- REQUIRED FLAGS
-
--database-version=DATABASE_VERSION-
Database engine type and version.
DATABASE_VERSIONmust be one of:MYSQL_5_7,MYSQL_5_6,MYSQL_8_0,POSTGRES_9_6,POSTGRES_10,POSTGRES_11,POSTGRES_12,POSTGRES_13,POSTGRES_14,POSTGRES_15. -
Connection profile resource - Database Migration Service source connection
profile ID. This represents a Cloud resource. (NOTE) Some attributes are not
given arguments in this group but can be set in other ways.
To set the
projectattribute:-
provide the argument
--source-idon the command line with a fully specified name; -
provide the argument
--projecton the command line; -
set the property
core/project.
To set the
regionattribute:-
provide the argument
--source-idon the command line with a fully specified name; -
provide the argument
--regionon the command line.
This must be specified.
--source-id=SOURCE_ID-
ID of the connection_profile or fully qualified identifier for the
connection_profile.
To set the
connection_profileattribute:-
provide the argument
--source-idon the command line.
-
provide the argument
-
provide the argument
--tier=TIER-
Tier (or machine type) for this instance, for example:
db-n1-standard-1db-custom-1-3840
- OPTIONAL FLAGS
-
--activation-policy=ACTIVATION_POLICY-
Activation policy specifies when the instance is activated; it is applicable
only when the instance state is 'RUNNABLE'. Valid values:
ALWAYS: The instance is on, and remains so even in the absence of connection requests.
NEVER: The instance is off; it is not activated, even if a connection request arrives.
ACTIVATION_POLICYmust be one of:ALWAYS,NEVER. --no-async- Waits for the operation in progress to complete before returning.
- List of external networks that are allowed to connect to the instance. Specify values in CIDR notation, also known as 'slash' notation (e.g.192.168.100.0/24).
--auto-storage-increase-
If you enable this setting, Cloud SQL checks your available storage every 30
seconds. If the available storage falls below a threshold size, Cloud SQL
automatically adds additional storage capacity. If the available storage
repeatedly falls below the threshold size, Cloud SQL continues to add storage
until it reaches the maximum of 64 TB. Default: ON. Enabled by default, use
--no-auto-storage-increaseto disable. --availability-type=AVAILABILITY_TYPE-
Cloud SQL availability type.
AVAILABILITY_TYPEmust be one of:REGIONAL,ZONAL. --data-disk-size=DATA_DISK_SIZE- Storage capacity available to the database, in GB. The minimum (and default) size is 10GB.
--data-disk-type=DATA_DISK_TYPE-
Type of storage.
DATA_DISK_TYPEmust be one of:PD_SSD,PD_HDD. --database-flags=[FLAG=VALUE,…]-
Comma-separated list of database flags to set on the instance. Use an equals
sign to separate the flag name and value. Flags without values, like
skip_grant_tables, can be written out without a value, e.g.,
skip_grant_tables=. Use on/off values for booleans. View the Instance Resource API for allowed flags. (e.g.,--database-flags max_allowed_packet=55555 skip_grant_tables=,log_output=1). --display-name=DISPLAY_NAME- A user-friendly name for the connection profile. The display name can include letters, numbers, spaces, and hyphens, and must start with a letter.
--enable-ip-v4-
Whether the instance should be assigned an IPv4 address or not. Enabled by
default, use
--no-enable-ip-v4to disable. --labels=[KEY=VALUE,…]-
List of label KEY=VALUE pairs to add.
Keys must start with a lowercase character and contain only hyphens (
-), underscores (_), lowercase characters, and numbers. Values must contain only hyphens (-), underscores (_), lowercase characters, and numbers. --private-network=PRIVATE_NETWORK- Resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, /projects/myProject/global/networks/default. This setting can be updated, but it cannot be removed after it is set.
--provider=PROVIDER-
Database provider, for managed databases.
PROVIDERmust be one of:RDS,CLOUDSQL. --require-ssl- Whether SSL connections over IP should be enforced or not.
--root-password=ROOT_PASSWORD- Root Cloud SQL user's password.
--secondary-zone=SECONDARY_ZONE- Google Cloud Platform zone where the failover Cloud SQL database instance is located. Used when the Cloud SQL database availability type is REGIONAL (i.e. multiple zones / highly available).
--storage-auto-resize-limit=STORAGE_AUTO_RESIZE_LIMIT- Maximum size to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
--user-labels=[KEY=VALUE,…]- The resource labels for a Cloud SQL instance to use to annotate any related underlying resources such as Compute Engine VMs. An object containing a list of "key": "value" pairs.
--zone=ZONE- Google Cloud Platform zone where your Cloud SQL database instance is located.
- 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
$ gcloud helpfor details. - NOTES
-
This command is currently in alpha and might change without notice. If this
command fails with API permission errors despite specifying the correct project,
you might be trying to access an API with an invitation-only early access
allowlist. This variant is also available:
gcloud database-migration connection-profiles create cloudsql
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 2024-02-06 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]