Infrastructure at your Service

 
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
Joël Cattin

Red Hat Enterprise Linux 8 – Stratis

By | Operation systems | No Comments

The Initial Release (8.0.0) of Red Hat Enterprise Linux 8 is available since May 2019. I’ve already blogged about one of its new feature (AppStream) during the Beta version. In this post I will present Stratis, which is a new local storage-management solution available on RHEL8. Introduction LVM, fdisk, ext*, XFS,… there is plenty of terms, tools and technologies available for managing disks and file systems on a Linux server. In a general way, setting…

Read More
Grégory Steulet

Managing Licenses with AWS License Manager

By | Database Administration & Monitoring, Operation systems | No Comments

Introduction Computing environments became more and more agile over these last years. Companies need to provide solutions helping people to quickly set up new resources, starting and stopping them, scaling them according to the need and finally, removing them. In such environments, it could be tricky to follow license compliance when resources are changing on hourly basis. Having a look on AWS services, I saw that AWS provides a license managing tool named “AWS License…

Read More
Saïd Mendi

Rolling Upgrade of a Galera Cluster with ClusterControl

By | Database Administration & Monitoring | No Comments

Rolling Upgrade is easy In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster “Rolling Upgrade” without any loss of service. Let’s say we want to upgrade from Percona XtraDB Cluster version 5.6 to 5.7. The same procedure can be used to upgrade MariaDB (from 10.1 to 10.2 or 10.3) Prerequisites First of all, make sure that on your Galera cluster all nodes are synchronized. From the…

Read More
Mouhamadou Diaw

Oracle 19c : Point-In-Time Recovery in a PDB

By | Database Administration & Monitoring, Oracle | No Comments

Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a PDB does not affect remaining PBDs. That means that while doing a PITR in PDB, people can use the other PDBs. In this…

Read More
David Barbarin

When Read-Scale availability groups and Windows Failover Cluster are not good friends

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

A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about a weird behavior I experienced with them.   Basically, Read-Scale availability groups are clusterless infrastructures meaning there is no need to install an underlying cluster. Obviously, you will not benefit from resource orchestration and automatic failover, but this is obviously the…

Read More
Mouhamadou Diaw

OpenShift 4.1 Partner Introduction Day

By | DevOps, Kubernetes | No Comments

Today was the OpenShift Partner Introduction Day by RedHat. This event happened at Lausanne There were people with different backgrounds. After presenting the RedHat compagny, the speaker explained what is Openshifts and why people must adopt it. What we will retain is that OpenShift is trusted enterprise Kubernetes With OpenShift we can for example -Automated, full-stack installation from the container host to application services -Seamless Kubernetes deployment to any cloud or on-premises environment -Autoscaling of…

Read More
Jérôme Dubar

ODA X8-2: the new generation

By | Database Administration & Monitoring, Hardware & Storage, Oracle | 2 Comments

Introduction ODA X7-2 marked the maturity of the Oracle Database Appliance evolution, with 3 models suitable for nearly all customers using Oracle databases. The X7-2M was my favorite, with a lots of cores available (and restrainable), enough memory for dozens of databases, and strong storage performance and capacity (with a maximum of 50TB RAW NVMe). And taking up only 1U of space in your rack. Today, 2 years later, Oracle just introduced the new generation…

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
Mouhamadou Diaw

RMAN in a Multitenant Environment

By | Database Administration & Monitoring, Oracle | No Comments

The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in a multitenant environment for an oracle 19c database with 2 pluggable databases. Below the configuration we are using. SQL> show pdbs CON_ID CON_NAME…

Read More
Marc Wagner

Moving oracle database to new home on ODA

By | Database Administration & Monitoring | No Comments

Moving database to new ORACLE_HOME is a common dba task. Performing this task on an ODA will need an additional step knowing ODA Lite is using an internal Derby database for the metadata. ODA HA will not be a problem here, knowing we do not have any Derby database. Through this blog I would like to give you some guidance and work around to move database to a new home (of same major release). In…

Read More