15 messages in com.mysql.lists.clusterRe: max database size is limited to R...
FromSent OnAttachments
Casto, Robert31 Oct 2005 12:03 
Claudio Aracena C31 Oct 2005 12:25 
Stewart Smith31 Oct 2005 18:16 
Stewart Smith31 Oct 2005 18:19 
Jimmy Brake01 Nov 2005 11:14 
Simon Garner01 Nov 2005 15:03 
Stewart Smith01 Nov 2005 18:26 
Frank Cases02 Nov 2005 09:32 
pek...@mysql.com02 Nov 2005 10:20 
Kris Buytaert04 Jan 2006 08:41 
Mikael Ronström20 Feb 2006 07:47 
Mikael Ronström20 Feb 2006 11:18 
Kris Buytaert20 Feb 2006 11:24 
Mikael Ronström20 Feb 2006 11:31 
Adam Dixon20 Feb 2006 14:37 
Subject:Re: max database size is limited to RAM size in cluster???
From:pek...@mysql.com (pek@mysql.com)
Date:11/02/2005 10:20:32 AM
List:com.mysql.lists.cluster

Was I wrong ? does the cluster adjust the data on each node according to the ram on each of them ?

No. DataMemory etc should be same for each db node.

Suppose you have 32 db nodes, each with DataMemory 1 gb, and 2 replicas. Then the cluster has 32 * 1 gb / 2 = 16 gb DataMemory.

By default data is distributed by a hash of primary key, so it will be distributed evenly across the 16 nodegroups in the example.

-- Pekka Nousiainen, Software Engineer MySQL AB, www.mysql.com pek@mysql.X.com +46 (0) 73 068 4978