Setting up a Connection Pooler for PostgreSQL on EC2 Instances
In the world of database management, PostgreSQL stands tall as a powerful and reliable open-source relational database system. However, as database workloads grow, efficient connection management becomes crucial for maintaining performance and scalability. This is where connection poolers like Pgbouncer come into play. In this blog post, we'll explore the setup and configuration of [...]
Backing up & Restoring a Highly Available PostgreSQL Cluster with S3
In our previous blog posts, Setting up a highly available PostgreSQL Cluster with Patroni using Spilo Image, we embarked on a journey to set up a highly available PostgreSQL cluster managed by Patroni using the Spilo image. We saw how Patroni, in collaboration with an etcd cluster, elevates PostgreSQL to new heights of availability [...]
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 [...]
Bereitstellung von AWS-Ressourcen mit Ansible
In diesem Abschnitt werden wir lernen, wie man AWS-Ressourcen lokal bereitstellt. Wir werden die Ansible AWS Collection verwenden, um die AWS-Ressourcen bereitzustellen. Wir werden die folgenden AWS-Ressourcen erstellen: VPC Subnet Internet Gateway Route Table Security Group EC2 Key Pair EC2 Instance Voraussetzungen Um AWS-Ressourcen bereitzustellen, benötigen [...]