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,
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
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 :)
Brancaleoni Matteo <mbrancaleoni@stripped>