Create a small node.js API server

1 Overview This document describes the requirements for a simple node.js API server as well as the setup for a nginx load balancer for this solution. 2 General Requirements • Use the latest version of node.js • Use the latest version of nginx • The solution should work on Windows as well as CentOS platforms. The SQL create table statements and test data in SQL format will be provided. 3 Node.js Server Create a node.js server that will work on Windows and Unix platforms and has the following functionality. • At startup, select all rows from the MySQL ySHUTTLE table where status_id = 1. This will provide a list of valid access_codes. • The query result is stored in memory. • Create an API interface that can be called via HTTP or HTTPS. The API call will have the format for example http://localhost/api?access_code=1234&lat=44.4&lon=75.6 • The node.js server gets the access code from the url • The node checks if the access code is a valid code, meaning the code has to be in the list of access_codes retrieved from the database and stored in memory. In case the code is not valid, a HTTP Status 400 returned. • In case the code is valid, the node.js server inserts a record in the MySQL ySHUTTLE_LOG table with the following field: created date time stamp, lat and lon values (from the url). Please also create instructions on how to start and stop each node.js server as well as configure port. 4 Load Balancer Create step-by-step instructions on how to set up nginx as a load balancer for the node.js servers. The instructions should include the following: 1. Instructions for Windows and CentOs 2. How to add new node.js server instances 3. How to remove node.js server instances 4. How to determine the CPU load on each server instance 5. How to adjust the load that each node.js server instance should receive. PLEASE TRY THE STEP-BY-STEP INSTRUCTIONS OUT SO I CAN BE SURE THAT THEY WORK. :) THANKS!