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.
Start the discussion at forum.stereowrench.com