ZFS Stability & MySQL (Comments Requested)
mickael.maillot at gmail.com
Thu Apr 29 16:50:18 UTC 2010
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.
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.
> 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 :
>>> freebsd-current at freebsd.org mailing list
>>> 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
> To unsubscribe, send any mail to "freebsd-current-unsubscribe at freebsd.org"
More information about the freebsd-current