Zero-downtime database migration for Fielddesk
Moved a 2 TB production database to a managed service without downtime. A case study by Oleksandr Bondarenko, DevOps & Cloud Engineer (AWS, Kubernetes).
Challenge
Fielddesk, a field service software company, ran a self-managed PostgreSQL server that was running out of disk and had no failover. Any maintenance window meant lost sales.
Solution
I set up logical replication to Amazon RDS, validated data continuously, switched application traffic with a short read-only phase measured in seconds, and kept the old server as a fallback for a week.