Skip to content

README.md

Latest commit

 

History

History
49 lines (39 loc) · 3.1 KB

README.md

File metadata and controls

49 lines (39 loc) · 3.1 KB

Deploy a SQL Server big data cluster on Azure Kubernetes Service (AKS)

Using this sample Python script, you will deploy a Kubernetes cluster in Azure using AKS and a SQL Server big data cluster using this AKS cluster as its environment. The script can be run from any client OS.

Pre-requisites

  1. Install latest version of az cli
  2. Running the script will require: python minimum version 3.0
  3. Install the latest version of kubectl
  4. Ensure you have installed azdata CLI (previously named mssqlctl) and its prerequisites:
    • Install pip3.
    • Install/update requests package. Run the command below using elevated priviledges (sudo or admin cmd window): 
      python -m pip install requests
python -m pip install requests --upgrade
    • Install latest version of the cluster management tool azdata using below command. Run the command below using elevated privileges (sudo or admin cmd window): 
      pip3 install -r https://aka.ms/azdata
  5. Login into your Azure account. Run this command:
az login

Instructions

Run the script using:

python deploy-sql-big-data-aks.py

Note

If you have both python3 and python2 on your client machine and in the path, you will have to run the command using python3:

python3 deploy-sql-big-data-aks.py

When prompted, provide your input for Azure subscription ID, Azure resource group to create the resources in, and Docker credentials. Optionally, you can also provide your input for below configurations or use the defaults provided:

  • azure_region
  • vm_size - we recommend to use a VM size to accommodate your workload. For an optimal experience while you are validating basic scenarios, we recommend at least 8 vCPUs and 64GB memory across all agent nodes in the cluster. The script uses Standard_L8s as default. A default size configuration also uses about 24 disks for persistent volume claims across all components.
  • aks_node_count - this is the number of the worker nodes for the AKS cluster, excluding master node. The script is using a default of 1 agent node. This is the minimum required for this VM size to have enough resources and disks to provision all the necessary persistent volumes.
  • cluster_name - this value is used for both AKS cluster and SQL big data cluster created on top of AKS. Note that the name of the SQL big data cluster is going to be a Kubernetes namespace
  • password - same value is going to be used for all accounts that require user password input: SQL Server master instance account created for the below username, controller user and Knox root user
  • username - this is the username for the accounts provisioned during deployment for the controller admin account and SQL Server master instance account. Note that sa SQL Server account is disabled automatically for you, as a best practice. Username for Knox gateway account is going to be root.