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]