Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
It has been an amazing ride: 1st of May 2022 I have been with dbi services for exactly seven years. This is by far the longest employment in my career. When I started way back in 2015 most of my work was still around Oracle products, like the Oracle Database and Oracle Grid Infrastructure, Oracle GoldenGate and a bit of…
As you might be aware, CentOS 8 is end of life since the 31st of December 2021. If you are still using and running CentOS 8, you might want to migrate to some alternative distributions in order to keep a Red Hat compatibility. Those alternative distributions might be chosen between : Rocky Linux AlmaLinux Red Hat Enterprise Linux Oracle Linux…
Introduction Patch 19.15 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings April’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but only for DB Systems (21c being an innovation release). As you may know, new ODA X9-2 is here with 3…
Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the ability to replicate system objects (like SQL Agent jobs, Logins and Linked Servers) between your database replicas. In this blog post,…
Updated the 10th of June, 2022: add PMEM option on X9-2L. Introduction It’s been nearly 3 years that Oracle Database Appliance X8-2 reached the market, and in 2022 it’s still a great performer. But now it’s time for a refresh: X9-2 specs have just been published by Oracle, and machines should be soon available. So what’s new? What is Oracle…
Introduction The Intelligent Query Processing (IQP) feature family is extended with SQL Server 2022.One of the most anticipated features is the Parameter Sensitive Plan optimization. I started to test this new feature. In this post, you will find some information to understand how it works and make your first tests too. The issue with Parameter Sensitive Plan Parameter Sensitive Plan,…
This is a small blog post to share that the SQL Server 2022 public preview is available for download. The Microsoft announcement blog post and a summary of the new feature are available here : Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation I have already installed it. No crazy change regarding the installation Wizard.…
One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source database system. When you plan such a project, you need to know which tools you want to use and what the target architecture shall look like.…
During previous months, I’ve had some time to satisfy my curiosity about databases in containers and I started to test a little bit MySQL in Kubernetes. This is how it all began… In January I had the chance to be trained on Kubernetes attending the Docker and Kubernetes essentials Workshop of dbi services. So I decided to prepare a session…
It’s been a while since I wrote the blog post about PostgreSQL 13 and Patroni 2.0. On this blog I received a comment, if it’s possible to explain, how to upgrade from Patroni 1.6 to 2. So let’s make a short blog about the upgrade procedure of Patroni. For my initial installation is used python pip, not the rpm packages.…
Within the first part I have described the setup of Consul as replacement for ETCD. Here now the setup ob keepalived, haproxy and patroni. The needed packages I have installed within the first part, so let’s start with the configuration of keepalived. At first we need to open firewalld for the VRRP Protocol: $ [root@patroni-01 ~]# firewall-cmd –add-rich-rule=’rule protocol value=”vrrp”…
By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers. One option is to manually create the Data Guard as we do in a non-ODA environment. The second option that I am showing is…
