Quote:
Originally posted by Trafficbrokercom
15 webservers ? ... you are doing something wrong ..
a friend of mine runs his large dating site off one web- and one databaseserver .. (P4 2,8 ghz with 2 gig ram each) ..
he has more than 800,000 page impressions each day , plus it is not just a cheap dating site but based upon a "yes/no" system where only a match can write a match ..
so go figure 25 million votes in one table being selected on several inner joins against other tables with 14+ million votes in one query on a super busy cheap webserver .. the query executes in less than 0.1 seconds and the load is rarely above 0.8 ..
this is what I call performance and being cost productive ..
the success and costs of a project is based on the database structure ..
btw, the free turck mm cache is used on his server and not zend ps ..
15 webservers? .. my advice again: fire your programmers ..
|
The webservers are also shared for some of our other websites....however IwantU is most of the load.
The databases could probably only run from one (with another for backup/redundancy purposes), with the exception of browsing which is the biggest load. Running it from a few databases using mysql's native replication, it never has any lag / problems.
Pageviews alone don't determine the hit on the servers though. In your friend's case, perhaps he has barely any features on his site (from what you wrote above), thus having very low concurrent connections. In our case, for example, just our interface to chat/IM/webcam will require more resources than a simple yes/no messaging system like your friend has.