MySQL Forums
Forum List  »  NDB clusters

Re: MySQL Clustering
Posted by: Harrison Fisk
Date: October 13, 2004 11:22AM

Hi,

MySQL Cluster was originally designed to be a main memory database, meaning, as you have stated, that you need to have enough memory across the entire cluster to accomidate your data. Keep in mind that is the memory across the entire cluster setup.

So if you had 12 nodes that each had 8 GB of ram, then you would have 12*8=96 GB of ram total. Now depending on the number of replicas you tell it to keep (for HA purposes), then you will have less than this. The normal setting is to have 2 replicas, which would give you 96/2 = 48 GB of memory for data and indexes roughly. Keep in mind there is some overhead as well, but that is a rough number.

With all of that said, there have been some efforts to allow disk based data as well. I believe that blob and text fields are now stored on disk in the most recent versions. In a future version, (most likely MySQL 5.0), there should be the option to store the entire table data on disk as well.

Regards,

Harrison

Options: ReplyQuote


Subject
Views
Written By
Posted
4072
October 11, 2004 05:31AM
Re: MySQL Clustering
2823
October 13, 2004 11:22AM
2952
November 01, 2004 11:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.