question

SiegfriedHeintze-9929 avatar image
0 Votes"
SiegfriedHeintze-9929 asked grajee commented

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


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


azure-sql-databaseazure-kubernetes-serviceazure-sql-virtual-machines
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AzureSQL PaaS is a PaaS service and you cannot it deploy it in a AKS. How will you create even a yaml file?

The only option is to deploy a SQLServer

0 Votes 0 ·

1 Answer

vipullag-MSFT avatar image
0 Votes"
vipullag-MSFT answered SiegfriedHeintze-9929 commented

@SiegfriedHeintze-9929

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


I looked at that last link (tutorial-sql-server-containers-kubernetes) and I did not see anything special for azure serverless SQL... Did I miss something or are the directions for serverless the same?

Also, I could not find an reference to "sts" or stateful set. Looks like the magic happens with the image mcr.microsoft.com/mssql/server:2019-latest . Is this different than a kubernetes stateful set? If so, how?

Thanks


0 Votes 0 ·