My company has 9 production MySQL servers.
Our company does:
over 4 billion queries a week — an average of over 450,000 per
machine, though in reality 2 servers do near 1 billion
themselves, 5 do about the average, and 2 do much less (about 65k
and 100k queries).
receive over 1380 GB (almost 1.35 TB!!) of data per week, an
average of over 153 GB per server.
send out over 1400 GB of data per week, an average of 157 GB per
server.
Our hardware is only somewhat beefy — 64-bit architecture, 3.20
GHz Intel(R) Xeon(TM) CPU, 6GB of RAM in 4 of the 5 most-used
servers (4GB in the others).
We make over USD $220,000 per week ($10 billion per year) in
sales for our web application.
If we bought the highest level of service, Platinum, for all 9
production machines, the cost would be 0.40% of our sales. The
cost would be less than the cost of a new IT person (even a
junior IT person!), and …
[Read more]