Re: NEED help to fix cluster design issue of 40 terabytes

[Stewart Smith]

Standard vendors: SGI, HP, IBM, Sun etc.

I *strongly* recommend some consulting work for this scale of project. Much more comprehensive advice than me spending a few minutes looking at a forum :)

since 16 fields are indexed, they must be in memory in 5.1. the 2kb field could be on disk though (which could be close to half your data).

Standard rules for number of nodes and redundancy apply. If you want 2 copies of the data (NoOfReplicas=2), then you need twice as much memory as you have data. e.g. a 10GB database could be set up in one of the following ways (for 2 replicas):

a) 2 data nodes each with 10GB memory
b) 4 data nodes, each with 5GB memory
c) 8 data nodes, each with 2GB memory (which would give you room for 16GB of data)

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html