On Sun, 2005-01-30 at 21:13 -0500, Jesse Erlbaum wrote:
> Please explain what you mean by "spread around your storage nodes". Do
> you mean that if I calculate that I need 1 gig of RAM, that I could
> allocate 250 megs of ram on each of four cluster nodes?
yes, assuming NoOfReplicas=1
if you want redundancy (a good idea), then you can have 512MB on each
node.
> (Size of database * NumberofReplicas * 1.1) / Number of storage nodes
this is in the manual somewhere too.
> This certainly is easier than adding up all the minutia. IOW, on disk I
> have a database which takes 27 megs. I have two nodes on my cluster
> (not counting the management node). So:
>
> 27 * 2 * 1.1 = 59.4 megs
>
> Does that sound right to you?
yeah, that should be a rough estimate.
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +61 4 3 8844 332
Are you MySQL certified? www.mysql.com/certification
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
