ZFS Stability & MySQL (Comments Requested)
Olivier Smedts
olivier at gid0.org
Thu Apr 29 14:48:17 UTC 2010
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."
More information about the freebsd-current
mailing list