Database Administration & Monitoring

MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly

A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x).

Patroni Operations – Changing Parameters

Sooner or later all of us have to change a parameter on the database. But how is this put into execution when using a Patroni cluster? Of course there are some specifics you have to consider. This post will give(…)

PostgreSQL 13 will come with partitioning support for pgbench

A lot of people use pgbench to benchmark a PostgreSQL instance and pgbench is also heavily used by the PostgreSQL developers. While declarative partitioning was introduced in PostgreSQL 10 there was no(…)

PostgreSQL check_function_bodies, what is it good for?

One of the probably lesser known PostgreSQL parameters is check_function_bodies. If you know Oracle, then you for sure faced "invalid objects" a lot. In PostgreSQL, by default, there is nothing like an invalid object. That implies(…)

Adding a dbvisit standby database on the ODA in a non-OMF environment

I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database,(…)

Having multiple standby databases and cascading with dbvisit

Dbvisit standy is a disaster recovery solution that you will be able to use with Oracle standard edition. I have been working on a customer project where I had to setup a system having one primary and two standby databases.

Connecting to ODA derby database

ODA light (ODA X7-2S, X7-2M, X8-2S, X8-2M) come with an internal derby database to manage ODA metadata. From time to time, there is a need to check or update some information within it, as for example when facing database deletion(…)

Why you really should use peer authentication in PostgreSQL

It is always a bit of a surprise that many people do not know peer authentication in PostgreSQL. You might ask why that is important as initdb creates a default pg_hba.conf which(…)

Where can you find core developers asking people what is missing in PostgreSQL? pgconf.eu.2019

One of the major advantages of PostgreSQL conferences when you compare it to other conferences is, that you can listen to talks where the actual developers are presenting their work. You have questions about a feature, you want to know(…)

Creating a customized PostgreSQL container using buildah

Quite some time ago I blogged about how you could build your customzized PostgreSQL container by using a Dockerfile and Docker build. In the meantime Red Hat replaced Docker in(…)