Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

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.

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-overview-requirements.html

share|improve this answer
add comment

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.

regards,

Mulyadi blog: the-hydra.blogspot.com

share|improve this answer
add comment

Your Answer

 
discard

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.