Infrastructure at your Service

 
Franck Pachot

What is a database backup (back to the basics)

By | Database Administration & Monitoring, Postgres | 8 Comments

By Franck Pachot . TL;DR: do not consider a dump (like PostgreSQL pg_dump or Oracle expdp) as a database backup do not consider that your backup is successful if you didn’t test recovery databases provide physical database backups, easy and safe to restore and recover to any point-in-time between first backup and point of failure managed databases provide an easy recovery interface, but don’t trust it before you try it and… I’ve written this after…

Read More
Jérôme Dubar

Disk usage on ODA – Free MB and usable MB

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Introduction Oracle Database Appliances rely on ASM to manage disk redundancy. And ASM is brilliant. Compared to RAID, redundancy is managed at the block level. For NORMAL redundancy, which is similar to RAID1, you need at least 2 disks, but it can also work with 3 disks, 4 disks, 5 disks and so on. There is no need for parity at the disk level. HIGH redundancy, which does not exist in RAID technology, is basically…

Read More
Jérôme Witt

Ansible loop over registered results

By | DevOps | No Comments

We were recently confronted with one of our playbook constraint while trying to identify which database software could be uninstalled from our servers. Until now, we ran the playbook to de-install a specific version which were “discovered manually”. However, we even got lazy to run this “discovery phase” manually. This short post explains how to design a play around the results of a specific task like generating a list of obsolete Oracle RDBMS software.

Read More
Steven Naudet

SQL Server: Generating SQL script using PowerShell and Template file

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

In this blog post, I will share with you a small PowerShell script I did recently. I have noticed that my customer performs a very repetitive and time-consuming task almost every day. New columns are added to tables on their business-critical database and they need to maintain SQL scripts file with all the ALTER TABLE statements for each new column. For every new column, my customer copy-pastes the following SQL Script and then change parts…

Read More
Jérôme Dubar

Oracle Database Appliance vs Oracle Cloud Infrastructure

By | Cloud, Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction Oracle Database Appliances are very popular these days. And not only among new customers for this kind of engineered systems. Almost all customers already using old generation ODAs are renewing their infrastructure by choosing again ODAs, meaning that the solution is good enough and probably better than anything else. But now, public clouds are a real alternative to on-premise servers, and Oracle Cloud Infrastructure is a solid competitor vs Amazon and Azure public clouds….

Read More
Christian Weinfurtner

Upgrade to Oracle 19c – performance issue

By | Database Administration & Monitoring, Database management, Oracle | No Comments

In this blog I want to introduce you to a workaround for a performance issue which randomly appeared during the upgrades of several Oracle 12c databases to 19c I performed for a financial services provider. During the upgrades we ran into a severe performance issue after the upgrades of more than 40 databases had worked just fine. While most of them finished in less than one hour, we run into one which would have taken…

Read More
Daniel Westermann

Getting started with Exasol – A multi node cluster in AWS

By | AWS, Database Administration & Monitoring | No Comments

As of now, all the previous posts worked with the Community Edition of Exasol. While that is great for getting started quickly (the Community Edition comes with all the features, except multi node support and a limit of 200GB of data) there are some limitations: Can you not really test how data is distributed across cluster nodes because there is only one. You do not have a real access to the operating system as the…

Read More
Steven Naudet

SQL Server AlwaysOn node “Add all eligible storage to the cluster”

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

I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage to the cluster”.   Before performing the operation the disks on the 2 nodes of my cluster were used by the SQL Server instances. Because I’m using the AlwaysOn features the disks are local on…

Read More
Daniel Westermann

Getting started with Exasol – Backup and restore (2)

By | Database Administration & Monitoring | No Comments

In the previous post we did the groundwork for being able to backup the Exasol database to an S3 bucket. We learned that you can do full level 0 backups and of top of that you can do incremental backups, that refer to each other. A restore of the full backup worked fine and pretty fast. In this post we’ll restore both incremental backups and check if the result is what we expect. In addition…

Read More
Franck Pachot

YCSB (NoSQL benchmark) on Oracle Database

By | Cloud, Database Administration & Monitoring, NoSQL | 7 Comments

By Franck Pachot . The NoSQL technologies emerged for Big Data workloads where eventual consistency is acceptable and scaling out to multiple server nodes is an easy answer to increase throughput. With cloud services rising, those key-value document datastores started to be used by the web-scale companies for some transactional processing workloads as well. The solutions can provide high performance and easy partitioning capabilities thanks to the very simple API of NoSQL. Each table or…

Read More
Mehdi Bada

Setup an NGINX Ingress Controller on Kubernetes

By | Application integration & Middleware, Cloud, DevOps, Docker, Kubernetes | No Comments

One of the most important and basic concept in Kubernetes is the Service exposition. How about exposing a Kubernetes Service deployed inside a cluster to outside traffic? Let’s have a look on the different approaches to expose a Kubernetes Service outside the cluster and particularly the role of the Ingress Controller. NodePort, Load Balancers, and Ingress Controllers In the Kubernetes world, there are three general approaches to exposing your application. NodePort A NodePort is an…

Read More