SQL 2019 Kubernetes Replica vs Always On Group

Robert 1 Reputation point
2021-04-02T13:29:34.853+00:00

I am trying to understand the difference between having a 2019 Kubernetes with multiple replicas/nodes/pod that are active compared to a 2019 kubernetes always on cluster.
Anyone able to help explain, i have tried searching for it but i feel like with the replicas and load balancing option there is no reason to use always on.
Thank you in advance!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
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,854 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Bowen 1,276 Reputation points Microsoft Employee
    2021-04-02T17:57:56.817+00:00

    Hi anonymous user

    The openspec-* tags are dedicated to supporting issues related to open specifications. You can find open specifications here https://learn.microsoft.com/en-us/openspecs/

    Since your question does not pertain to one of these specifications, I've removed the openspecs-sqlserver tag.

    You may be able to find additional resources here:
    SQL AlwaysOn: Choosing between the right replication model - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)
    Deploy a SQL Server container with Azure Kubernetes Services (AKS) - SQL Server | Microsoft Learn

    If I've misunderstood your question and you believe this is related to the Open Specifications documents, please clarify, providing the document name and section with which you have the question or issue.

    Best Regards,

    Mike Bowen
    Escalation Engineer - Microsoft Open Specifications

    0 comments
  2. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2021-04-05T09:31:05.877+00:00

    Hi anonymous user,

    I am not familiar with Kubernetes, please check if you could find some useful information from below links.

    Deploy a SQL Server container in Kubernetes with Azure Kubernetes Services (AKS)
    Deploying a SQL Server 2019 Availability Group into a Kubernetes Cluster

    0 comments