MySql Load balancing Solutions?

Jim C. Nasby decibel at decibel.org
Tue Feb 1 16:55:55 PST 2005


On Tue, Feb 01, 2005 at 06:51:22PM -0600, Doug Poland wrote:
> On Tue, Feb 01, 2005 at 04:38:24PM -0800, Drumslayer wrote:
> > Hi
> >  I have been running a fairly heavy duty server for MySQL on FreeBSD
> >  but its starting to peak. I would like to know what others have done
> >  as far as using a load balancing solution for MySQL or their success
> >  with replication.  Also has anyone done a 64 bit build of MySQL on
> >  FreeBSD successfully?
> > 
> I'd take a look at MySQL's own clustering solution:
> 
>   http://dev.mysql.com/doc/mysql/en/ndbcluster.html 

Something to be aware of; if the binlog partition fills, the master will
happily continue accepting transactions, which means your slaves are now
useless.
-- 
Jim C. Nasby, Database Consultant               decibel at decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


More information about the freebsd-database mailing list