Infrastructure at your Service

 
Daniel Westermann

Enabling, disabling, and validating foreign key constraints in PostgreSQL

By | Database Administration & Monitoring | No Comments

Constraints are in important concept in every realtional database system and they guarantee the correctness of your data. While constraints are essentials there are situations when it is required to disable or drop them temporarily. The reason could be performance related because it is faster to validate the constraints at once after a data load. The reason could also be, that you need to load data and you do not know if the data is…

Read More
Daniel Westermann

A schema and a user are not the same in PostgreSQL

By | Database Administration & Monitoring | One Comment

When people with an Oracle background attend our PostgreSQL DBA Essentials training there is always a bit of confusion about schemas and users. In Oracle a schema and a user is a one to one relationship and there is no real distinction between a user and a schema. In PostgreSQL the situation is different: All the objects a user is creating are created in a specific schema (or namespace). Other users may or may not…

Read More
Pascal Brand

DOAG 2019: Cloud or Kubernetes on premise and CI/CD pipeline at the top of (my) interest

By | Database Administration & Monitoring | No Comments

The DOAG 2019 is just over now and if I check the subject of sessions I was attending, I have the feeling the Cloud and Kubernetes on-premise deployments and CI/CD pipelines were the top subjects interesting people or may be just me !! I started by a devOps session and then followed a lot of Kubernetes or containers related sessions. The three following sessions are those I directly think about when trying to summarize. “The…

Read More
Casimir Schmid

Persistent Memory and first usage on Oracle Exadata platform

By | Database Administration & Monitoring | No Comments

Todays fastest possible interface for flash storage in terms of bandwidth and latency are DRAM sockets. Exadata X8M is the first Oracle engineered system using this technology that, according to first measurements taken by Oracle corporation, result in 200% read IO increase compared to Exadata X8. Summary from a presentation by Gavin Parish held at DOAG 2019 conference with a comment by Michael Wirz.

Read More
Saïd Mendi

Deploying a MariaDB 10.4 Galera cluster with Clustercontrol

By | Database Administration & Monitoring | No Comments

What is ClusterControl ? Since years, I’m using and installing by customers a management and automation software called “ClusterControl” from Severalnines (www.severalnines.com). With it, you can easily deploy, manage, monitor and scale your open source database servers or clusters (MariaDB, Percona, Postgres, Galera) from one GUI (Clustercontrol User Interface) on premise or even in the cloud. Some weeks ago, Severalnines announced the version 1.7.4 with several new features. One of these was the support of…

Read More
Mehdi Bada

First day at DOAG 2019 Conference

By | Database Administration & Monitoring, Oracle | No Comments

This year I have the opportunity to take place at one of the most popular Oracle conferences, the DOAG. In the meantime, I have the chance to give a talk on Thursday about Docker containers. Yes! Because at DOAG we are not only speaking about Oracle products. I’m really impressed by the quality of the presentations. I followed 4 presentations, on different subjects/technologies and the quality of them was very good. David Hueber, OCI vs…

Read More
Hervé Schweitzer

Some news from the DOAG2019

By | Database Administration & Monitoring | No Comments

As each year dbi services is present at the DOAG, but this year it’s a little bit special, because we have a complete new booth which is just wonderful! Big thanks to the dbi services marketing teams which did a marvelous job. What is also new for dbi services, all dbi consultants have they own dedicated tee shirt with dedicated messages and colors. For me it is Mountain, Mountain bike and Natural Trance Music. Therefor…

Read More
Mehdi Bada

NFS Storage Configuration for Kubernetes

By | Application integration & Middleware | No Comments

For one of our important customers, we are working on a major project to migrate critical applications to containers. From the implementation of the Kubernetes architecture to the deployment of applications and the administration of the platform, we are responsible for an important technological stack with new challenges for our team. One of the challenges, both important and exciting, is the implementation of Kubernetes clusters on bare metal (VM) and its management. We have deployed…

Read More
Jérôme Dubar

A day of conferences with the Swiss Oracle User Group

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

Introduction I’m not that excited with all these events arround Oracle technologies (and beyond) but it’s always a good place to learn new things, and maybe the most important, discover new ways of thinking. And regarding this point, I was not disappointed. Franck Pachot: serverless and distributed database Franck talked about scaling out, it means avoid monoliths. Most of the database servers are this kind of monoliths today. And he advises us to think microservices….

Read More