Re: Cluster on Disk - Status ?

[Mikael Ronström]

Troy Rose wrote:
> Well, Carsten, nobody said that MySQL Cluster
> needed RAM - just memory.
>
> If you have relatively fast disks (say, Ultra
> 320's), that might be in a RAID - striped
> configuration, why not create a swap partition of
> anything up to 16GB? There would be a performance
> hit, nobody's questioning that, but it turns an
> in-memory cluster into an on-disk cluster. That's
> the configuration I'm currently working with in a
> test environment, and it seems to work without a
> hitch - simply fooling the ndb components that
> they actually have 4GB of memory, when in reality
> there's only 1 GB on each node.

You'll probably be disappointed when you do a query that
makes a full table scan since the entire table has to be loaded
into RAM from disk a page at a time. Also during this processing
it is easy to get heartbeat failures.

Rgrds Mikael
PS: Sorry if I am a bit pessimistic :)