ZFS Stability & MySQL (Comments Requested)

[Mickaël Maillot]

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"
>