I have a website that contains one PHP page that runs 3 simple SQL queries to MySQL database
2 simple select queries and 1 simple update.
The HTML output with some images is 500 KB
The server needs to deal with 50-150 requests per second.
Can you help me decide the minimum specifications that the server needs in order to ensure 100% uptime?
Best Answer
500 KB * 150 req/s = 73 MByte/sec, or 586 Mbit/sec. That's a significant amount of bandwidth: almost 190 TByte/month of transfer. Putting hardware in place to support this is actually pretty easy; you could probably get by on a (beefy) VPS if "simple" really means "simple", but the bandwidth is going to be a stumbling block, as most VPS hosts are going to balk at (or charge exorbitant rates for) that kind of monthly transfer.
Do you want to host everything yourself in full, geo-dispersed HA, or is it worth offloading some of the hosting onto a CDN?