Upgrading your SQL Server 2019 BDC

Published On: 2020-04-06By:

If you’ve been running your SQL Server 2019 Big Data Cluster (BDC) for a while now, you probably want to patch it to the current (or a specific) build version.

Upgrading a BDC is actually fairly easy. A couple of commands will do the trick.

Before you upgrade you’ll need to know the namespace of the BDC that you are working with. I published how to get your namespace earlier. To recap, getting your list of namespaces is pretty straight forward.

az aks get-credentials --name aks-cluster --resource-group aks-resource-group

Once you have your credentials, you can request the list of namespaces.

kubectl get namespaces

From there you can use azdata to auth against the cluster. Keep in mind that this is the admin account for the cluster, not your windows or Azure AAD credentials.

azdata login

Once you have provided your namespace, username and password you can request the upgrade.

azdata bdc upgrade -n {namespace} -t latest -r mcr.microsoft.com/mssql/bdc

If you want a version of SQL Server 2019 other that the latest, change the -t value from latest to something like “2019-CU2-ubuntu-16.04”. You can see what the various tags are if you are looking for a specific build over on Microsoft Docs.

The azdata bdc upgrade command may take a while to upgrade, so be patient.

Now if you are running your BDC in aks in Azure, you’ll probably get an upgrade failure. This is because you need to upgrade the timeouts. To do this run the following command.

kubectl edit configmap controller-upgrade-configmap -n {namespace}

To run it successfully you’ll need the namespace that you used earlier.

This will open a notepad document. In that document find controllerUpgradeTimeoutInMinutes and set its value to 40. Find totalUpgradeTimeoutInMinutes and set its value to 45. Find componentUpgradeTimeoutInMinutes and set its value to 45. If the upgrade fails again, you may need to increase these values and run the upgrade again.

Denny

Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
American Business Awards Gold Award    American Business Awards Gold Award    FT Americas’ Fastest Growing Companies 2020       Best Full-Service Cloud Technology Consulting Company
   Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link