From owner-freebsd-questions@FreeBSD.ORG  Wed May  6 18:49:38 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id A4AA7106566C
	for <freebsd-questions@freebsd.org>;
	Wed,  6 May 2009 18:49:38 +0000 (UTC)
	(envelope-from freebsd@optiksecurite.com)
Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36])
	by mx1.freebsd.org (Postfix) with ESMTP id 7E2C08FC16
	for <freebsd-questions@freebsd.org>;
	Wed,  6 May 2009 18:49:38 +0000 (UTC)
	(envelope-from freebsd@optiksecurite.com)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Received: from [69.69.69.183] ([69.70.93.206]) by VL-MH-MR001.ip.videotron.ca
	(Sun Java(tm) System Messaging Server 6.3-4.01 (built Aug  3 2007;
	32bit))
	with ESMTP id <0KJ800JR3KAP9K81@VL-MH-MR001.ip.videotron.ca> for
	freebsd-questions@freebsd.org; Wed, 06 May 2009 14:49:37 -0400 (EDT)
Message-id: <4A01DBCE.9070304@optiksecurite.com>
Date: Wed, 06 May 2009 14:49:50 -0400
From: Martin Turgeon <freebsd@optiksecurite.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
To: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>
Subject: Advices for a jailed MySQL server
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 06 May 2009 18:49:38 -0000

Hi everyone,

I'm starting to build a new dedicated MySQL server. I will be using 
FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL 5.0 and 
to put the MySQL data outside the jail. My objective is to be able to 
update MySQL without down time. My objective would be to create another 
up to date MySQL jail and when I'm ready to make the switch, just point 
the new jail to the data outside the jail using something like a nullfs 
mount.

Is someone using something like this?

Did someone have any advice about how to update a MySQL server without 
down time?

Did someone have any advice on how to tune a dedicated MySQL server 
running FreeBSD 7.2 (Dual core Xeon, 4G RAM, mirror RAID on a PERC5 
controler 2x146G 15K)?

Thanks everyone for sharing your precious knowledge :)

Martin