SQL Server on Docker Kubernetes for Production

Amiya Das 6 Reputation points
2020-11-17T03:53:26.957+00:00

Hi,

Is SQL Server on Docker and Kubernetes cluster advisable for production, I saw a couple of articles which don't advise for production use but they are old. Has anyone done this implementation for production?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,485 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. m 4,271 Reputation points
    2020-11-19T01:54:51.437+00:00

    Hi @Amiya Das ,

    To be honest, I have no experience in implementing sqlserver on docker in production environment, so I can only provide some reference materials.And I do a huge research, they all do not recommend you implent this operation in production environment.I consult our premier engineer about your issue, if you are implementing it in a production environment, for the sake of insurance, they suggest you consult your sqlserver after-sales service or contact sqlserver technical support,they will deal with your problem separately and confidentially: https://support.microsoft.com/en-us/assistedsupportproducts

    More information: sql-server-2019-alwayson-availability-group-on-docker-containers

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

  2. m 4,271 Reputation points
    2020-11-17T08:31:00.51+00:00

    Hi @Amiya Das ,

    Is SQL Server on Docker and Kubernetes cluster advisable for production, I saw a couple of articles which don't advise for production use but they are old. Has anyone done this implementation for production?

    Yes. It is. However it is dependented by your own.
    Quote from this doc.: sql-database-on-kubernetes-considerations-and-best-practices
    SQL database infrastructure containerization is not necessarily different from building and deploying any other mission-critical database. However, you need to consider the implications of moving mission-critical data to Kubernetes and containers. Databases on Kubernetes do not include concepts like failover elections, replication, and sharding like in MongoDB or Cassandra. You should put the right level of management and monitoring in place if you want to use Kubernetes and containers for production databases.

    More information: tutorial-sql-server-containers-kubernetes

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.


  3. m 4,271 Reputation points
    2020-11-18T05:58:04.553+00:00

    Hi @Amiya Das ,

    Why do you want to use Docker? What is your real requirement? You can use AKS

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.


  4. Amiya Das 6 Reputation points
    2020-11-19T06:53:27.213+00:00

    Thanks, Mia. I will contact them.


  5. Bajonczak, Sascha 1 Reputation point
    2022-07-09T07:01:35.213+00:00

    Hi I'm a engineer that uses for development purpose SQL Server in docker vor Vetter in Kubernetes.

    I figured out that I get in heavy load several timeouts in connect to the database. The same SQL setting in a dedicated mwchine works like a charm. So in my opinion there is a small difference with a huge impact.

    For now I won't implement SQL sever in a container.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.