From owner-freebsd-cluster@FreeBSD.ORG Wed Oct 8 00:42:33 2003 Return-Path: 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 F298F16A4BF; Wed, 8 Oct 2003 00:42:32 -0700 (PDT) Received: from gioria.dyndns.org (dyn-213-36-202-140.ppp.tiscali.fr [213.36.202.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0BFF643FEA; Wed, 8 Oct 2003 00:42:32 -0700 (PDT) (envelope-from eagle@gioria.dyndns.org) Received: by gioria.dyndns.org (Postfix, from userid 501) id 11700374B9; Wed, 8 Oct 2003 09:52:27 +0200 (CEST) Date: Wed, 8 Oct 2003 09:52:27 +0200 From: Sebastien Gioria To: freebsd-cluster@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Message-ID: <20031008095226.A18491@thorm.gioria.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i X-Hostname: thorm.gioria.dyndns.org X-Uptime: 9:50AM up 12 days, 2:40, 2 users, load averages: 1.00, 1.00, 1.00 X-FreeBSD-Release: FreeBSD-4.7-STABLE Subject: Clustering mysql X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Sebastien Gioria List-Id: Clustering FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 08 Oct 2003 07:42:33 -0000 Hi guys, Anybody does have any experience in clustering mysql ? Software to install, tuning OS ? Thanks -- 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 ? <-* From owner-freebsd-cluster@FreeBSD.ORG Wed Oct 8 05:16:16 2003 Return-Path: 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 1F63916A4B3; Wed, 8 Oct 2003 05:16:16 -0700 (PDT) Received: from mail007.syd.optusnet.com.au (mail007.syd.optusnet.com.au [211.29.132.55]) by mx1.FreeBSD.org (Postfix) with ESMTP id 91ABB43FBF; Wed, 8 Oct 2003 05:16:11 -0700 (PDT) (envelope-from Peter.Ross@alumni.tu-berlin.de) Received: from guckloch.zuhause (winax24-025.dialup.optusnet.com.au [211.29.117.25])h98CG7e29358; Wed, 8 Oct 2003 22:16:08 +1000 Received: from guckloch.zuhause (localhost.zuhause [127.0.0.1]) by guckloch.zuhause (8.12.9/8.12.9) with ESMTP id h98CGZB4001033; Wed, 8 Oct 2003 22:16:35 +1000 (EST) (envelope-from Peter.Ross@alumni.tu-berlin.de) Received: from localhost (petros@localhost)h98CGX4q001028; Wed, 8 Oct 2003 22:16:35 +1000 (EST) X-Authentication-Warning: guckloch.zuhause: petros owned process doing -bs Date: Wed, 8 Oct 2003 22:16:33 +1000 (EST) From: Peter Ross X-X-Sender: petros@guckloch.zuhause To: Sebastien Gioria In-Reply-To: <20031008095226.A18491@thorm.gioria.dyndns.org> Message-ID: <20031008214602.T625@guckloch.zuhause> References: <20031008095226.A18491@thorm.gioria.dyndns.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-database@freebsd.org cc: freebsd-cluster@freebsd.org Subject: Re: Clustering mysql X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Clustering FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 08 Oct 2003 12:16:16 -0000 Hi Sebastien, On Wed, 8 Oct 2003, Sebastien Gioria wrote: > Anybody does have any experience in clustering mysql ? > Software to install, tuning OS ? I used mysql in a master/slave replication configuration. Do you mean that? I had to use Linux so the OS tuning is not what you are looking for (and the circumstances were an invention of .. okay no swear words here .. but would you run NFS server, mysql and postgresql with high load on the same machine? And then Linux with it's problems under high load?) Especially mysql was hell. Occasionally corrupted indexes. When I rebuilt them the master/server pair became out of sync. I had to keep the mysql running so I used a rsync loop to fix it. The last rsync had to be done while the master wasn't writing to disk (I forgot the command only to use the memory for updates, sorry). Then I restarted the replication and let the master dump the updates cached in memory. Maybe it's better with version 4? I hope you get better results Peter From owner-freebsd-cluster@FreeBSD.ORG Wed Oct 8 05:40:09 2003 Return-Path: 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 7CB5716A4B3 for ; Wed, 8 Oct 2003 05:40:09 -0700 (PDT) Received: from gddsn.org.cn (mail.gddsn.org.cn [210.21.6.33]) by mx1.FreeBSD.org (Postfix) with ESMTP id A121D43FAF for ; Wed, 8 Oct 2003 05:40:05 -0700 (PDT) (envelope-from hwh@gddsn.org.cn) Received: from gddsn.org.cn (gw [210.21.6.34]) by gddsn.org.cn (Postfix) with ESMTP id 05C9C38CB3D for ; Wed, 8 Oct 2003 20:39:58 +0800 (CST) Message-ID: <3F84059C.9000204@gddsn.org.cn> Date: Wed, 08 Oct 2003 20:39:56 +0800 From: Huang wen hui User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; zh-CN; rv:1.4) Gecko/20030916 X-Accept-Language: zh-cn,zh MIME-Version: 1.0 To: freebsd-cluster@freebsd.org Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 7bit Subject: A bug in phase1 ? X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Clustering FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 08 Oct 2003 12:40:09 -0000 hi, I use http://sporner.dnsalias.org/freebsdcluster/phase1-214-src.tar.gz under 5.1-CURRENT. I found that I had to patch the following patch, or cl_admin would auto add "2", "3" ...as node name to rsrc. of cause the node "2","3" is not existed. --hwh diff -ur /tmp/phase1/clusterd/cl_cluster.c phase1/clusterd/cl_cluster.c --- /tmp/phase1/clusterd/cl_cluster.c Sun Dec 1 22:39:57 2002 +++ phase1/clusterd/cl_cluster.c Wed Oct 8 15:43:39 2003 @@ -941,11 +941,11 @@ cr->weight = atoi(argv[4]); cr->restartable = atoi(argv[5]); - for (i=0; i < (argc - 7); i++) { - strcpy(cr->nodes[i], argv[i+7]); + for (i=0; i < (argc - 8); i++) { + strcpy(cr->nodes[i], argv[i+8]); } /* for */ - cr->n_nodes = (argc - 7); + cr->n_nodes = (argc - 8); return (0); From owner-freebsd-cluster@FreeBSD.ORG Wed Oct 8 14:55:39 2003 Return-Path: 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 D3D3F16A4B3; Wed, 8 Oct 2003 14:55:39 -0700 (PDT) Received: from museful.corp.yahoo.com (museful.corp.yahoo.com [216.145.52.107]) by mx1.FreeBSD.org (Postfix) with ESMTP id ED9EA43FAF; Wed, 8 Oct 2003 14:55:38 -0700 (PDT) (envelope-from jzawodn@yahoo-inc.com) Received: (from jzawodn@localhost) by museful.corp.yahoo.com (8.11.6/8.11.1) id h98Ltcm64954; Wed, 8 Oct 2003 14:55:38 -0700 (PDT) (envelope-from jzawodn) Date: Wed, 8 Oct 2003 14:55:38 -0700 From: Jeremy Zawodny To: Sebastien Gioria Message-ID: <20031008145538.A64913@yahoo-inc.com> References: <20031008095226.A18491@thorm.gioria.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20031008095226.A18491@thorm.gioria.dyndns.org>; from gioria@freebsd.org on Wed, Oct 08, 2003 at 09:52:27AM +0200 cc: freebsd-database@freebsd.org cc: freebsd-cluster@freebsd.org Subject: Re: Clustering mysql X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Clustering FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 08 Oct 2003 21:55:40 -0000 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? Jeremy -- Jeremy D. Zawodny, Technical Yahoo - Yahoo MySQL Geek Desk: (408) 349-7878 Cell: (408) 685-5936 From owner-freebsd-cluster@FreeBSD.ORG Thu Oct 9 01:20:13 2003 Return-Path: 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) Date: Thu, 9 Oct 2003 10:30:16 +0200 From: Sebastien Gioria To: Jeremy Zawodny 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: freebsd-cluster@freebsd.org Subject: Re: Clustering mysql X-BeenThere: freebsd-cluster@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Sebastien Gioria List-Id: Clustering FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 ? <-*