From owner-freebsd-database@FreeBSD.ORG  Wed Feb  2 00:55:55 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 49F1C16A4CE
	for <freebsd-database@freebsd.org>;
	Wed,  2 Feb 2005 00:55:55 +0000 (GMT)
Received: from flake.decibel.org (flake.decibel.org [66.143.173.58])
	by mx1.FreeBSD.org (Postfix) with ESMTP id DB8CA43D3F
	for <freebsd-database@freebsd.org>;
	Wed,  2 Feb 2005 00:55:54 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by flake.decibel.org (Postfix, from userid 1001)
	id 115AE1C90A; Tue,  1 Feb 2005 18:55:52 -0600 (CST)
Date: Tue, 1 Feb 2005 18:55:51 -0600
From: "Jim C. Nasby" <decibel@decibel.org>
To: Doug Poland <doug@polands.org>
Message-ID: <20050202005551.GT32356@decibel.org>
References: <20050202003824.12705.qmail@web42107.mail.yahoo.com>
	<20050202005122.GA14791@polands.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050202005122.GA14791@polands.org>
X-Operating-System: FreeBSD 4.10-RELEASE-p3 i386
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.6i
cc: FreeBSD Database <freebsd-database@freebsd.org>
Subject: Re: MySql Load balancing Solutions?
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 02 Feb 2005 00:55:55 -0000

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@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?"