Setting up a highly available PostgreSQL Cluster with Patroni using Spilo Image
Patroni Cluster In the world of modern data-driven applications, having a reliable and available database is a must. This is where Patroni and Spilo come into play. Patroni is an open-source solution for managing high-availability PostgreSQL clusters, and Spilo is a container image that combines PostgreSQL and Patroni, simplifying the deployment of fault-tolerant [...]
Building a High-Availibity etcd Cluster on AWS
Welcome to the journey of building a high-availibity distributed key-value store. In this project we will build an etcd cluster inside Podman containers on AWS EC2 Instances. etcd is an open source, distributed key-value store designed for securely managing configuration data in distributed systems. Using Raft consensus protocol, it ensures consistent data across multiple [...]
Provisioning AWS Resources with Ansible
In this section, we will learn how to provision AWS resources locally. We will use the Ansible AWS Collection to provision the AWS resources. We will create the following AWS resources: VPC Subnet Internet Gateway Route Table Security Group EC2 Key Pair EC2 Instance Prerequisites [...]
PostgreSQL – Vorteile und Anwendungsfälle im Überblick
PostgreSQL, oft abgekürzt als Postgres, ist ein Open-Source-Datenbankmanagementsystem, das vor 25 Jahren als gemeinschaftliches Projekt der Universität Berkeley in Kalifornien entwickelt wurde und nun von einem globalen Team von Open-Source-Entwicklern weiterentwickelt wird. Postgres zählt mittlerweile zu den Top 5 der beliebtesten Datenbanken weltweit für Unternehmen und Organisationen. Was genau macht Postgres zu so einem [...]
How to Create an etcd Container Image with Buildah and RedHat’s UBI
Containers are an inherent part of today's work for developers and operators. They offer an elegant way of providing needed applications started up at the blink of an eye or running at scale in the cloud or a data center. This how to will display one of several options to create such [...]
PostgreSQL Conference Europe 2022
My impressions of the PostgreSQL Conference Europe 2022 in Berlin. Finally, after a forced break of two years, PostgreSQL Conference Europe took place again from October, 25th to 28th in Berlin, Germany. The conference was organized in the Marriott Berlin hotel, a few meters away from Brandenburger Tor. A total number of 604 [...]