Excellent article in this month's SysAdmin magazine about this,
performance tuning oracle on solaris, nfs-mounted from a netapp. I've
played with a test db done this way, performance was fine for single-
threaded queries. I imagine anything heavier would get you into NFS
tuning very quickly.
The article mentions gig ethernet as one of the better fixes
for a slow db. The things I'd be worried about, like db corruption from
dropped mounts, weren't mentioned as problems. But, I've seen oracle
restart fine after a system panic, this seems roughly analagous to all
tablespaces & logs going away when e.g. a nic or switch dies.
Snap mirroring for backups, yup. The other treat is "migrating"
a db by 'umount /u0*' and remounting 'em on another box. Set up accounts,
script the mounts & startup, and you have an oracle instance moving from
one box to another as fast as disk-based failover, without the limits of
disk hardware.
> i haven't done the math, but i can't imagine that any nfs version over
> any network medium can even begin to approach the performance of raw
> disk access over disparate HBAs.
Exactly what I was thinking, before setting up some cp's for time.
Netapps are nutty fast, comparable to san rates. Local disk isn't even
close, solaris nfsd neither.
Andrew Fant wrote:
>
> On Thu, 16 May 2002, Chris Marget wrote:
>
> > of course, you can't really use a netapp filer for a database and
> > expect any sort of reasonable performance. but they make one hell of
> > a good fileserver. i love 'em. can you tell?
>
> Actually, Oracle has officially endorsed using Netapp Filers with Oracle
> 9i, and both of them seem to claim that this is a direction that they want
> to encourage the user base to go in, because to the way that the snap
> technology can simplify hot backups on large databases. Who would have
> thunk it?
>
> Andy
>
> Andrew Fant | This | "If I could walk THAT way...
> Molecular Geek | Space | I wouldn't need the talcum powder!"
> [EMAIL PROTECTED] | To | G. Marx (apropos of Aerosmith)
> Boston, MA USA | Let | http://www.pharmawulf.com
>
> ---
> Send mail for the `bblisa' mailing list to `[EMAIL PROTECTED]'.
> Mail administrative requests to `[EMAIL PROTECTED]'.
---
Send mail for the `bblisa' mailing list to `[EMAIL PROTECTED]'.
Mail administrative requests to `[EMAIL PROTECTED]'.
