MySQL Forums
Forum List  »  MySQL & Storage

MySQL on ZFS
Posted by: Edwin DeSouza
Date: October 25, 2007 07:33PM

When Sun Microsystems released the ZFS filesystem in 2004, they set out to remove all of the practical limits on filesystem storage, and to make the arcane details of storage management a thing of the past. ZFS is a 128-bit filesystem with – to name just a few features – copy-on-write transactional semantics, fast snapshots, and optional compression.

The most obvious benefit of ZFS is its simple administration. In ZFS, traditional tasks like formatting a disk or editing /etc/fstab are gone entirely, and building a mirrored or striped RAID can be accomplished with a one-line command that actually looks sensible, is easy to remember, and has interactive help. ZFS does for storage management what MySQL did for databases, and like MySQL, it's open source, as well. ZFS was first introduced in Solaris, but Linux ports are underway, Apple is shipping it in OS X 10.5, and it will be included in FreeBSD 7.

To appreciate what this might mean for MySQL, consider the problem of storage management under InnoDB:
http://dev.mysql.com/tech-resources/articles/mysql-zfs.html

Options: ReplyQuote


Subject
Written By
Posted
MySQL on ZFS
October 25, 2007 07:33PM
October 25, 2007 09:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.