| title | Configure a SQL Server Always On availability group in Kubernetes for high availability | Microsoft Docs |
|---|---|
| description | This tutorial shows how to deploy a SQL Server always on availability group with Kubernetes on Azure Container Service. |
| author | MikeRayMSFT |
| ms.author | mikeray |
| manager | craigg |
| ms.date | 07/16/2018 |
| ms.topic | tutorial |
| ms.prod | sql |
| ms.component | |
| ms.suite | sql |
| ms.custom | sql-linux,mvc |
| ms.technology | linux |
Learn how to configure a SQL Server Always On availability group on Kubernetes in Azure Kubernetes Service (AKS). This solution provides the high availability (HA) and read-scale benefits of a SQL Server Always On availability group with the container orchestration benefits of Kubernetes.
This tutorial demonstrates how to configure a highly available SQL Server instance in containers that use AKS.
[!div class="checklist"]
- Create an SA password
- Create storage
- Create the deployment
- Connect with SQL Server Management Studio (SSMS)
- Verify failure and recovery
Before starting this tutorial,
-
Create an Azure Kubernetes Service(AKS) cluster in a resource group named
myResourceGroup. Name the AKS clustermyAKSCluster.az aks create --resource-group myResourceGroup --name myAKSCluster
[!div class="nextstepaction"] Introduction to Kubernetes