From owner-freebsd-current@FreeBSD.ORG Thu Apr 29 16:08:17 2010 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4C9A9106564A for ; Thu, 29 Apr 2010 16:08:17 +0000 (UTC) (envelope-from jasonjwwilliams@gmail.com) Received: from mail-pv0-f182.google.com (mail-pv0-f182.google.com [74.125.83.182]) by mx1.freebsd.org (Postfix) with ESMTP id 1F2538FC16 for ; Thu, 29 Apr 2010 16:08:17 +0000 (UTC) Received: by pvg3 with SMTP id 3so16071pvg.13 for ; Thu, 29 Apr 2010 09:08:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=KADctowvXKJUJ7HdiB/bm8wAOLsLucGljemzJUPqBIw=; b=C5NKqNAA4v5KdIj4/A8zdGfrKX9QtUWpDhaDCLCQ/Z5GY4g8MnEGPKDWwEGgo1mjfY ruD8Or3HNptAJvzHJ3baPpkEAFgWZNedwErrn2yIaNMeOcLAydyBi3fBFZ2jBM4H+jBK 4XZ6s8S0Qnu1gUaWOhIorAcsl8W+R2DyatuNU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=OKkK8+4utt//kAPWn+0QMjJ0568V+HrtAcsl02+cPC/XSp9MjXGtnvuPBBNTJ1Jirg nXaqKc73L8vDHXk4tSFAqEXqQ17z0LtbxMvMgO+8RSlDsNXRxVFkh7HJUBskNnKQt4az tryr9lt71EVhQaJCyGMwJ5F9de1yCX0a8NldA= MIME-Version: 1.0 Received: by 10.140.251.19 with SMTP id y19mr1550383rvh.161.1272557290997; Thu, 29 Apr 2010 09:08:10 -0700 (PDT) Received: by 10.141.27.20 with HTTP; Thu, 29 Apr 2010 09:08:10 -0700 (PDT) In-Reply-To: References: Date: Thu, 29 Apr 2010 10:08:10 -0600 Message-ID: From: "Jason J. W. Williams" To: Olivier Smedts Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Cc: freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 29 Apr 2010 16:08:17 -0000 Hi Olivier, We've actually been running MySQL on ZFS on Solaris for quite some time. :) We're very comfortable with that setup. My question is more specific to live experience with doing the same thing on FreeBSD. We know where the sabots are on MySQL/ZFS/Solaris. Would like to find out where the landmines are when you swap Solaris for FreeBSD in that equation. Thank you again. -J On Thu, Apr 29, 2010 at 8:48 AM, Olivier Smedts wrote: > 2010/4/29 Jason J. W. Williams : >> Hi Y'all, >> >> I've written before that we're considering moving to FreeBSD 8 from >> OpenSolaris and are heavily reliant on ZFS. Has anyone used FreeBSDs >> ZFS implementation for a high reliability environment like a database? >> If so, what are your experiences? >> >> Basically, I'm curious how stable the implementation is and whether >> it's ready for a critical production environment. Also, any gotchas >> particularly with running it with MySQL or anything else that utilizes >> a lot of memory. On Solaris, we cap the max ARC size to keep it from >> grabbing all the system RAM and competing with MySQL. >> >> Any thoughts or comments are greatly appreciated. > > No experience with databases on ZFS but I think you should set the > recordsize property to a proper (I mean, for your MySQL setup) value > on the FS that will hold the data. > > Have a look at : > http://www.solarisinternals.com/wiki/index.php/ZFS_for_Databases > > Cheers > >> >> -J >> _______________________________________________ >> freebsd-current@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-current >> To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.or= g" >> > > > > -- > Olivier Smedts =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 _ > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0ASCII ribbon campaign ( ) > e-mail: olivier@gid0.org =A0 =A0 =A0 =A0- against HTML email & vCards =A0= X > www: http://www.gid0.org =A0 =A0- against proprietary attachments / \ > > =A0"Il y a seulement 10 sortes de gens dans le monde : > =A0ceux qui comprennent le binaire, > =A0et ceux qui ne le comprennent pas." >