zfs discuss - Jul 2007 - Ready for production? - zfs/oracle/oltp

Hi

What is the general feeling for production readiness when it comes to:

ZFS
Oracle 10G R2
6140-type storage
OLTP workloads
1-3TB sizes

Running UFS with directio is stable, fast and one can sleep at night.
Can the same be said for zfs at this moment?

Should one hold out for Solaris 10 U4? (I believe some nice
performance improvements are coming)

Does the answer depend on the layout of the vdev''s ... ie you
absolutely _have_ to use ZFS file system consistence RAID-1 as opposed
to hardware controllers?

Thanks

Hello Louwtjie,

Tuesday, July 17, 2007, 10:20:03 AM, you wrote:

LB> Hi

LB> What is the general feeling for production readiness when it comes to:

LB> ZFS
LB> Oracle 10G R2
LB> 6140-type storage
LB> OLTP workloads
LB> 1-3TB sizes

LB> Running UFS with directio is stable, fast and one can sleep at night.
LB> Can the same be said for zfs at this moment?

Oracle+Solaris+UFS has been there for years.
If ''good sleep at night'' is most important for you then I
would
probably go with UFS. You''ve got to think what problems are you trying
to solve with ZFS instead of UFS, and take risk into account.

I do have Oracle on ZFS, also on UFS. There were some problems with
ZFS before, but once it stabilized it''s been working.

LB> Should one hold out for Solaris 10 U4? (I believe some nice
LB> performance improvements are coming)

LB> Does the answer depend on the layout of the vdev''s ... ie you
LB> absolutely _have_ to use ZFS file system consistence RAID-1 as opposed
LB> to hardware controllers?

No, you don''t have to do it - but then you should be aware that
you''ll
be missing some zfs features.

-- 
Best regards,
 Robert                            mailto:rmilkowski at task.gda.pl
                                       http://milek.blogspot.com