VeloDB Cloud
Management Guide
Connections

Connections

Private Link

Private Link can help you securely and stably access services deployed in other VPCs through a private network in VPC environments, greatly simplifying network architecture and avoiding security risks associated with accessing services through the public network.

The VeloDB Cloud warehouse is created and run in the VeloDB VPC, and application systems or clients within the user's VPC can access the VeloDB Cloud warehouse across VPC via Private Link. Private Link includes two parts: endpoint service and endpoint.

When the user needs to access VeloDB in their own private network, VeloDB Cloud will create and manage the endpoint service, and the user creates and manages the endpoint.

When the user needs to use VeloDB to access their own private network, they need to create an endpoint service and register it in VeloDB Cloud. Subsequently, VeloDB Cloud will create an endpoint to connect to the user's endpoint service.

Access VeloDB from Your VPC

Access VeloDB from Your VPC

Creating a connection to allow your data applications, such as reporting, profiling, and log analytics, within your private network to access the VeloDB Cloud warehouse.

Note There is no additional fee on the VeloDB Cloud service side, but users need to pay the cloud platform for endpoint instances and traffic fees.

AWS

  1. Switch to the target warehouse, click Connections on the navigation bar, and click New Connection to Access VeloDB from Your VPC on the Private Link tab to create an endpoint. Firstly, you need to allow a principal to access the endpoint service of VeloDB Cloud warehouse.

