Infrastructure at your Service

Category

Docker

David Barbarin

Using non-root SQL Server containers on Docker and K8s

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes, SQL Server | No Comments

This is something that I waited for a while, in fact since SQL Server 2017 … and the news came out on Wednesday 09th September 2019. Running Non-Root SQL Server Containers is now possible either on the next version of SQL Server (2019) and it has been backported on SQL Server 2017 as well. Non-root SQL Server containers will likely be part of hidden gem of SQL Server new features, but this is definitely a…

Read More
David Barbarin

How to get a big picture of K8s pods and PVs by script

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes | No Comments

A couple of weeks ago, during an internal dbi services workshop about Docker and K8s, I got an interesting question: is it possible to get a big picture of pods connected to one specific persistent volume (PV) by using kubectl command? It was an interesting question because if we go through the usual kubectl command, it doesn’t provide natively the desired output. In fact, one one hand we get information about PVs and their related…

Read More
David Barbarin

Debugging SQL Server containers considerations

By | Database Administration & Monitoring, Docker, SQL Server | No Comments

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to strace tool. But let’s add containers in the game now. I didn’t want to touch any based image for applications including SQL Server with debugging tools added. So, my concern was to figure out how to…

Read More
Mehdi Bada

CloudBees DevOps Playground – Hands On with JenkinsX

By | DevOps, Docker, Kubernetes | No Comments

Last week, we had the chance to attend to the CloudBees DevOps Playground in London. The event was a presentation and a Hands-On on Jenkins X done by one of the most popular guys from the CloudBees, Gareth Evans. Before taking an interest in Jenkins X, we focused most of our time in the Docker and Kubernetes part. We enhance a lot our skills during the last months on the administration of Kubernetes cluster and…

Read More
David Barbarin

Deploying SQL Server 2019 container on RHEL 8 with podman

By | Database Administration & Monitoring, DevOps, Docker, SQL Server | No Comments

Having a fresh install of RHEL8 on my lab environment, I was curious to take a look at new containerization stuff from Red Hat in the context of SQL Server 2019. Good chances are the future version of SQL Server should be available and supported on with the latest version of Red Hat but for now this blog post is purely experimental. This time I wanted to share with you some thoughts about the new…

Read More
Mehdi Bada

Kubernetes – How to install a single master cluster with kubeadm?

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes | No Comments

To bootstrap a minimal K8S cluster for testing purpose, kubeadm is a very interesting tool. The goal of this blog is not to explain to you the K8S architecture or the components but only the deployment part. using kubeadm. The final architecture of our cluster will be the following: Source:https://elastisys.com/2018/01/25/setting-highly-available-kubernetes-clusters/ Docker Installation The first step is to install Docker on each cluster node: yum install yum-utils device-mapper-persistent-data lvm2 yum-config-manager \ –add-repo \ https://download.docker.com/linux/centos/docker-ce.repo yum update…

Read More
David Barbarin

SQL Server containers and docker network driver performance considerations

By | Database Administration & Monitoring, DevOps, Docker, SQL Server | No Comments

Few months ago I attended to the Franck Pachot session about Microservices and databases at SOUG Romandie in Lausanne on 2019 May 21th. He covered some performance challenges that can be introduced by Microservices architecture design and especially when database components come into the game with chatty applications. One year ago, I was in a situation where a customer installed some SQL Server Linux 2017 containers in a Docker infrastructure with user applications located outside…

Read More
David Barbarin

Windocks and K8s support

By | DevOps, Docker, Kubernetes, SQL Server | No Comments

I got recently the 4.08 update from the Windocks team and I was very excited to evaluate some of new features. The first cool one I want to present in this blog concerns the Kubernetes support for deploying Windocks containers that will make my application deployment definitely easier. Let’s say you want to deploy your application that is tied to a Windocks container for SQL Server. In a previous blog post I explained why we…

Read More
David Barbarin

Windocks, SQL Server and Azure in our internal CI pipeline

By | Cloud, DevOps, Docker, Kubernetes, SQL Server | One Comment

During the last DevOps Day in Geneva, I presented a sample of our CI implementation related to our MSSQL DMK maintenance product. It was definitely a very good experience for me and good opportunity to get feedback from DevOps community as well. During the session I explained our CI pipeline includes SQL Server containers both on AKS (K8s as managed service in Azure) and Windocks. I got questions from some of attendees who asked me…

Read More