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 appreciated...

thanks!

Hi,

As usual, everything is heavilly dependant on your specific scenario.
Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes
benefit from I/O (more, faster disks).


Regards,
Ricardo

That is not a question that can be answered directly... it come down
to exactly how much data you expect to be handling, how many nodes you
plan on using and what your proposed node configuration might be..
generally, a lot of RAM always s and in a RAM-based solution like
NDB, of course it's likely to come in handy, but if your data is
small, adding RAM will have no effect. As for the effectiveness of
multi-cores, again, what kind of concurrency load are you expecting?

The question is a fairly complex one and has everything to do with
ones particular circumstances: that is why there are no simple
answers.


On 8/31/07, Sid Lane <jakes.dad@gmail.com> wrote:
> 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 appreciated...
>
> thanks!
>


--
- michael dykman
- mdykman@gmail.com

- All models are wrong. Some models are useful.


--
- michael dykman
- mdykman@gmail.com

- All models are wrong. Some models are useful.

Hello,

If you have not already done so, check out the Cluster Eval Guide which has some tips which may assist you in your process. Much
of the content was put together by the professional services group here at MySQL.

http://www.mysql.com/why-mysql/white...eval_guide.php

Also, there is a cluster specific list: cluster@lists.mysql.com

Jimmy Guerrero
Sr Product Manager
MySQL, Inc
Houston, TX

Ricardo Oliveira wrote:
> Hi,
>
> As usual, everything is heavilly dependant on your specific scenario.
> Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes
> benefit from I/O (more, faster disks).
>
>
> Regards,
> Ricardo
>