Ensuring High Availability with Patroni: Handling Failover
Nowadays, high availability and data integrity are the most important things in the database world. Downtime and data loss can be very expensive for any company. One way to avoid this is by having a failover mechanism. Failover is a mechanism that allows a system to continue operating, possibly at a reduced level, rather [...]
Get Notified: Setting Up Alerts in Grafana
If you are using Grafana to monitor your systems, you are already ahead of the game. But did you know that you can also use Grafana to set up alerts? This is a great way to get notified when something goes wrong with your systems. In this blog post, we will show you how to [...]
Coordinating OS Update on Multiple Fedora CoreOS Machines
Fedora CoreOS is a lightweight, container-focused operating system. It is designed to be updated automatically and frequently with atomic updates. This means that the entire operating system is updated as a whole. This is a great feature for keeping your system up to date and secure, but it can be a challenge to coordinate [...]
SELinux: A Mandatory Part of Running a Secure PostgreSQL Database
Data is the most critical asset of any company today. There are many recommendations to secure a PostgreSQL database, e.g. CIS Benchmark for PostgreSQL, but Linux provides already one which you should not avoid: Security-Enhanced Linux (SELinux). SELinux provides access control for files, processes and applications to grant access or deny it. This security architecture [...]
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 [...]