Re: ZFS Stability & MySQL (Comments Requested)

From: Jason J. W. Williams <jasonjwwilliams_at_gmail.com>
Date: Thu, 29 Apr 2010 11:03:38 -0600
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ël Maillot
<mickael.maillot_at_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=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 - 15:03:47 UTC

This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:40:03 UTC