zfs discuss - Jul 2007 - Oracle and ZFS

Customer question:

Oracle 10

Customer has a 6540 with 4 trays of 300G 10k drives. The raid sets are 3 + 1
vertically stripped on the 4 trays. Two 400G volumes are created on each
raid set. Would it be best to put all of the volumes in one Zpool or should
we create multiple Zpools to better manage where the data resides?

Thanks



Gerald L. Anderson (Jerry)
Sun Storage Group
Sun Microsystems
gerald.anderson at sun.com
303-345-7108 Mobile

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://mail.opensolaris.org/pipermail/zfs-discuss/attachments/20070726/10daa6d8/attachment.html>

On Jul 26, 2007, at 10:00 AM, gerald anderson wrote:
> Customer question:
>
> Oracle 10
>
> Customer has a 6540 with 4 trays of 300G 10k drives. The raid sets  
> are 3 + 1
>
> vertically stripped on the 4 trays. Two 400G volumes are created on  
> each
>
> raid set. Would it be best to put all of the volumes in one Zpool  
> or should
>
> we create multiple Zpools to better manage where the data resides?
Neel talks about that very issue here:
http://blogs.sun.com/realneel/entry/zfs_and_databases

More blogs about ZFS and database performance here:
http://blogs.sun.com/realneel/entry/zfs_and_databases_time_for
http://blogs.sun.com/erickustarz/entry/vdev_cache_improvements_to_help

If you''re not stuck on s10u3/s10u4 and can go with OpenSolaris bits,  
then you should use a separate intent log instead of multiple pools:
http://blogs.sun.com/perrin/entry/slog_blog_or_blogging_on

eric
> Thanks
>
>
> Gerald L. Anderson (Jerry)
>
> Sun Storage Group
>
> Sun Microsystems
>
> gerald.anderson at sun.com
>
> 303-345-7108 Mobile
>
>
> _______________________________________________
> zfs-discuss mailing list
> zfs-discuss at opensolaris.org
> http://mail.opensolaris.org/mailman/listinfo/zfs-discuss