From owner-freebsd-isp@FreeBSD.ORG  Wed Mar 15 17:16:02 2006
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
X-Original-To: freebsd-isp@freebsd.org
Delivered-To: freebsd-isp@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 23BF716A401
	for <freebsd-isp@freebsd.org>; Wed, 15 Mar 2006 17:16:02 +0000 (UTC)
	(envelope-from jsimola@gmail.com)
Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.204])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8512B43D49
	for <freebsd-isp@freebsd.org>; Wed, 15 Mar 2006 17:16:01 +0000 (GMT)
	(envelope-from jsimola@gmail.com)
Received: by uproxy.gmail.com with SMTP id m3so88563uge
	for <freebsd-isp@freebsd.org>; Wed, 15 Mar 2006 09:16:00 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=iZ6Mz8zgfuqPu/2llL2wRxHmCogmDOBr9YDKMVZpJuNYlDM6nyeU/gSEY0zLnKHsSGBSWnO0L3EM7biriPABkn6c7Yt3d7cGzLqSmWFZK0RgT7TWNG6BeYwY5Q0Il9fH/GDW6uBiKLAYJ5FmM0fqH5FYEEwwV6mJCjcsHdyHsYk=
Received: by 10.66.232.15 with SMTP id e15mr523222ugh;
	Wed, 15 Mar 2006 09:15:58 -0800 (PST)
Received: by 10.66.223.20 with HTTP; Wed, 15 Mar 2006 09:15:58 -0800 (PST)
Message-ID: <8eea04080603150915m18ff7c6cld9fdf761258759a3@mail.gmail.com>
Date: Wed, 15 Mar 2006 09:15:58 -0800
From: "Jon Simola" <jon@abccomm.com>
Sender: jsimola@gmail.com
To: freebsd-isp@freebsd.org
In-Reply-To: <44183340.4060903@infinityprosports.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <44183340.4060903@infinityprosports.com>
Subject: Re: MySQL Clustering
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 15 Mar 2006 17:16:02 -0000

On 3/15/06, James Ryan <james@infinityprosports.com> wrote:
> Not sure if this is the right list for this (I apologize if its not),
> but has anybody ran a MySQL 2+ node cluster under FreeBSD 5.x behind a
> load balancer; and if so, could you offer any tips or warnings?

If you're talking about the actual MySQL clustering server setup, I've
never had a chance to try it as our dataset is too large.

I've run a pair of MySQL servers in a round-robin master setup (A
slaves from B, B slaves from A) and that worked rather well,
replication was impressively quick.

--
Jon Simola
Systems Administrator
ABC Communications