MySQL Cluster: Difference between revisions

Revision as of 16:34, 14 April 2006

Revision as of 14:35, 11 May 2006

Line 26:

==Limitations==

The largest limitation currently is with the fact that it is largely an in-memory database. All indexed columns reside entirely in memory. This means that across the cluster setup, you need enough RAM to store much of the entire dataset. In Nonthe 5.1 release, non indexed columns arecan be stored on disk and don't require dedicated RAM. In 5.1, all indexes still need to be in main memory though.

Another limitation is with how many nodes can be part of the cluster. Currently you can only have up to 64 nodes in the cluster with up to 48 of those being data nodes that store the actual data. It is possible to change this at compile time, but that has not been thoroughly tested at this point.

Line 32:

Also of note, The current maximum number of metadata objects is limited to 1,600. (including database tables, system tables, indexes, etc.)

Other limitations for 4.1 are listed in the [http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Limitations_in_4.1.html MySQL 4.1 Manual]

==Alternatives==