Date: Thu, 29 Apr 2010 10:08:10 -0600 From: "Jason J. W. Williams" <jasonjwwilliams@gmail.com> To: Olivier Smedts <olivier@gid0.org> Cc: freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) Message-ID: <i2h3b949f091004290908ob52242feif96653a441b620b4@mail.gmail.com> In-Reply-To: <s2i367b2c981004290748y169b918eu402217cfa668b949@mail.gmail.com> References: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com> <s2i367b2c981004290748y169b918eu402217cfa668b949@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <olivier@gid0.org> wrote: > 2010/4/29 Jason J. W. Williams <jasonjwwilliams@gmail.com>: >> 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." >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?i2h3b949f091004290908ob52242feif96653a441b620b4>