From owner-freebsd-database@FreeBSD.ORG  Thu Oct  9 01:20:13 2003
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 4034D16A4C0; Thu,  9 Oct 2003 01:20:13 -0700 (PDT)
Received: from gioria.dyndns.org (dyn-81-166-39-174.ppp.tiscali.fr
	[81.166.39.174])	by mx1.FreeBSD.org (Postfix) with ESMTP
	id 72F6343F93; Thu,  9 Oct 2003 01:20:11 -0700 (PDT)
	(envelope-from eagle@gioria.dyndns.org)
Received: by gioria.dyndns.org (Postfix, from userid 501)
	id A3914374B9; Thu,  9 Oct 2003 10:30:16 +0200 (CEST)
Date: Thu, 9 Oct 2003 10:30:16 +0200
From: Sebastien Gioria <gioria@FreeBSD.ORG>
To: Jeremy Zawodny <jzawodn@yahoo-inc.com>
Message-ID: <20031009103016.A62236@thorm.gioria.dyndns.org>
References: <20031008095226.A18491@thorm.gioria.dyndns.org>
	<20031008145538.A64913@yahoo-inc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5.1i
In-Reply-To: <20031008145538.A64913@yahoo-inc.com>;
	from jzawodn@yahoo-inc.com on Wed, Oct 08, 2003 at 02:55:38PM -0700
X-Hostname: thorm.gioria.dyndns.org
X-Uptime: 10:21AM  up 13 days,  3:11, 1 user, load averages: 1.32, 1.10, 1.04
X-FreeBSD-Release: FreeBSD-4.7-STABLE
cc: freebsd-database@freebsd.org
cc: Sebastien Gioria <gioria@freebsd.org>
cc: freebsd-cluster@freebsd.org
Subject: Re: Clustering mysql
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Sebastien Gioria <gioria@FreeBSD.ORG>
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: Thu, 09 Oct 2003 08:20:13 -0000

On Wed, Oct 08, 2003 at 02:55:38PM -0700, Jeremy Zawodny wrote:
> On Wed, Oct 08, 2003 at 09:52:27AM +0200, Sebastien Gioria wrote:
> > Hi guys,
> > 
> > Anybody does have any experience in clustering mysql ? 
> 
> It depends what you mean by clustering.  Can you talk more about what
> you're trying to do?

I'm trying to setup a Database server who is shared by a number of
web server. This database server will be hosting more than one
database.

I don't want to change anything on the web server when my
database failed. I want the connections to be redirect
to the slave/backup database server .

	S.	

-- 
Sebastien Gioria(48.8147,2.3622)   gioria@{FreeBSD,FreeBSD-FR}.ORG
French FreeBSD User Group    	         http://www.FreeBSD-FR.ORG
FreeBSD committer			    http://www.FreeBSD.ORG
*-> FreeBSD + RollerBlade + Scuba Diving; What need you more ? <-*