SQL Server in Kubernetes on Docker for Windows

02-07 20:00

Last week Docker announced a feature that I’ve been looking forward to for a while: –

And sure enough, when I opened Docker for Windows, there was the update: –

Let’s run through the steps to get this setup. First of all, enable the feature in settings: –

Once installed, you’ll be able to confirm that Kubernetes is up and running: –

Awesome stuff, but how do we interact with it?

Now, if this is the first time working with Kubernetes you won’t have to perform the next couple of steps but just to confirm, run the following: –

kubectl config current-context

If your shell cannot find the kubectl command, add

C:\Program Files\Docker\Docker\Resources\bin\

to your PATH environment variable and restart your shell.

If the command outputs anything other than docker-for-desktop you will need to switch to the desktop cluster. To do this run: –

kubectl config use-context docker-for-desktop-cluster

In the above screenshot I switched from my mySQLK8sCluster1 (myAKS cluster) to docker-for-desktop and then ran: –

kubectl get nodes

Now we are ready to go and build a pod running SQL Server in Kubernetes on Docker for Windows ��

So in C:\temp create a file called sqlserver.yml and drop in: –

apiVersion: v1
kind: Pod
metadata:
  name: sqlserver
  labels:
    name: sqlserver
spec:
  containers:
  - name: sqlserver
    image: microsoft/mssql-server-linux:latest
    ports:
    - containerPort: 1433
    env:
    - name: SA_PASSWORD
      value: "Testing1122"
    - name: ACCEPT_EULA
      value: "Y"

This is a very simple .yml file to create one pod running SQL Server. To create the pod: –

kubectl create -f C:\temp\sqlserver.yml

kubectl get pods

And boom! There we have a pod running SQL Server.

Now, unfortunately I haven’t had time to work out how to connect to the instance externally. I’ll work on that and update this post once I get it working (if I can).

For now, we can verify that SQL is up and running in the pod by remoting into it: –

kubectl exec -it sqlserver /bin/bash

ps aux | grep sql

And there’s SQL running in the pod! Cool!

Ok, not particularly handy without being able to connect with SSMS on your desktop but I think it’s pretty interesting to run through these steps to get a handle on how Kubernetes on Docker for Windows works.

Thanks for reading

原文链接:https://dbafromthecold.com/2018/02/07/sql-server-in-kubernetes-on-docker-for-windows/?utm_source=tuicool&utm_medium=referral
标签: Kubernetes SQL Server Windows
© 2014 TuiCode, Inc.