Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)?

What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?

share|improve this question
I tried mysql cluster and it was terribly slow compared to MyISAM engine. I tested it on a reasonably powerful machine with 2GB or more. After this test, I setup mysql replication instead. I hope someone else may have had a better experience! – Khaled Dec 22 '10 at 7:31

One of the strengths of MySQL Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in memory.

share|improve this answer

I have no direct experience related to MySQL cluster, but I believe it's due to data caching (aggresively). Theoritically, by caching you anticipate locality pattern i.e one tends to access certain subset of data over and over again, so it makes sense to cache it in local node.

So how much? I believe there's no real threshold. Ram it as much as you can... 2 or 4 Gigs I guess is the reasonable amount..or more if you have bigger data set.


Mulyadi blog:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.