The purpose of this project is to migrate data from an existing API to a new database and then horizontally scale the server with AWS EC2 instances that would interact with the database. I chose to use PostgreSQL for this project.
I additionally added an EC2 instance which utilized NginX to act as a load balancer. I used the least-connected technique to distribute requests to my server instances.
The first leg of this sprint was to populate a PostgreSQL database with entries from a CSV. Complex nested SQL queries were created to return the data in the same structure as it was delivered to us in the FEC project. Local Machine testing was perfomed using K6, once acceptable metrics were achieved I moved to the second leg.
The second leg of the sprint was to upload my database to the cloud using AWS, as well as create a server that could interact with that database. I created three instances of my server and set up load balancing.
- Node.js provides an asynchronous event-driven runtime environment for building scalable network applications
- Express was chosen for it's minimal interface and flexible HTTP routing methods
- PostreSQL is used here as a robust and stable open source database
- NGINX enables load balancing HTTP traffic between between many routers
$ npm install
$ npm run start
Set up a .env with the following:
- .env example file
NGINX is used with the method least connected to distribute requests between three servers.
