hardware for MySQL DB

[colet-KCgK2vT7wad/90uGnh1m2w at public.gmane.org (Cole Tuininga)]

Eugene Gorelik wrote:
> I am curious, what kind of hardware do people use to run MySQL DB ?

Depends on how heavily the particular database is going to be used.  :)


> Have anyone tried running MySQL on solid state drives ?

Not yet.  I've heard good things about the performance though.


> How does MySQL scales when adding more CPUs or RAM ?

I was lucky enough to get to attend Sun's MySQL Optimization class.  My
recollection is that much more than 4 cores is not going to give you a
huge benefit, though that's likely to change come MySQL 6 with the new
storage engines.

To quote my instructor though, you can never have enough RAM.  :)  If
you have your configuration settings set appropriately, MySQL can make
use of as much RAM as you want to throw at it.

-- 
Cole Tuininga
Lead Developer
colet-KCgK2vT7wad/90uGnh1m2w at public.gmane.org