Note If you specify to allow an ARN for principal of IAM user or IAM role, only the principal of the IAM user or IAM role has permission to access the endpoint service, and the permission will not be passed to AWS Account.

  1. After allowing a principal to access the endpoint service, the page displays the Endpoint Service information required for creating an endpoint. You can click Go to Create to go to the cloud platform's Private Link product console and create an endpoint.

  1. On the cloud platform's Private Link product console, you need to confirm that the current region is the same as the warehouse's endpoint service (limited by the cloud platform's Private Link product) and click Create endpoint.

Note You need to sign in to AWS with the principal that has been allowed to access the endpoint service of VeloDB Cloud, so that you can successfully pass the service name verification when creating the endpoint.

  1. Follow the wizard prompts to fill in the form as follows:

ParameterDescription
Name tagOptional. Creates a tag with a key of 'Name' and a value that you specify.
Service categoryRequired. Select the service category. The endpoint service of the VeloDB Cloud warehouse belongs to Other endpoint services, so click to select it.
Service nameRequired. One-click shortcut to copy the Service Name of the endpoint service of VeloDB Cloud warehouse in the page that displays the Endpoint Service information required for creating an endpoint, fill in the input box and click Verify service .
VPCRequired. Select the VPC in which to create your endpoint.
SubnetsRequired. Select the same Availability Zone as the one where the endpoint service of the VeloDB Cloud warehouse is located (limited by the cloud vendor's Private Link product), and then select an appropriate subnet ID under it.
Security groupsRequired. Select a preset security group. Note that the security rules should allow the protocol and port used by the VeloDB Cloud warehouse, as well as the IP address of the source where the application/client connects to the VeloDB Cloud warehouse.
TagsOptional. You can add tags associated with the resource.
  1. After the endpoint is created, its status will be changed from " Pending " to " Available ", indicating that the endpoint has successfully connected with the warehouse's endpoint service.

  1. After refreshing the Connections page of the VeloDB Cloud warehouse, the endpoint list will display the connection information of the endpoint.

Note You need to click Find DNS Name to open the Endpoint Details page of AWS Private Link product console, find the DNS Name of the endpoint and use it to access the VeloDB Cloud warehouse.

  1. The application/client can access the VeloDB Cloud warehouse through the DNS name of the endpoint by MySQL protocol or HTTP protocol. For the specific connection method, refer to the pop-up bubble for Connection Examples .

Note

  • VeloDB Cloud includes two independent account systems: One is used to connect to the warehouse, as described in this topic. The other one is used to log into the console, which is described in the Registration and Login topic.

  • For first-time connection, please use the admin username and its password which can be initialized or reset on the Settings page.

Azure

  1. Switch to the target warehouse, click Connections on the navigation bar, and click New Connection to Access VeloDB from Your VPC on the Private Link tab to create an endpoint. Firstly, you need to approve a subscription to access the endpoint service of VeloDB Cloud warehouse.

  1. After approving a subscription to access the endpoint service, the page displays the Endpoint Service information required for creating an endpoint. You can click Go to Create to go to the cloud platform's Private Link product console and create an endpoint.

  1. In the Basics tab of the Create a private endpoint page on the cloud platform's Private Link product console, you need to confirm that the current region is the same as the endpoint service of VeloDB Cloud warehouse (limited by the cloud platform's Private Link product). Follow the wizard prompts to fill in the form as follows and click Next: Resource.

ParameterCategoryDescription
SubscriptionProject detailsRequired. Select the subscription to access the endpoint service of VeloDB Cloud warehouse. All resources in an Azure subscription are billed together.
Resource groupProject detailsRequired. Select a resource group for the private endpoint to be created in it. If there is no suitable one, you can create a new one. A resource group is a collection of resources that share the same lifecycle, permissions, and policies.
NameInstance detailsRequired. The instance name of the private endpoint to be created. You can customize it.
Network Interface NameInstance detailsRequired. The network interface name of the private endpoint to be created. When you enter the instance name, it will be automatically generated and you can modify it.
RegionInstance details"Required. Select the region for the private endpoint to be created in it. Note: You need to select the region is the same as the endpoint service of VeloDB Cloud warehouse (limited by the cloud platform's Private Link product)."
  1. In the Resource tab of the Create a private endpoint page, choose the connection method Connect to an Azure resource with a resource ID or alias and fill in the form as follows and click Next: Virtual Network.

ParameterDescription
Resource ID or aliasRequired. When connecting to someone else's resource, they must provide you with the resource ID or alias for that resource in order for you to initiate a connection request. In the current scene, you can one-click shortcut to copy the Service Alias value of the endpoint service of VeloDB Cloud warehouse in the page that displays the Endpoint Service information required for creating an endpoint, then fill in the input box.
Request messageOptional. This message will be sent to the resource owner (This refers to VeloDB Cloud.) to assist them in the connection management process. Don't include private or sensitive information.
  1. In the Virtual Network tab of the Create a private endpoint page, Select the virtual network and subnet for the private endpoint to be created in it. Follow the wizard prompts to fill in the form as follows and click Next: DNS.

ParameterCategoryDescription
Virtual networkNetworkingRequired. Only virtual networks in the currently selected subscription and location are listed. Select the virtual network for the private endpoint to be created in it. If there is no suitable one, you can create a new one on the cloud platform's Virtual network product console.
SubnetNetworkingRequired. Only subnets in the currently selected virtual network are listed. Select a subnet for the private endpoint to be created in it. If there is no suitable one, you can create a new one on the cloud platform's Virtual network product console.
Network policy for private endpointsNetworkingOptional. The network policy for the private endpoint to be created. The default is disabled, you can edit it.
Private IP configurationPrivate IP configurationOptional. You can choose Dynamically allocate IP address or Statically allocate IP address. According to the virtual network and subnet configured above, Dynamically allocate IP address is selected by default.
Application security groupApplication security groupOptional. Select the application security group for the private endpoint to be created. If there is no suitable one, you can create a new one.
  1. In the DNS tab of the Create a private endpoint page, Keep the default settings and click Next: Tags.

Note: To connect privately with your private endpoint, you need a DNS record. You need to configure the resource configuration to support Private DNS.

  1. In the Tags tab of the Create a private endpoint page. , Keep the default settings and click Next: Review + create.

Note: If you want to categorize the private endpoint and view consolidated billing, you can configure the tag for the private endpoint to be created.

  1. In the Review + create tab of the Create a private endpoint page, you can review the settings for the private endpoint to be created. If some settings are not as expected, you can click Previous back to modify. If there is no problem, you can click Create.

  1. After the endpoint is created, its status will be changed from "Created" to "OK", indicating that the endpoint has successfully connected with the endpoint service of VeloDB Cloud warehouse.

  1. After refreshing the Connections page of the VeloDB Cloud warehouse, the endpoint list will display the connection information of the endpoint.

  1. The application/client can access the VeloDB Cloud warehouse through the IP or DNS name of the endpoint by MySQL protocol or HTTP protocol. You can click Find DNS Name in the endpoint list to open the details page of the endpoint to find the IP or DNS name of it.

  1. For the specific connection method, you can hover the pop-up bubble for Connection Examples in the Connections page of the VeloDB Cloud warehouse.

VeloDB Accesses Your VPC

VeloDB Accesses Your VPC

Note The endpoint instance and traffic fees generated by VeloDB's access to the private network are currently not charged to users.

AWS

  1. Switch to the target warehouse, click Connections on the navigation bar, and click New Connection for VeloDB Accesses Your VPC on the Private Link tab to create a connection to your endpoint service.

  1. After clicking + Endpoint Service, the pages will display the Current Region of the warehouse and the ARN of VeloDB. You can click Go to Create to go to the cloud platform's Private Link product console and create an endpoint service.

  2. Sign in to the AWS Console, select VPC-Endpoint services and switch to the same region as the current warehouse.

  3. Click Create endpoint service.

  1. On the Endpoint Service configuration page, configure the relevant parameters and click Create.

  1. After creating the endpoint service, add the ARN of VeloDB in the Allow principals Tab of the endpoint service.

  1. Copy the Service ID and Service Name from the Endpoint Service Details page, and fill them in the Endpoint Service registration page of VeloDB Cloud.

  1. After the registration is complete, go to the next step, specify the Endpoint Name of VeloDB Cloud warehouse, and click Create Now.

  1. Refresh the page and wait for the status of the endpoint of VeloDB Cloud warehouse to be changed from "pendingAcceptance" to "available", which means the connection is successful.

Azure

  1. Switch to the target warehouse, click Connections on the navigation bar, and click New Connection for VeloDB Accesses Your VPC on the Private Link tab to create a connection to your endpoint service.

  1. After clicking + Endpoint Service, the page will display the Current Region of the warehouse and the Subscription ID of VeloDB. You can click Go to Create to go to the cloud platform's Private Link product console and create an endpoint service (This refers to Azure private link service).

  1. Sign in to the Azure portal (opens in a new tab) with your Azure account. In the Basics tab of the Create private link service page on the Private Link product console, you need to confirm that the region is the same as the VeloDB Cloud warehouse (limited by the cloud platform's Private Link product). Follow the wizard prompts to fill in the form as follows and click Next: Outbound settings.

ParameterCategoryDescription
SubscriptionProject detailsRequired. Select the subscription to create the private link service for database or datalake. All resources in an Azure subscription are billed together.
Resource groupProject detailsRequired. Select a resource group for the private link service to be created in it. If there is no suitable one, you can create a new one. A resource group is a collection of resources that share the same lifecycle, permissions, and policies.
NameInstance detailsRequired. The instance name of the private link service to be created. You can customize it.
RegionInstance detailsRequired. Select the Azure region for the private link service to be created and located in it.Note: You need to select the region is the same as the VeloDB Cloud warehouse (limited by the cloud platform's Private Link product).
  1. In the Outbound settings tab of the Create private link service page. Follow the wizard prompts to fill in the form as follows and click Next: Access Security.

ParameterDescription
Load balancerRequired. Select a load balancer behind the private link service to load balances database or datalake. If there is no suitable one, you can create a new one on the cloud platform's Load Balancer product console.
Load balancer frontend IP addressRequired. Select frontend IP address of the load balancer you selected above.
Source NAT Virtual networkRequired.
Source NAT subnetRequired.
Enable TCP proxy V2Required. Leave the default of No. If your application expects a TCP proxy v2 header, select Yes.
Private IP address settingsLeave the default settings
  1. In the Access Security tab of the Create private link service page, you need to choose Restricted by subscription for whom can request access to the private link service, and add the Subscription ID of VeloDB into the access whitelist of the private link service and choose Yes for auto-approve. Then click Next: Tags.

  1. In the Tags tab of the Create private link service page, keep the default settings and click Next: Review + create. Note: If you want to categorize the private link service and view consolidated billing, you can configure the tag for the private link service to be created.

  1. In the Review + create tab of the Create private link service page, you can review the settings for the private link service to be created. If some settings are not as expected, you can click Previous back to modify. If there is no problem, you can click Create.

  1. After the private link service is created, its status will be changed from "Created" to "OK", indicating that the private link service has ready to be connected by the private endpoint of VeloDB Cloud warehouse.

  1. After creating the private link service, copy the Rescource ID and Alias from the private link service Details page, and fill them in the Endpoint Service registration page of VeloDB Cloud.

  1. After the registration is complete, go to the next step, specify the Endpoint Name of VeloDB Cloud warehouse, and click Create Now.

  1. Refresh the page and wait for the status of the endpoint of VeloDB Cloud warehouse to be changed from "pendingAcceptance" to "Approve", which means the connection is successful.

Public Link

On the Connections page, switch to the Public Link tab to manage the public network connection.

Add IP Whitelist

In order to access the VeloDB Cloud warehouse via the public network, you need to add the source public network IP address to the whitelist.

Click IP Whitelist Management on the right of the Connect Warehouse card to add the source IP addresses or segments.

In the IP whitelist, you can add or delete IP addresses to enable or disable their access to the warehouse.

Note By default, the IP segment 0.0.0.0/0 is set, which means the warehouse is completely open to the public network. It is recommended to remove it in time after use to reduce security risks.

Access Warehouse

After adding the source public network IP address to the whitelist, you can click WebUI Login to access the VeloDB Cloud warehouse through the public network. For the specific connection method, please refer to the Other Methods.