Infrastructure at your Service

Linux Archives - Blog dbi services

Daniel Westermann

Getting started with Red Hat Satellite – Installation

By | Database Administration & Monitoring | No Comments

This is the start of a series of posts I wanted to write for a long time: Getting started with Red Hat Satellite. Just in case you don’t know what it is, this statement from the official Red Hat website summarizes it quite well: “As your Red Hat® environment continues to grow, so does the need to manage it to a high standard of quality. Red Hat Satellite is an infrastructure management product specifically designed…

 
Read More
Petre Radut

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

By | Database Administration & Monitoring | No Comments

Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks. In this blog I will…

 
Read More
Julia Gugel

Redhat Forum 2018 – everthing is OpenShift

By | Database Administration & Monitoring | No Comments

I had an exiting and informational day at Redhat Forum Zurich. After starting with a short welcome in the really full movie theater in Zurich Sihlcity, we had the great pleasure to listen to Jim Whitehurst. With humor he told about the success of Redhat during the last 25 years. The partner and success stories of Vorwerk / Microsoft / Accenture / Avaloq / Swisscom and SAP showed impressivly the potential and the usage of…

 
Read More
David Barbarin

Deploying SQL Server on MiniShift / RedHat OpenShift

By | Database Administration & Monitoring | No Comments

Currently we begin to see customer adopting containerization for SQL Server databases (mainly driven by CI/CD and DevOps trends). A lot of them are using RedHat OpenShift as container management platform. From my side, I didn’t want to setup a complete OpenShift infrastructure on my lab to test only my SQL Server pod deployment on such infrastructure. I rather installed MiniShift that comes with one OpenShift node cluster which perfectly meets my requirements.    …

 
Read More
Oracle Team

The size of Oracle Home: from 9GB to 600MB – What about SQL Server?

By | Database Administration & Monitoring | No Comments

Holidays is over and let’s start working with a funny write-up. I was reading interesting stuff done by my colleagues Franck Pachot and Daniel Westermann about reducing the size of Oracle / PostgreSQL binaries at the minimum in the context of a Docker images. I was curious what can be done on SQL Server side on Linux environment but just keep in mind that some operations performed in this post are probably not supported in…

 
Read More
Daniel Westermann

Catching interface state changes with Network Manager

By | Database Administration & Monitoring | No Comments

Sometimes it is required that you can react on state changes of your network interfaces. Maybe you want to get notified by mail or you want to execute a script that does something in case an event is trapped. As usual I will be using CentOS 7 for this little demonstration but as most distributions use systemd and NetworkManager nowadays this should work more or less the same on Debian based distributions.  

 
Read More
David Barbarin

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
David Barbarin

SQL Server on Linux – I/O internal thoughts

By | Database management, Development & Performance, SQL Server | 2 Comments

Let’s start the story from the beginning with some funny testing I tried to perform with SQL Server on Linux a couple of months ago. At that time, I wanted to get some pictures of syscalls from SQL Server as I already did in a past on Windows side with sysinternal tools as procmon and stack traces. On Linux strace is probably one of the best counterparts. Firstly, please note this blog is just from…

 
Read More
David Barbarin

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