i'm writing a business plan and i have to simulate the cost when my website will be reach from 500.000 unique visitors.
visitors: 500.000 pageviews: 1,500,000 spider pageviews: 500,000 total pageviews: 2,000,000
each page does 50 queries +-
queries per day: 100 Millions per hour: 4 millions per minute: 70,000 per second: 1,200 peak: 3,000
Doing this calculation i need 3,000 queries second... what kind of server can handle it?
the problem is: actually my site is doing 2,000 visits day, and having -+ 150/200 queries / second... starting from this point i'll expect 50,000 queries / second.
how many servers i need in cluster or replication do manage this job?