2010/4/29 Jason J. W. Williams <[email protected]>: > 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 > _______________________________________________ > [email protected] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "[email protected]" > -- Olivier Smedts _ ASCII ribbon campaign ( ) e-mail: [email protected] - 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." _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-current To unsubscribe, send any mail to "[email protected]"
