hardware & clusters

all,

I am working on a budget proposal for next year to put in a MySQL cluster but wanted to validate (or correct) a couple of assumptions:

1. do storage nodes benefit far more from additional RAM than they do from faster CPUs/multiple cores?
2. do SQL nodes benefit more from faster CPUs/multiple cores?

basically, I am trying to find the best bang/buck configuration for each server type and am assuming it's better to spend more $ on RAM for storage nodes and CPU for SQL nodes - is this correct?

is anyone aware of any benchmarking that has been done with various configurations?

any help appreciated...

thanks! Received on Fri Aug 31 10:35:19 2007