Null Results for Database Operations

Recently I was looking into High Availability (HA) and backup solutions for MySQL and PostgreSQL (Point-In-Time-Recovery, PITA; and full backups). For PostgreSQL I was turned onto Patroni for HA and for both MySQL and PostgreSQL I was referred to WAL-G.

This looked pleasant. However, as I began to dig in to the setup for these systems I found that things were not so simple.

Eventually, I cam across the Crunchy Data PostgreSQL Operator which solved all my problems if I was on Kubernetes. For MySQL I found the MOCO operator for Kubernetes. Both of these support HA, PITR, and regular full backups.

So it looks like I’ll be moving to Kubernetes.