| #! /usr/bin/env bash | |
| # | |
| # You will need the spark core cli installed first (and nodejs): | |
| # npm install -g spark-cli | |
| # spark cloud login | |
| # | |
| # To set SSID and PASSPHRASE, change below or run: | |
| # git config spc.wifi.ssid YOUR_SSID | |
| # git config spc.wifi.passphrase YOUR_PASSPHRASE |
Our db is hosted on Amazon. Our web server can connect to the db. Connections to the db are not allowed outside of the web server.
This creates a tunnel from my local machine to the web server:
ssh -N -L 3307:my-rds-db.us-east-1.rds.amazonaws.com:3306 ec2-my-web-server.compute-1.amazonaws.com
For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.
Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.
You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.