How to Manage PostgreSQL Clusters with GitOps using CloudNativePG and ArgoCD
At PGConf.de in Berlin this year, I had the pleasure of presenting on the powerful combination of CloudNativePG and GitOps. For those who couldn't attend — or anyone looking to streamline their PostgreSQL cluster management — this blog post shows how to apply GitOps principles with CloudNativePG for a more efficient and reliable [...]
Tutorial: Database load testing using HammerDB
HammerDB is an open source database benchmarking software that supports PostgreSQL, Microsoft SQL Server, IBM Db2, Oracle, MariaDB, and MySQL, as well as CLI, local GUI, and a web browser GUI. The benchmarks used by HammerDB, TPROC-C and TPROC-H, are based on the widely used TPC-C- and TPC-H benchmarks. Test results are reported in [...]
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 [...]