From owner-freebsd-database@FreeBSD.ORG  Wed Oct  8 05:16:16 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 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 <Peter.Ross@alumni.tu-berlin.de>
X-X-Sender: petros@guckloch.zuhause
To: Sebastien Gioria <gioria@freebsd.org>
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-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, 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