Skip to content

Databases

Using etcd as Patroni DCS with the Zalando Postgres Operator

Patroni is a reliable cluster software for Postgres which, when running on Kubernetes, can use the Kubernetes API itself as DCS (Distributed Config Store). This is very nice, but on Kubernetes clusters with an unreliable API / Controlplane, this can lead to demotion of your cluster leader and thereby unhappy users. Gladly, Patroni supports other setups as DCS like etcd.

Read More »Using etcd as Patroni DCS with the Zalando Postgres Operator

A pinch of salt – Encrypt WAL-G PostgreSQL backups

WAL-G is a widely known backup software for Postgres databases. One of it’s features is to backup to S3 storage out of the box. Also it’s capable to encrypt those backups and WAL archives with several encryption methods (e.g. libsodium). Since WAL-G is implemented within the Zalanndo Spilo image and therefore deployed by default with the Zalando Postgres Operator on Kubernetes, I had a deeper look on how to get encrypted backups implemented there, cause this is not documented well.

Read More »A pinch of salt – Encrypt WAL-G PostgreSQL backups

Bastard Operator from Hell? – Giving the Kubernetes Oracle Database Operator a try

Oracle want’s to participate in the open source movement lately, making itself known as “an Open Source company”. Part of this is the Oracle Database Operator for Kubernetes. It’s an early version (0.1.0) that I’ve tested out, so it offers only a limited set of features as of now. Let’s move it to it’s paces, shall we?

Read More »Bastard Operator from Hell? – Giving the Kubernetes Oracle Database Operator a try

Restore and Clone from S3 – Configure Zalando Postgres Operator Restore with WAL-G

In an earlier blogpost, I wrote about doing Postgres backups using WAL-G to a S3 storage. This time we have a look to either clone or “inplace” restore a postgres instance from these backups. All of this using the Zalando Postgres Operator. If you haven’t done so, please read the backup post before proceeding reading this one.

Read More »Restore and Clone from S3 – Configure Zalando Postgres Operator Restore with WAL-G

Backup to S3 – Configure Zalando Postgres Operator Backup with WAL-G

Doing basebackups of Postgres databases enables you to do a Point-in-time recovery (PITR) of your database. Doing backups for your databases that have been deployed using the Zalando Postgres Operator, is a different beast. Here I show you how it’s done with a MinIO (self)hosted S3 compatible Object Storage.

Read More »Backup to S3 – Configure Zalando Postgres Operator Backup with WAL-G

Pythia – An Oracle DB Automation Story – Chapter 2 – Install RDBMS and Database

The most basic Feature of Pythia is, to install an Oracle Database RDBMS on a Linux machine of your choice. The RDBMS Installation will most likely be combined with other Tasks (TAGs) you want to have done by Pythia. Beside the RDBMS, we will build us an Oracle Database in this article. All done by one line of command.

Read More »Pythia – An Oracle DB Automation Story – Chapter 2 – Install RDBMS and Database

Pythia – An Oracle DB Automation Story – Chapter 1

Maintaining an Oracle Database can be a pain sometimes. I admit that. It’s a massive Software, with so many facets in features, functionality and restrictions. Having to manage several hundreds (if not thousands) of Oracle Databases in my former job, I was searching for some automation to make my life easier. And also here, there are many tools that answer some of my needs but nothing seemed really usable for my individual needs. Second, I was eager to get knowledge in Ansible as an Automation Tool by myself. So I decided to write it on my own. This is the story behind Pythia, my Oracle Database Automation Toolset.

Read More »Pythia – An Oracle DB Automation Story – Chapter 1

Oracle Datenbank in Docker betreiben

Eine Oracle Datenbank in Docker zu betreiben ist im Jahr 2021 keine Selbstverständlichkeit. Nein im Gegenteil, es gibt zwar einige vorgefertigte Docker Images bzw. Hilfsmittel um diese zu erstellen, diese kommen aber mit einigen Einschränkungen daher. Grund für mich, meine eigene (angepasste) Anleitung zur Erstellung eines Docker Images für eine Oracle Datenbank zu schreiben. Aber leider kommt auch diese nicht ohne Einschränkungen daher.

Read More »Oracle Datenbank in Docker betreiben