List:Cluster« Previous MessageNext Message »
From:Brancaleoni Matteo Date:July 14 2004 8:14pm
Subject:Re: 157 GB MyISAM DB
View as plain text  
Hi

This for sure are very interesting questions.
And I hope someone from mysql will jump here
to give us the right answer :)

Btw, as far as I've understood, data is
also fragmented between nodes:
For example, on a 4 storage nodes setup,
with 2 replicas, you'll have the data
fragmented into 2 pieces, replicated each 2 times,
something like

#1) Fragment-1,Fragment-3
#2) Fragment-1,Fragment-3
#3) Fragment-2,Fragment-4
#4) Fragment-2,Fragment-4

so your data is divided in four parts (as each node)
and replicated 2 times each.
Add more nodes to add more distribution :)
see page#8 of cluster admin manual for a detailed
explanation.
So I *think* that with 16 dbnodes, with 16GB ram each,
you can handle 16/2 (2 replicas for fragment) * 16(nr of 
db nodes) = 128 GB db.

this is what I've understood, perhaps I'm wrong,
but I think is reasonable...

hope mysql people can drop a light here :)

Matteo



-- 
Brancaleoni Matteo <mbrancaleoni@stripped>
Espia Srl

Thread
157 GB MyISAM DBThomas B√∂hme13 Jul
  • Re: 157 GB MyISAM DBRichard F. Rebel14 Jul
    • Re: 157 GB MyISAM DBBrancaleoni Matteo14 Jul
    • Re: 157 GB MyISAM DBJonas Oreland14 Jul
      • Re: 157 GB MyISAM DBRichard F. Rebel14 Jul
        • Re: 157 GB MyISAM DBJonas Oreland14 Jul
        • Re: 157 GB MyISAM DBJeremy Zawodny16 Jul