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!