Re: [zfs-discuss] Oracle and ZFS

2008-06-24 Thread Toby Thain
On 23-Jun-08, at 6:59 PM, Miles Nordin wrote: >> ... A proper > DBMS (anything except MySQL) Perhaps you mean MyISAM. MySQL's InnoDB engine offers ACID. --Toby ___ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/m

Re: [zfs-discuss] Oracle and ZFS

2008-06-24 Thread Darren J Moffat
Richard Elling wrote: > Hacked non-COW zvol? Since COW occurs at the DMU layer, > below ZPL or ZVol, I don't see how to bypass it. AFAIK, > the trick to using ZVols for swap was to just fix some bugs > in ZFS and rewrite the pertinent parts of the installer(s). Swap just uses a normal ZVOL, whi

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Richard Elling
Miles Nordin wrote: >> "re" == Richard Elling <[EMAIL PROTECTED]> writes: >> "kb" == Keith Bierman <[EMAIL PROTECTED]> writes: >> > > re> the disk lies about the persistence of the data. ZFS knows > re> disks lie, so it sends sync commands when necessary > > (1) i

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Miles Nordin
> "re" == Richard Elling <[EMAIL PROTECTED]> writes: > "kb" == Keith Bierman <[EMAIL PROTECTED]> writes: re> the disk lies about the persistence of the data. ZFS knows re> disks lie, so it sends sync commands when necessary (1) i don't think ``lie'' is a correct characerization g

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Richard Elling
Miles Nordin wrote: >> "mo" == Mertol Ozyoney <[EMAIL PROTECTED]> writes: >> > > mo> One of our customer is suffered from FS being corrupted after > mo> an unattanded shutdonw due to power problem. > > mo> They want to switch to ZFS. > > mo> From what I read on,

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Keith Bierman
On Jun 23, 2008, at 11:36 AM, Miles Nordin wrote: > unplanned power outage that > happens after fsync returns Aye, but isn't that the real rub ... when the power fails after the write but *before* the fsync has occurred... -- Keith H. Bierman [EMAIL PROTECTED] | AIM kbiermank 5430 Na

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Miles Nordin
> "mo" == Mertol Ozyoney <[EMAIL PROTECTED]> writes: mo> One of our customer is suffered from FS being corrupted after mo> an unattanded shutdonw due to power problem. mo> They want to switch to ZFS. mo> From what I read on, ZFS will most probably not be corrupted mo> fro

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Richard Elling
Mertol Ozyoney wrote: > > Hi All ; > > One of our customer is suffered from FS being corrupted after an > unattanded shutdonw due to power problem. > > They want to switch to ZFS. > > From what I read on, ZFS will most probably not be corrupted from the > same event. But I am not sure how will Or

Re: [zfs-discuss] Oracle and ZFS

2008-06-23 Thread Chris Cosby
>From my usage, the first question you should ask your customer is how much of a performance hit they can spare when switching to ZFS for Oracle. I've done lots of tweaking (following threads I've read on the mailing list), but I still can't seem to get enough performance out of any databases on ZF

[zfs-discuss] Oracle and ZFS

2008-06-23 Thread Mertol Ozyoney
Hi All ; One of our customer is suffered from FS being corrupted after an unattanded shutdonw due to power problem. They want to switch to ZFS. >From what I read on, ZFS will most probably not be corrupted from the same event. But I am not sure how will Oracle be affected from a sudden p

Re: [zfs-discuss] Oracle and ZFS

2007-07-26 Thread eric kustarz
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 o

[zfs-discuss] Oracle and ZFS

2007-07-26 Thread gerald anderson
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