Re: Cluster on Disk - Status ?
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 :)
Subject
Views
Written By
Posted
4169
April 02, 2005 03:40PM
2091
April 03, 2005 04:10AM
2107
April 03, 2005 08:24PM
2153
April 04, 2005 05:46AM
2169
April 04, 2005 07:18AM
2109
April 05, 2005 11:23PM
2212
April 06, 2005 05:08AM
2208
April 06, 2005 03:33AM
2196
April 07, 2005 11:37AM
2223
April 06, 2005 04:20AM
2053
April 06, 2005 05:10AM
Re: Cluster on Disk - Status ?
2258
April 06, 2005 10:49AM
2403
April 07, 2005 06:07PM
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.