-
GCP Cloud SQL
Cloud SQL/ Create SQL instance gcloud sql instances create [INSTANCE_NAME] –database-version=SQLSERVER_2017_STANDARD –cpu=[NUMBER_CPUS] –memory=[MEMORY_SIZE] –root-password=[INSERT-PASSWORD-HERE] Connect to your instance Private IP: Requires additional APIs and permissions, which may require your system admin. visit the Networking page to change. Public IP: Authorize a network or use Cloud SQL Proxy to connect. Cloud SQL/ Cloud SQL Auth proxy Cloud…
-
GCP Cloud Storage
Zonal persistent disk: Efficient, reliable block storage. Regional persistent disk: Regional block storage replicated in two zones. Local SSD: High performance, transient, local block storage. Cloud Storage buckets: Affordable object storage. Filestore: High performance file storage for Google Cloud users. Creating storage buckets gsutil mb gs://BUCKET_NAME Upload from local to Cloud Storage gsutil cp -r…
-
GCP VPC – Virtual private cloud
Create a VPC Network Creating firewall-rules Configuring network tags … Create a VPC Network Given that: tdc-shared-services: The Data Center shared service project tdc-shared-vpc: The Data Center shared Virtual Private Cloud –region: Iowa, us-central1 tdc-shared-vpc-subnet: The Data Center shared Virtual Private Cloud Subnet MTU: Maximum transmission unit gcloud compute networks create tdc-shared-vpc –project=tdc-shared-services –description=The\ tdc-shared-vpc\…
-
GCP Computer Engine with gcloud-compute
The gcloud compute command group lets you create, configure, and manipulate Compute Engine virtual machine (VM) instances. Ref: https://cloud.google.com/sdk/gcloud/reference/compute List projects, regions, zones, VMs: gcloud projects list gcloud compute zones list gcloud compute regions list gcloud compute instances list Get values: gcloud config get-value project gcloud config get-value compute/zone gcloud config get-value compute/region Metadata server…
-
Cannot Import the *.bak to GCP Cloud SQL not a supported compatibility level
At the time, May 25th 2021, When performing importing the *.BAK to the GCP SQL Cloud, the SQL Cloud Instance is running SQL Server 2017 Standard. ERROR: (gcloud.sql.import.bak) [ERROR SQL SERVER EXTERNAL WARNING] 120 is not a supported compatibility level. Supported: [140, 130, 120, 110, 100] My local SQL Server 2014, version: 120 GCP SQL…
-
TCP forwarding with Identity-Aware Proxy – P2
Allows you to authenticate user TCP traffic through IAP before sending it to your VM instances. And what’s more, this also works for private VM’s without an external IP address. So no need for VPN or a bastion host! IAP for TCP forwarding gcloud compute start-iap-tunnel VM_NAME VM_PORT [–local-host-port=LOCAL_HOST_PORT; default="localhost:0"] [–zone=ZONE] [GCLOUD_WIDE_FLAG …] Example: to…
-
An overview to GCP – Google Cloud Platform – P1
The Google Cloud Platform (GCP) is a suite of cloud services that offers server space on virtual machines, internal networks, VPN connections, disk storage, machine language SaaS (Software as a Service) applications, and even something called TPU (Tensor Processing Units). To brief some keynotes while I worked with GCP, here are some tasks that using the…