Date: Thu, 29 Apr 2010 11:03:38 -0600 From: "Jason J. W. Williams" <jasonjwwilliams@gmail.com> To: =?ISO-8859-1?Q?Micka=EBl_Maillot?= <mickael.maillot@gmail.com> Cc: Olivier Smedts <olivier@gid0.org>, freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) Message-ID: <h2s3b949f091004291003jc9fdbf58ocf84385802ddeb12@mail.gmail.com> In-Reply-To: <p2pea7b7b811004290950hc425e5abn4d33056b3f9fb654@mail.gmail.com> References: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com> <s2i367b2c981004290748y169b918eu402217cfa668b949@mail.gmail.com> <i2h3b949f091004290908ob52242feif96653a441b620b4@mail.gmail.com> <p2pea7b7b811004290950hc425e5abn4d33056b3f9fb654@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Mickael, Thank you for the detailed response! By "wait 8.1 to have all recent zfs enhancement for prod" are you referring to the ZFS enhancements they've made over the past year in that regard, or enhancements the FreeBSD committers are making to make ZFS on FreeBSD work better? I've got to stand up some additional infrastructure within a short time commitment, so I might not be able to wait for 8.1. (I assume it's not due in the next 30 days.) -J On Thu, Apr 29, 2010 at 10:50 AM, Micka=EBl Maillot <mickael.maillot@gmail.com> wrote: > i have two freebsd running MySQL 5.1 on ZFS: > - first: a 7-STABLE build (7.2, 2 month after zfs v13 import) > the machine crash recently after a 130 day uptime beceause i dont > limit arc size (so 4Gb by default) and i think they run oom. > even with vfs.zfs.cache_flush_disable=3D1, no data loose, innodb redo > the log and the mysql is fine. > - second: a 8-STABLE > FreeBSD db4.security-mail.net 8.0-STABLE FreeBSD 8.0-STABLE #2: Mon > Apr 19 12:48:20 CEST 2010 > root@db4.security-mail.net:/usr/obj/usr/src/sys/GENERIC =A0amd64) > updated recently, no problem at all. > > i follow all opensolaris databases recommendation but there is some > diff between freebsd and osol. > like primarycache=3Dmetadata > > we have a realy big table (~ 1,5 To) in innodb split with mysql > partition (compress ration ~ x2) and it's works pretty well. > > i would recommend you to wait 8.1 to have all recent zfs enhancement > for prod unless you follow all mailing list and commit. > > > 2010/4/29 Jason J. W. Williams <jasonjwwilliams@gmail.com>: >> 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.= org" >>>> >>> >>> >>> >>> -- >>> 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 = =A0X >>> 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." >>> >> _______________________________________________ >> 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" >> >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?h2s3b949f091004291003jc9fdbf58ocf84385802ddeb12>