From owner-freebsd-questions@FreeBSD.ORG Wed May 6 19:09:36 2009 Return-Path: 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 0D30C1065690 for ; Wed, 6 May 2009 19:09:36 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id D3E4E8FC19 for ; Wed, 6 May 2009 19:09:35 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from vanquish.ws.pitbpa0.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTPSA id 28CF0EBC0A; Wed, 6 May 2009 15:09:35 -0400 (EDT) Date: Wed, 6 May 2009 15:09:33 -0400 From: Bill Moran To: Martin Turgeon Message-Id: <20090506150933.d0ef0178.wmoran@potentialtech.com> In-Reply-To: <4A01DBCE.9070304@optiksecurite.com> References: <4A01DBCE.9070304@optiksecurite.com> X-Mailer: Sylpheed 2.6.0 (GTK+ 2.14.7; i386-portbld-freebsd7.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: "freebsd-questions@freebsd.org" Subject: Re: Advices for a jailed MySQL server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 May 2009 19:09:36 -0000 In response to Martin Turgeon : > 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 :) I expect that what you're trying to do will work, however it's horrifically error-prone during the upgrade procedure (what if you forget to stop the first MySQL before you start the new one!) If you need to do anything zero-downtime, then you probably want to run multiple MySQL instances and use database replication to keep the data in sync. That way you just switch which DB is master, then upgrade the slave ... rinse/repeat. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/