VeloDB Cloud
Management Guide
GCP

How to create BYOC Warehouse on GCP

Preparations

Since resources in BYOC mode are deployed in your cloud account, you need to do some preparatory work before using to ensure smooth resource configuration and management:

Create a BYOC Warehouse on GCP

Create warehouse configuration

On the warehouse creation guide page or the warehouse list in the upper left corner, click New Warehouse to enter the warehouse configuration page and fill in the form to create it.

Fill in the following information to start creating warehouse.

ParameterDescription
Warehouse NameRequired. Unique within the organization, no more than 32 characters in length, supports English letters, Chinese, numbers, -, _, and the combination of them.
Warehouse ModeSelect BYOC
Cloud PlatformSelect GCP
RegionSelect the region where you want to deploy your data warehouse. Because the remote communication network architecture is complex and the delay is large, it is recommended to choose the same region as your application system/client. Currently, VeloDB Cloud already supports multiple regions of the cloud platform, and will continue to support more regions based on customer needs.
Core VersionVeloDB Core 2.0 and the later versions support the separation of storage and computing. Storage is billed based on actual usage, and there is no need to pre-configure storage space.
VPCWhen you create a new BYOC warehouse for the first time, the "New VPC" is selected by default. The subsequent steps will guide you to select the VPC in the cloud environment to complete the new warehouse creation.
If you have created a BYOC warehouse in a VPC before, you can directly select this VPC and create a new warehouse.

This table lists the GCP Regions and Availability Zones where VeloDB Cloud BYOC Warehouse can be deployed

Cloud PlatformRegion NameRegion IDAvailability Zone ID
GCPUS West 1us-west1all
GCPUS East 4us-east4all

Click the "Next" button to proceed to the next step.

GCP preparation

Before officially creating, please refer to the document to complete the following preparation:

Click Done to proceed to the next step.

Cloud resource configuration

Copy the command and Click "Open CloudShell".

To deploy VeloDB Cloud BYOC warehouse in Google Cloud, select your project correctly, then paste the command and execute.

Fill in the following information to execute shell.

ParametersDescription
VPC nameThe VPC name created in the previous step
Subnet nameThe Subnet name created in the previous step
Zone IDThe availability zone where you want to deploy your warehouse(optional)

Wait for the script to complete, then return to the velodb page, and wait for the "Warehouse Initialization" step to complete.

Once Warehouse Initialization is complete, VeloDB Cloud will establish a connection with the BYOC warehouse. Subsequently, you can enter the warehouse and create clusters.

Warehouse initialization

The system will initialize the warehouse, which takes about 5-10 minutes. If the warehouse initialization takes more than 30 minutes, or other situations that cannot be continued, please Get Help.

Create a new cluster

On the new cluster page or cluster overview page, click Create a new cluster to enter the cluster configuration page. For detailed operations, please refer to Create a new cluster.

Open public network connection and access

Reserve External IP Address

1. Copy Master Private IP

Go to VeloDB Cloud (opens in a new tab), Click Connect and copy Master IP.

Enter GCP VM Instances (opens in a new tab), Search the IP above.

Enter the instance and confirm VPC.

2. Reserve External IP Address

Enter GCP IP Address (opens in a new tab), Click RESERVE EXTERNAL STATIC IP ADDRESS.

Input Name. Select Premium for Network Service Tier. Select IPv4 for IP version. Select Regional for Type.

Select Region where your byoc warehouse is. Attach to the instance above where master ip is corresponding.

Click RESERVE.

Create Firewall Policy

Enter GCP Firewall Policy (opens in a new tab) . Click Create Firewall Policy.

Enter Policy name. Select Global for Deployment scope. Click CONTINUE.

Click CREATE FIREWALL RULE. Input Priority. Select Ingress for Direction of traffic. Select Allow for Action on match.

Select Apply to all for Target. Select IPv4 for IP type. Input 0.0.0.0/0 or pulic IP you want to access the warehouse.

Select Specified protocols and ports for Protocols and ports.

Select TCP and input 8080,8088,9030. Click CREATE.

Check the rule you just created. Click CONTINUE.

Click ASSOCIATE. Check the VPC where your byoc warehouse is. Click ASSOCIATE.

Click Create.

Return to the VeloDB Cloud connection page and click the Master IP public network refresh icon.

At this point, you can access the WebUI and connect to the warehouse through the public network.

Warehouse Usage

For warehouse usage operations and if you need to delete a warehouse, please refer to the document Warehouse Usage.