[Phpwm] Load Balancing and redundancy

Alex Mace alex at hollytree.co.uk
Fri Mar 23 11:31:42 GMT 2007

5.1 is still currently beta though, so perhaps not the best option for a
production environment. 5.0 is fine, depending on the size of your database.
There's a formula for working out how much memory you require per data node,
which is

1.1 * size of database * no of replicas / number of data nodes

To get any redundancy you need at least 2 replicas of the data. So if you've
got a database bigger than a few gigs you'll either need a small number of
machines with loads of memory or lots of machines with some memory. The docs
on dev.mysql.com are good though. Like I said before, replication is
probably simpler...

On 23/03/07, Alastair Battrick <al at aj8.org> wrote:
> Dave Holmes wrote:
> > From what I recall cluster is great for low volumes of data as all of
> > it is held in memory, but I could be wrong here. Has anyone actually
> > implemented a cluster for large databases, and by this I mean 40GB
> > and bigger
> http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html
> > Beginning with MySQL 5.1.6, it is possible to store the non-indexed
> > columns of NDB tables on disk, rather than in RAM as with previous
> > versions of MySQL Cluster.
> Though I haven't implemented it yet
> --
> Alastair Battrick
> http://www.aj8.org
> _______________________________________________
> Phpwm mailing list
> Phpwm at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/phpwm

More information about the Phpwm mailing list