Refactored monolithic ecommerce backend microservice optimized to support high traffic
Structured Schema used to plan out the Database Structure:
Created Database and Tables to match Schema.
PostgreSQL server can handle multiple concurrent connections from clients.
Created ETL to unify data being imported into DB locally.
Improved PostgreSQLqueries speed from 25s to 0.30ms by analyzing execution plans and implementing indexes and aggregations
Migrated over the Data to AWS EC2 Instance through PostgreSQL built-in migration function.
Successfully imported Data to AWS EC2 instance!
Scaled application to sustain 4000 RPS by horizontally scaling with NGINX through 4 AWS instances and Redis caching
Performance Testing:
