From owner-freebsd-database@FreeBSD.ORG Mon Nov 10 20:44:42 2003 Return-Path: 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 C06E316A4CE for ; Mon, 10 Nov 2003 20:44:42 -0800 (PST) Received: from vette.gigo.com (vette.gigo.com [216.218.228.114]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5C1D343F3F for ; Mon, 10 Nov 2003 20:44:35 -0800 (PST) (envelope-from lioux@brturbo.com) Received: from 200.101.111.208 (200-101-111-208.bsace705.dsl.brasiltelecom.net.br [200.101.111.208]) by vette.gigo.com (Postfix) with ESMTP id 3B12E571A for ; Mon, 10 Nov 2003 20:40:19 -0800 (PST) Received: (qmail 31224 invoked by uid 1001); 11 Nov 2003 04:14:40 -0000 Message-ID: <20031111041440.31223.qmail@exxodus.fedaykin.here> Received: (qmail 4311 invoked from network); 9 Oct 2003 08:47:20 -0000 Received: from unknown (HELO localhost) (unknown) by unknown with SMTP; 9 Oct 2003 08:47:20 -0000 Received: from pop3.uol.com.br by localhost with POP3 (fetchmail-6.2.4) for lioux-lists@localhost (single-drop); Thu, 09 Oct 2003 05:47:20 -0259 (BRT) Received: from peart.uol.com.br (172.26.5.198) by mtauol6.mail.sys.intranet (5.1.071) id 3EDB5A2E018D4610 for lioux-list@uol.com.br; Thu, 9 Oct 2003 05:20:57 -0300 Received: from mx2.freebsd.org (mx2.freebsd.org [216.136.204.119]) by storm14.uol.com.br (Postfix) with ESMTP id D1296D9A8 for ; Thu, 9 Oct 2003 05:20:56 -0300 (BRT) Received: from hub.freebsd.org (hub.freebsd.org [216.136.204.18]) by mx2.freebsd.org (Postfix) with ESMTP id 2F7005572F; Thu, 9 Oct 2003 01:20:46 -0700 (PDT) (envelope-from owner-freebsd-cluster@freebsd.org) Received: from hub.freebsd.org (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id DD0B216A4D8; Thu, 9 Oct 2003 01:20:45 -0700 (PDT) Delivered-To: freebsd-cluster@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) From: Sebastien Gioria To: Jeremy Zawodny 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 X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Sender: owner-freebsd-cluster@freebsd.org Errors-To: owner-freebsd-cluster@freebsd.org cc: freebsd-database@freebsd.org cc: freebsd-cluster@freebsd.org Subject: Re: Clustering mysql X-BeenThere: freebsd-database@freebsd.org Reply-To: Sebastien Gioria List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Date: Tue, 11 Nov 2003 04:44:43 -0000 X-Original-Date: Thu, 9 Oct 2003 10:30:16 +0200 X-List-Received-Date: Tue, 11 Nov 2003 04:44:43 -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 ? <-* _______________________________________________ freebsd-cluster@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-cluster To unsubscribe, send any mail to "freebsd-cluster-unsubscribe@freebsd.org" From owner-freebsd-database@FreeBSD.ORG Mon Nov 10 21:03:58 2003 Return-Path: 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 8B8CB16A4CE for ; Mon, 10 Nov 2003 21:03:58 -0800 (PST) Received: from vette.gigo.com (vette.gigo.com [216.218.228.114]) by mx1.FreeBSD.org (Postfix) with ESMTP id D0DE743F85 for ; Mon, 10 Nov 2003 21:03:39 -0800 (PST) (envelope-from lioux@brturbo.com) Received: from 200-101-111-208.bsace705.dsl.brasiltelecom.net.br (200-101-111-208.bsace705.dsl.brasiltelecom.net.br [200.101.111.208]) by vette.gigo.com (Postfix) with ESMTP id C5B2E5754 for ; Mon, 10 Nov 2003 20:51:59 -0800 (PST) Received: (qmail 26107 invoked by uid 1001); 11 Nov 2003 04:07:32 -0000 Message-ID: <20031111040732.26106.qmail@exxodus.fedaykin.here> Received: (qmail 4311 invoked from network); 9 Oct 2003 08:47:20 -0000 Received: from unknown (HELO localhost) (unknown) by unknown with SMTP; 9 Oct 2003 08:47:20 -0000 Received: from pop3.uol.com.br by localhost with POP3 (fetchmail-6.2.4) for lioux-lists@localhost (single-drop); Thu, 09 Oct 2003 05:47:20 -0259 (BRT) Received: from peart.uol.com.br (172.26.5.198) by mtauol6.mail.sys.intranet (5.1.071) id 3EDB5A2E018D4610 for lioux-list@uol.com.br; Thu, 9 Oct 2003 05:20:57 -0300 Received: from mx2.freebsd.org (mx2.freebsd.org [216.136.204.119]) by storm14.uol.com.br (Postfix) with ESMTP id D1296D9A8 for ; Thu, 9 Oct 2003 05:20:56 -0300 (BRT) Received: from hub.freebsd.org (hub.freebsd.org [216.136.204.18]) by mx2.freebsd.org (Postfix) with ESMTP id 2F7005572F; Thu, 9 Oct 2003 01:20:46 -0700 (PDT) (envelope-from owner-freebsd-cluster@freebsd.org) Received: from hub.freebsd.org (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id DD0B216A4D8; Thu, 9 Oct 2003 01:20:45 -0700 (PDT) Delivered-To: freebsd-cluster@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) From: Sebastien Gioria To: Jeremy Zawodny 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 X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Sender: owner-freebsd-cluster@freebsd.org Errors-To: owner-freebsd-cluster@freebsd.org cc: freebsd-database@freebsd.org cc: freebsd-cluster@freebsd.org Subject: Re: Clustering mysql X-BeenThere: freebsd-database@freebsd.org Reply-To: Sebastien Gioria List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Date: Tue, 11 Nov 2003 05:03:58 -0000 X-Original-Date: Thu, 9 Oct 2003 10:30:16 +0200 X-List-Received-Date: Tue, 11 Nov 2003 05:03:58 -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 ? <-* _______________________________________________ freebsd-cluster@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-cluster To unsubscribe, send any mail to "freebsd-cluster-unsubscribe@freebsd.org"