Front view of an IT engineer of African ethnicity sitting in a server room and using his laptop.
VMware Cloud on AWS

Running Microsoft SQL Server Big Data Clusters in Tanzu Kubernetes Grid on VMware Cloud on AWS

Despite Microsoft’s earlier announcement of SQL Server Big Data Clusters (BDC) retirement in 2025, we continue receiving customers’ interests in running SQL BDC on our VMware Tanzu Platform. VMware, Microsoft and Dell EMC already released a joint solution to run SQL BDC on Tanzu Kubernetes Grid running in an on-prem environment last August, see my previous blog posts:

Today we’ll continue to explore running SQL Server Big Data Clusters in a Tanzu Kubernetes cluster hosting on a VMware Cloud on AWS environment.

vSphere SDDC on VMware Cloud on AWS
vSphere SDDC on VMware Cloud on AWS

There are two options to deploy the Tanzu Kubernetes clusters for SQL BDC workloads running on VMware Cloud on AWS:

  • Managed by Supervisor cluster (wcp) as the management cluster. The guest workload cluster is provisioned through Tanzu Kubernetes Grid Service.
  • Managed by Tanzu Kubernetes Grid (TKGm). The guest workload cluster is provisioned through Tanzu CLI. This option is what we’ll talk about in this blog post.

Configure the Bootstrap machine on VMware Cloud on AWS

Before you deploy the Tanzu Kubernetes Grid clusters on VMware Cloud on AWS, you need to configure a bootstrap machine that used to run the Tanzu CLI and deploy the SQL BDC workloads. Here’s an Ubuntu VM created as an example.

screenshot of boostrapvm
Ubuntu Bootstrap machine

To access the bootstrap machine on VMware Cloud on AWS environment.

– Assign a public IP address in the VMware Cloud console for the bootstrap VM

screenshot requesting public IP address
Request Public IP Address

– Create a NAT rules to associate the public IP with the Internal IP (IP address for the bootstrap machine)

screenshot of creating NAT rules
Create a NAT rules for the bootstrap machine

– Modify Gateway Firewall rules to allow ssh connection to the bootstrap machine.

screenshot of allowing ssh in bootstrap

Deploy a management cluster with Tanzu CLI

Next, we’ll deploy the management cluster with Tanzu CLI. Check here to ensure you’ve installed all the necessary tools. Check out Firewall Rules for Tanzu Kubernetes Grid on VMware Cloud on AWS article to configure the firewall rules required by TKG on VMware Cloud on AWS.

Run the following command to start the installation with Web UI.

installation wizards for tanzu kubernetes grid management cluster
Installation Wizards for Tanzu Kubernetes Grid Management Cluster

Follow the steps described in Deploy Management Clusters with the Installer Interface documentation to deploy the management cluster. Here are some tips for management cluster deployment on VMware Cloud on AWS.

  • Make sure you add the bootstrap public IP address to allow inbound connection to the vCenter in the Gateway Firewall rules.
  • Make sure you assign a static IP address within your workload network for the TKG management cluster if you use kube-vip as the control plane endpoint provider.

Once the deployment is completed, run the following command to confirm.

screenshot of code text

Deploy a Tanzu Kubernetes cluster

The Tanzu Kubernetes cluster can be provisioned through a configuration yaml files. A recommended way to generate the cluster yaml file is to modify from the management-cluster yaml file, which is under the ~/.config/tanzu/tkg/clusterconfigs directory. For more details, refer to Deploy Tanzu Kubernetes Clusters to vSphere documentation. Here’s a sample Tanzu Kubernetes cluster created to host SQL BDC workloads.

screenshot of code text

Deploying SQL Server Big Data Clusters to the Tanzu Kubernetes clusters

Switch the kubectl context to the Tanzu Kubernetes cluster just deployed.

screenshot of code text

Make sure you have created a storage class for your BDC workload

vsan-default-sc.yaml

screenshot of code text

Now you are ready to deploy SQL BDC to the TKG cluster on VMware Cloud on AWS. The BDC cluster is deployed with Azure Data CLI and the deployment profile can be generated in Azure Data Studio.

To deploy the BDC cluster, run the following command.

The Deployment will take a while depending on the network. Once the deployment is completed, verify the SQL BDC endpoints using the following command:

screenshot of code text

Conclusion

In this blog post, we demonstrated how to run SQL Server Big Data Clusters in Tanzu Kubernetes Grid (TKGm) on VMware Cloud on AWS. The next blog post will continue to explore how to deploy SQL Server Big Data Clusters to Tanzu Kubernetes Grid Service (TKGs) that is managed by the Supervisor Cluster on VMware Cloud on AWS environment. Stay tuned!