An online marketplace company managed a 6-terabyte database using an old version of Amazon RDS PostgreSQL version 9.3. With the gaining popularity of their platform, they needed a way to scale the performance and size of their database near term to 15-terabytes. They also had several performance issues including a daily batch script that was taking almost 2 hours to complete that was starting to exceed the maintenance window, and simple tasks like adding a new column to their largest table would time out. The main challenge for the migration project was that downtime could not exceed 6 hours and test efforts by their DBA team could never meet the requirement.
In this blog post, we will walk through two things:
- The various options for upgrading their PostgreSQL 9.3 server to 9.6
- The process of migrating them to Amazon Aurora from RDS
Please read on to see how we were able to complete the entire migration process in under 3 hours and take advantage of the performance of Amazon Aurora for PostgreSQL.