High-Scale Database Migration & OS Upgrade
Executed dual migration paths: moving on-prem PostgreSQL to AWS Aurora RDS for cloud scalability, and migrating legacy Postgres workloads from Rocky Linux to Ubuntu LTS.
5TB+
Data Migrated
3x
Performance Boost
Zero
Data Loss
The Challenge
The legacy database infrastructure running on Rocky Linux was facing end-of-life support issues and performance bottlenecks. Concurrently, the business needed to offload database maintenance to a managed service for critical workloads to improve reliability.
The Solution
Designed a comprehensive migration plan covering two distinct paths.
- Cloud Migration (Aurora RDS): Utilized AWS DMS (Database Migration Service) to replicate data continuously from on-prem to Aurora PostgreSQL, ensuring minimal downtime during the final switchover.
- OS Platform Re-hosting: Provisioned new high-performance Ubuntu servers and used `pg_dump/pg_restore` with parallel processing for large tables to migrate remaining on-prem databases.
- Performance Tuning: Optimized `postgresql.conf` parameters (shared_buffers, work_mem) on the new environments and implemented connection pooling with PgBouncer.
- Validation: Developed automated scripts to verify row counts and data integrity between source and destination before sign-off.
Tech Stack
PostgreSQL
AWS Aurora RDS
Rocky Linux
Ubuntu LTS
AWS DMS
PgBouncer