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=1, 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_at_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=metadata 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_at_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_at_gid0.org> wrote: >> 2010/4/29 Jason J. W. Williams <jasonjwwilliams_at_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_at_freebsd.org mailing list >>> http://lists.freebsd.org/mailman/listinfo/freebsd-current >>> To unsubscribe, send any mail to "freebsd-current-unsubscribe_at_freebsd.org" >>> >> >> >> >> -- >> Olivier Smedts _ >> ASCII ribbon campaign ( ) >> e-mail: olivier_at_gid0.org - against HTML email & vCards X >> www: http://www.gid0.org - against proprietary attachments / \ >> >> "Il y a seulement 10 sortes de gens dans le monde : >> ceux qui comprennent le binaire, >> et ceux qui ne le comprennent pas." >> > _______________________________________________ > freebsd-current_at_freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current-unsubscribe_at_freebsd.org" >Received on Thu Apr 29 2010 - 14:50:18 UTC
This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:40:03 UTC