gcloud alpha metastore services migrations start

gcloud alpha metastore services migrations start - start the migration on a Dataproc Metastore service

gcloud alpha metastore services migrations start (SERVICE : --location=LOCATION) ((--cdc-password=CDC_PASSWORD --cdc-username=CDC_USERNAME --reverse-proxy-subnet=REVERSE_PROXY_SUBNET --subnet-ip-range=SUBNET_IP_RANGE --vpc-network=VPC_NETWORK : --bucket=BUCKET --root-path=ROOT_PATH; default="/migration") (--connection-password=CONNECTION_PASSWORD --connection-username=CONNECTION_USERNAME --hive-database-name=HIVE_DATABASE_NAME --instance-connection-name=INSTANCE_CONNECTION_NAME --ip-address=IP_ADDRESS --nat-subnet=NAT_SUBNET --port=PORT --proxy-subnet=PROXY_SUBNET)) [--async] [GCLOUD_WIDE_FLAG …]

If run asynchronously with --async, exits after printing the operation name that can be used to poll the status of the migration operation via:

gcloud metastore operations describe

Service resource - The Dataproc Metastore service to start the migration on. 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 project attribute:

• provide the argument service on the command line with a fully specified name;
• provide the argument --project on the command line;
• set the property core/project.

This must be specified.

SERVICE

ID of the service or fully qualified identifier for the service.

To set the service attribute:

• provide the argument service on the command line.

This positional argument must be specified if any of the other arguments in this group are specified.

--location=LOCATION

The location of the Dataproc Metastore service.

If not specified, will use default metastore/location. To set the location attribute:

• provide the argument service on the command line with a fully specified name;
• provide the argument --location on the command line;
• set the property metastore/location.

Configuration information required by Dataproc Metastore to start the migration. This must be specified.

Configuration information specific to migrating from "Self-Managed Hive Metastore on Google Cloud Platform with Cloud SQL as the backend database" to a Dataproc Metastore service.

Configuration information required to start the Change Data Capture (CDC) streams from customer's Cloud SQL database to backend database of Dataproc Metastore. This must be specified.

--cdc-password=CDC_PASSWORD

The password for the user that Datastream service should use for the MySQL connection.

This flag argument must be specified if any of the other arguments in this group are specified.

--cdc-username=CDC_USERNAME

The username that the Datastream service should use for the MySQL connection.

This flag argument must be specified if any of the other arguments in this group are specified.

--reverse-proxy-subnet=REVERSE_PROXY_SUBNET

The URL of the subnetwork resource to create the VM instance hosting the reverse proxy in. More context in https://cloud.google.com/datastream/docs/private-connectivity#reverse-csql-proxy The subnetwork should reside in the network provided in the request that Datastream will peer to and should be in the same region as Datastream, in the following format. "projects/{project_id}/regions/{region_id}/subnetworks/{subnetwork_id}""

This flag argument must be specified if any of the other arguments in this group are specified.

--subnet-ip-range=SUBNET_IP_RANGE

A "/29" CIDR IP range for peering with datastream

This flag argument must be specified if any of the other arguments in this group are specified.

--vpc-network=VPC_NETWORK

Fully qualified name of the Cloud SQL instance's VPC network or the shared VPC network that Datastream will peer to, in the following format: "projects/{project_id}/locations/global/networks/{network_id}". More context in https://cloud.google.com/datastream/docs/network-connectivity-options#privateconnectivity

This flag argument must be specified if any of the other arguments in this group are specified.

--bucket=BUCKET

The bucket to write the intermediate stream event data in. The bucket name must be without any prefix like "gs://". This field is optional. If not set, the Artifacts Cloud Storage bucket is used.

--root-path=ROOT_PATH; default="/migration"

The root path inside the Cloud Storage bucket. The stream event data will be written to this path. The default value is "/migration".

Configuration information required for Dataproc Metastore to establish customer database connection before the cutover phase of migration. This must be specified.

--connection-password=CONNECTION_PASSWORD

The password for the user that Dataproc Metastore service should use to connect to the database.

This flag argument must be specified if any of the other arguments in this group are specified.

--connection-username=CONNECTION_USERNAME

The username that Dataproc Metastore service should use to connect to the database.

This flag argument must be specified if any of the other arguments in this group are specified.

--hive-database-name=HIVE_DATABASE_NAME

The name of the hive metastore database.

This flag argument must be specified if any of the other arguments in this group are specified.

--instance-connection-name=INSTANCE_CONNECTION_NAME

The Cloud SQL database connection name, in the format, "project_id:region:instance_name"

This flag argument must be specified if any of the other arguments in this group are specified.

--ip-address=IP_ADDRESS

The private IP address of the Cloud SQL instance.

This flag argument must be specified if any of the other arguments in this group are specified.

--nat-subnet=NAT_SUBNET

The relative resource name of the subnetwork to be used for Private Service Connect. Note that this cannot be a regular subnet and is used only for NAT. More context in https://cloud.google.com/vpc/docs/about-vpc-hosted-services#psc-subnets. This subnet is used to publish the SOCKS5 proxy service. The subnet size must be at least /29 and it should reside in a network through which the Cloud SQL instance is accessible. The resource name should be in the format, "projects/{project_id}/regions/{region_id}/subnetworks/{subnetwork_id}"

This flag argument must be specified if any of the other arguments in this group are specified.

--port=PORT

The network port of the database.

This flag argument must be specified if any of the other arguments in this group are specified.

--proxy-subnet=PROXY_SUBNET

The relative resource name of the subnetwork to deploy the SOCKS5 proxy service in. The subnetwork should reside in a network through which the Cloud SQL instance is accessible. The resource name should be in the format, "projects/{project_id}/regions/{region_id}/subnetworks/{subnetwork_id}"

This flag argument must be specified if any of the other arguments in this group are specified.

--async

Return immediately, without waiting for the operation in progress to complete.

Run $ gcloud help for details.