question

MartinHale-9649 avatar image
1 Vote"
MartinHale-9649 asked MartinHale-9649 action

SQL Server Always On AG Support on Kubernetes

Hello,

We are a large financial firm in the process of moving our SQL Server environment to Linux. We are planning on using Always On Availability Groups in our solution as we do today on Windows Server. We have installed and proved our this configuration with bare metal and VMs using Pacemaker cluster management. We are now looking at utilizing containers with either Pacemaker_remote or with Kubernetes, both of which we are unsure at this time if our configuration is supported.

Can anyone confirm if Microsoft is going to or does currently support Always On Availability Groups (cluster type=EXTERNAL) on Kubernetes? And if so, where can you download the Kubernetes operator?

Thank you

-Martin

sql-server-general
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

1 Answer

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered MartinHale-9649 commented

So Kubernetes makes my head spin quite a bit, but it seems that Microsoft are using Kubernetes both here and there. I found this blog post from my MVP Andrew Nocentino, which might be helpful: https://www.centinosystems.com/blog/sql/deploying-sql-server-in-kubernetes/

· 5
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

MartinHale-9649 avatar image MartinHale-9649 ·

It does help although it was posted back in 2018 as are the code samples for the Microsoft created Kubernetes operator which leads me to believe this functionality never made it out of "testing/preview". I can't find any official doc or confirmation from Microsoft, or anything recent, like within the last year of running SQL Server Availability Groups in Kubernetes. I know we can definitely run SQL Server in Kubernetes but my company is insistent that we use AGs for our HADR solution so I'm trying to determine all the viable, supported options...

0 Votes 0 ·
ErlandSommarskog avatar image ErlandSommarskog MartinHale-9649 ·

In the Google search, I saw a date that was more recent, but then I did not look closely on the blog post itself. I guess the date Google showed was the date for the last comment to the post.

Anyway, reading the comments from the end, I see that Andrew has posted this: Hi there…as far as I know, AGs aren’t available in the GA release for 2019.

I'll try to ping Andrew, to see if he has anything to add.



0 Votes 0 ·
MartinHale-9649 avatar image MartinHale-9649 ErlandSommarskog ·

thanks for that!! I didn't read down in the comments. I had heard it didn't make GA but as it's now been some time since then I was hoping it was now a support option. If you find anything else out please post here. and thanks again!

0 Votes 0 ·
Show more comments