Date: Thu, 29 Apr 2010 18:50:09 +0200 From: =?ISO-8859-1?Q?Micka=EBl_Maillot?= <mickael.maillot@gmail.com> To: "Jason J. W. Williams" <jasonjwwilliams@gmail.com> Cc: Olivier Smedts <olivier@gid0.org>, freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) Message-ID: <p2pea7b7b811004290950hc425e5abn4d33056b3f9fb654@mail.gmail.com> In-Reply-To: <i2h3b949f091004290908ob52242feif96653a441b620b4@mail.gmail.com> References: <u2q3b949f091004290731rd83bd474g9b7b2cacf5120b8@mail.gmail.com> <s2i367b2c981004290748y169b918eu402217cfa668b949@mail.gmail.com> <i2h3b949f091004290908ob52242feif96653a441b620b4@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 amd64) 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.o= rg" >>> >> >> >> >> -- >> 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.org= " >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?p2pea7b7b811004290950hc425e5abn4d33056b3f9fb654>