Skip to content

Files

Latest commit

441ef02 · Jan 25, 2022

History

History
44 lines (30 loc) · 3.33 KB

high-availability-sql-edge-containers.md

File metadata and controls

44 lines (30 loc) · 3.33 KB
title description keywords services ms.service ms.topic author ms.author ms.reviewer ms.date
High availability for Azure SQL Edge containers - Azure SQL Edge
Learn about high availability for Azure SQL Edge containers
SQL Edge, containers, high availability
sql-edge
sql-edge
conceptual
rothja
jroth
jroth
09/22/2020

High availability for Azure SQL Edge containers

Create and manage your Azure SQL Edge instances natively in Kubernetes. Deploy Azure SQL Edge to docker containers managed by Kubernetes. In Kubernetes, a container with an Azure SQL Edge instance can automatically recover in case a cluster node fails. You can configure the SQL Edge container image with a Kubernetes persistent volume claim (PVC). Kubernetes monitors the Azure SQL Edge process in the container. If the process, pod, container, or node fail, Kubernetes automatically bootstraps another instance and reconnects to the storage.

Azure SQL Edge containers on Kubernetes

Kubernetes 1.6 and later has support for storage classes, persistent volume claims.

In this configuration, Kubernetes plays the role of the container orchestrator.

Diagram of Azure SQL Edge in a Kubernetes cluster

In the preceding diagram, azure-sql-edge is a container in a pod. Kubernetes orchestrates the resources in the cluster. A replica set ensures that the pod is automatically recovered after a node failure. Applications connect to the service. In this case, the service represents a load balancer that hosts an IP address that stays the same after failure of the azure-sql-edge.

In the following diagram, the azure-sql-edge container has failed. As the orchestrator, Kubernetes guarantees the correct count of healthy instances in the replica set, and starts a new container according to the configuration. The orchestrator starts a new pod on the same node, and azure-sql-edge reconnects to the same persistent storage. The service connects to the re-created azure-sql-edge.

Azure SQL Edge in a Kubernetes cluster after pod fail

In the following diagram, the node hosting the azure-sql-edge container has failed. The orchestrator starts the new pod on a different node, and azure-sql-edge reconnects to the same persistent storage. The service connects to the re-created azure-sql-edge.

Azure SQL Edge in a Kubernetes cluster after node fail.

To create a container in Kubernetes, see Deploy a Azure SQL Edge container in Kubernetes

Next steps

To deploy Azure SQL Edge containers in Azure Kubernetes Service (AKS), see the following articles: