Wanted: Directions for Using Serverless Azure SQL as part of Kubernetes Stateful Set

Siegfried Heintze 1,851 Reputation points
2020-12-08T21:26:48.55+00:00

I've been very interested in this article: single serverless azure sql database creation quickstart.

How can this be used with Azure Kubernetes Service (AKS)?

(1) I assume there is no problem with creating a kubernetes service and kubernetes end points as described here.

(2) Can someone explain how to create a kubernetes reliable singleton (as described using mysql in kubernetes-up-and-running-2nd-edition chapter 15) using azure serverless SQL instead of mysql? Basically the authors show how to create a persistent volume & claim connected to a replicaset of 1 for mysql.

(3) Can someone explain how to create a kubernetes stateful set using serverless azure SQL?

Thanks

Siegfried

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,821 questions
{count} votes

Accepted answer
  1. vipullag-MSFT 23,806 Reputation points Microsoft Employee
    2020-12-14T14:51:38.387+00:00

    @Siegfried Heintze

    Apologies for the delayed response on this.
    (1) I assume there is no problem with creating a kubernetes service and kubernetes end points as described here.

    • Yes the approach followed is correct.

    (2) Can someone explain how to create a kubernetes reliable singleton (as described using mysql in kubernetes-up-and-running-2nd-edition chapter 15) using azure serverless SQL instead of mysql? Basically the authors show how to create a persistent volume & claim connected to a replicaset of 1 for mysql.

    • If its singleton, Then its not reliable. Running 1 replica is not recommended

    (3) Can someone explain how to create a kubernetes stateful set using serverless azure SQL?

    • As SQL is a managed service, this is not possible. Instead you can create a sql separately and then add that as a headless service in Kubernetes.

    Please find this document that has instructions on deploying a SQL server container in Kubernetes with AKS.


0 additional answers

Sort by: Most helpful