Infrastructure at your Service

Tag

Docker Archives - Page 3 of 6 - Blog dbi services

Microsoft Team

Running SQL Server containers on K8s Docker for Windows CE stable channel

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

The release of Docker for Windows Stable version 18.06..0-ce-win70 comes with some great new features I looked for a while including the K8s support! That’s a pretty good news because this support has existed on Edge channel since the beginning of this year but no chance to install a beta version on my laptop from my side. So, we get now a good opportunity to test locally our SQL Server image with a K8s single…

Read More
Franck Pachot

Installing ZFS on OEL7 UEK4 for Docker storage

By | Database Administration & Monitoring | No Comments

By Franck Pachot . The Oracle Database is fully supported on Docker according that Linux is Red Hat Enterprise Linux 7 or Oracle Enterprise Linux 7 with Unbreakable Enterprise 4. This is documented in MOS Note 2216342.1. Given the size of the Oracle database in GigaBytes even empty, the way it is installed at build with many file updates, and the per-block modifications of the datafiles, a block level copy-on-write filesystem is a must and…

Read More
Microsoft Team

Dealing with automatic restart and SQL Docker containers

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, a customer asked me how to restart containers automatically after a reboot of the underlying host. In his context, it was not an insignificant question because some containers are concerned by SQL Server databases and he wanted to stay relaxed as long as possible even after a maintenance of the Linux host by sysadmins. The concerned (DEV) environment doesn’t include container orchestration like Swarm or Kubernetes. The interesting point is…

Read More
Microsoft Team

Dealing with ugrade scenarios for SQL Server on Docker and Swarm

By | Database Administration & Monitoring | No Comments

This blog post comes from an interesting experience with one customer about upgrading SQL Server on a Docker environment. Let’s set quickly the context: a production environment that includes a standalone Docker engine on the top of openSUSE Linux distribution with some SQL Server 2017 Linux containers. The deal was to update those SQL Server instances from 2017 CU1 to 2017 CU7. The point is we applied the same kind of upgrades earlier on the morning but it…

Read More
Microsoft Team

Introducing SQL Server on Kubernetes

By | Database Administration & Monitoring | One Comment

After spending some times with Docker Swarm let’s introduce SQL Server on Kubernetes (aka K8s). Why another container orchestrator? Well, because Microsoft gives a strong focus on Kubernetes in their documentation and their events and because K8s is probably one of the most popular orchestration tools in the IT industry. By the way, I like to refer to the Portworx Annual Container Adoption Survey to get a picture of container trend over the years and we…

Read More
Daniel Westermann

EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers

By | Database Administration & Monitoring | No Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. In the last post we had a look at the basic configuration of EDB EFM and confirmed that we can do manual switchovers for maintenance operations. Being able to do a switchover and switchback is fine but what really is important are automatic failovers. Without an automatic failover this setup would be somehow useless as a) EDB…

Read More
Microsoft Team

SQL Saturday Paris 2018 – PrĂ©-confĂ©rence SQL Server Linux, Docker et Azure

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

The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientĂ´t et l’agenda a Ă©tĂ© publiĂ© sur Twitter par le @GUSS Cette annĂ©e, un savant mĂ©lange de speakers francophones et internationaux, un plus pour les participants … Un rapide coup d’œil Ă  l’agenda – si on se focalise sur la partie moteur SQL Server – montre Ă©galement qu’une bonne…

Read More
Microsoft Team

Windocks – a different way to use SQL Server on Docker

By | Database Administration & Monitoring | No Comments

I spent some times to write blog posts about SQL Server on Docker since few months and you likely noticed it concerned mainly SQL Server on Linux. But what about SQL Server on Docker and Windows? If you take a look at the Docker images provided by Microsoft, only 2017 version is available and it is only intended for development and testing use. Versions prior 2017 seem to not be supported so far (but I…

Read More
Daniel Westermann

Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | No Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. In the last two posts we deployed an EDB database container and two pgpool instances and then scaled that up to include a read only replica. In this post will use a ConfigMap to adjust parameters in postgresql.conf as you will probably need to do that when you start using the EDB containers in your environment.

Read More
Daniel Westermann

Scaling the EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | No Comments

This blog refers to an older version of EDB’s Postgres on Kubernetes offering that is no longer available. When you followed the last post you should have two pgpool instances and one EDB Postgres instance running in OpenShift. pgpool is responsible for the load balancing, meaning: Send write requests to the master instance and spread read requests over all instances. In the current setup this does not make much sense as we only have one…

Read More