>> I'm looking for a database+hardware solution which should be
>> able to handle up to 500 requests per second.
What proportion of reads and writes in those 500 tps ?
(If you have 450 selects and 50 inserts/update transactions, your
hardware requirements will be different than those for the reverse
proportion)
What is the estimated size of your data and hot working set ?