Today I will guide you through the deployment of a HANA Express database on AKS – Managed Kubernetes on Azure. One of my colleagues out of the GBB SAP team has asked me, if the setup described for GKE on the SAP website is also possible for AKS on Azure.
-> https://www.sap.com/developer/tutorials/hxe-kubernetes-google-cluster.html
The answer is yes. I have written a PowerShell script which leverages the Azure CLI and a YAML file to deploy an AKS cluster and the HANA Express database on AKS. I have used the same configuration details as provided in the SAP tutorial. So, the AKS cluster will have three agent nodes with 4 vCPUs and 32 GB memory each using the Standard_A4m_v2 Azure VM size. So, what do you need to deploy the HANA Express database on AKS?
- Access to an Azure subscription
- Azure Cloud Shell – Bash
- Docker Registry credentials
- deploy_HXE_AKS.ps1 file from the following GitHub repo.
-> https://github.com/neumanndaniel/kubernetes/tree/master/hxe-aks
Let us start with the first step logging in to the Azure Cloud Shell (https://shell.azure.com/). Type in pwsh -noprofile to start a PowerShell Core session. Next step is to download the deploy_HXE_AKS.ps1 to your Azure Cloud Shell session.
wget https://raw.githubusercontent.com/neumanndaniel/kubernetes/master/hxe-aks/deploy_HXE_AKS.ps1
Then we kick off the deployment with the command ./deploy_HXE_AKS.ps1.
You will be asked in which region you would like to deploy the AKS cluster. Currently, you can only choose between West Europe, East US, and Central US. The PowerShell script will then create a resource group called “aks-hxe-rg” in the selected region and deploys the AKS cluster called “aks-hxe-cluster” into it.
Throughout the setup you will be asked to specify the master password for the HANA Express database installation and your Docker Registry credentials to pull the SAP HANA Express Edition image. The master password for the HANA Express database should have at least 8 characters with one uppercase letter, one lowercase letter, and one number.
The PowerShell script is designed to create the necessary Kubernetes secrets for the HANA Express database master password and for the Docker Registry. I have modified the YAML file for the HANA Express database deployment, so it will use the master password secret instead of specifying the password in the YAML file as described in the SAP tutorial.
apiVersion: v1 kind: PersistentVolume metadata: name: persistent-vol-hxe labels: type: local spec: storageClassName: manual capacity: storage: 150Gi accessModes: - ReadWriteOnce hostPath: path: /data/hxe_pv --- apiVersion: v1 kind: PersistentVolumeClaim metadata: name: hxe-pvc spec: storageClassName: manual accessModes: - ReadWriteOnce resources: requests: storage: 50Gi --- apiVersion: v1 kind: Pod metadata: name: hxe-pod labels: name: hxe-pod spec: initContainers: - name: install image: busybox command: [ 'sh', '-c', 'chown 12000:79 /hana/mounts' ] volumeMounts: - name: hxe-data mountPath: /hana/mounts restartPolicy: OnFailure volumes: - name: hxe-data persistentVolumeClaim: claimName: hxe-pvc - name: hxe-config secret: defaultMode: 420 secretName: masterpassword imagePullSecrets: - name: docker-secret containers: - name: hxe-container image: "store/saplabs/hanaexpress:2.00.022.00.20171211.1" ports: - containerPort: 39013 name: port1 - containerPort: 39015 name: port2 - containerPort: 39017 name: port3 - containerPort: 8090 name: port4 - containerPort: 39041 name: port5 - containerPort: 59013 name: port6 args: [ "--agree-to-sap-license", "--dont-check-system", "--passwords-url", "file:///hana/hxeconfig/password.json" ] volumeMounts: - name: hxe-data mountPath: /hana/mounts - name: hxe-config mountPath: /hana/hxeconfig
After the PowerShell script execution type in kubectl describe pod hxe-pod to get more details about the current deployment status. The image pull will take some time.
After the successful image pull have a look at the logs with the following command.
kubectl logs hxe-pod
Continue showing the logs until you get a Startup finished! as the last output of the logs.
Afterwards we can execute the command kubectl exec -it hxe-pod bash to get access to the bash of the pod. Followed by the command hdbsql -i 90 -d HXE -u SYSTEM -p YOURPASSWORD, we can log in to the SAP HANA Database interactive terminal.
Pingback: SAP HANA Express Edition – Deploy HANA Express database on ACI – Azure Container Instances - Daniel's Tech Blog