I am working with a client who has an application distributed across 2 HTTP servers and 2 dB servers. To me this just seems excessive given what a single machine can to these days. Can I please get some feeback from you guys what you feel is an appropriate hardware config for the following? Am I crazy for thinking that (failover issues aside) the site and dB could probably run on a single box with a good processor and maybe 1 GB or RAM?
App Description: Apache/PHP/MySQL webapp Only 10% of the pages are data-driven Fair amount of flash elements on the pages
Stats: 35,000 uniques visitors per day 30 hits per second at peak traffic time 14kb file size per hit 25 GB traffic per day (750 GB per month)
I would keep that setup, don't combine the Db server and web server, depending on OS (NT based )you could start to run into memory leakage problems if you want to cut down on server you could run 2 http and 1 db server.. our db servers have has standard 2gig memory dual xeon
I can see the value of running 2 load balanced servers for failover, ... but wouldn't your suggestion of running 2 http servers and 1 dB server defeat the purpose of running 2 http servers? I mean, assuming the purpose of 2 load-balanced servers is to provide for redundancy, in the case of a data-driven web application, if the 1 dB server goes down, you still havea single point of failure, and no failover for the dB, thus the entire webapp would be down in that case, wouldn't it?