stereowrench.com
The article discusses the exploration of High Availability (HA) and backup solutions for MySQL and PostgreSQL, including Point-In-Time Recovery (PITA) and full backups, highlighting the complexity of setting up such systems. The writer mentioned specific solutions like Patroni for PostgreSQL and WAL-G for both MySQL and PostgreSQL, as well as the Crunchy Data PostgreSQL Operator and MOCO operator for Kubernetes. The conclusion was a decision to move to Kubernetes for its support of HA, PITR, and regular full backups.
Main Points
Exploring High Availability and Backup Solutions
For PostgreSQL, the writer found Patroni for HA and was referred to WAL-G for both MySQL and PostgreSQL. They came across the Crunchy Data PostgreSQL Operator and the MOCO operator for Kubernetes, which supported HA, PITR, and regular full backups.
Decision to Move to Kubernetes
The writer will be moving to Kubernetes as it supports the required features such as HA, PITR, and regular full backups.
Links
- Patroni
- WAL-G
- Crunchy Data PostgreSQL Operator
- MOCO operator
- Setup Linode Volume Storage with Terraform and Ansible
URL
https://stereowrench.com/2024/02/23/null-results-for-database-operations/