From oracle-l-bounce@freelists.org Fri Mar 18 11:39:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2IHdB7u004832 for ; Fri, 18 Mar 2005 11:39:11 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2IHdBem004828 for ; Fri, 18 Mar 2005 11:39:11 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B9D94871B3; Fri, 18 Mar 2005 11:37:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00989-10; Fri, 18 Mar 2005 11:37:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 38C4D869E9; Fri, 18 Mar 2005 11:37:28 -0500 (EST) In-Reply-To: <96FB7D6574516C45922A76B354B684FD45A53A@USHQEXVS.polanet.polaroid.com> References: <96FB7D6574516C45922A76B354B684FD45A53A@USHQEXVS.polanet.polaroid.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-type: text/plain; charset=US-ASCII Message-Id: Content-Transfer-Encoding: 8bit Cc: From: Matthew Zito Subject: Re: Storage options? Date: Fri, 18 Mar 2005 11:35:33 -0500 To: HANDM@polaroid.com X-archive-position: 17461 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mzito@gridapp.com Precedence: normal Reply-To: mzito@gridapp.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: WORM fits nicely into individual object read-only access (i.e. I have 2 million X-rays I need to back up for ten years), but it does very poorly for relational databases, since there are so many secondary relationships that need to be managed. For example, a query to retrieve one BLOB could touch 3 different files, each one residing on a different media. There's a few things that apparently haven't been determined yet - acceptable access times, throughput, and I/Os per second. If you're not going to be able to hazard a guess at these things, then the easiest and safest thing to do would be to get an EMC array and go from there. However, better/possibly more appropriate options are the NearStore from Netapp or 3PAR. The NearStore is all SATA drives, very easy to manage, very large raid groups, designed for high redundancy and reasonable performance at a very high storage density. That's appropriate if you need basically slow, reliable storage at a cheap price point. For higher performance, 3PAR is designed to take advantage of an internall distributed, internally scalable architecture and is very easy to manage online. If you need higher performance storage for cheaper than EMC, check them out. The last option, and the cheapest and most dangerous, is to get a bunch of Nexsan storage arrays and put them on a SAN with your databases. Then use something like Veritas or ASM to stripe and mirror across them. Cheapest option, performance should be pretty decent. In the end, though, you're really going to need more information to be able to plan these things. Thanks, Matt -- Matthew Zito GridApp Systems Email: mzito@gridapp.com Cell: 917-574-1858 Phone: 212-358-8211 x 359 http://www.gridapp.com On Mar 18, 2005, at 11:10 AM, Hand, Michael T wrote: > When I hear huge amounts of read-only, archived data, I think WORM > optical, though can't give you any price/performance vs SAN, NAS, JBOD. > > Regards, > Mike Hand=20 > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org] On Behalf Of Brian Wisniewski > Sent: Friday, March 18, 2005 10:44 AM > To: Oracle-L@freelists.org > Subject: Storage options? > > I just got pinged from one of our development directors about a > possible > project coming up in the next fiscal year and I need your input on > storage options. This is going to be a massive 40TB+ project and it's > mostly for archival of blob-type data. ~200,000,000 rows * ~200K > blobs. > Obviously we haven't even talked about indexes or access patterns but > this is going to be a read-only type system of archived data. I'm sure > price is going to far exceed performance when the rubber hits the road > at the mgmt level. > =20 > We are currently an all EMC shop but we looked at IBM's storage and > found it unacceptable. Looking for solid storage vendors who could > provide this type of storage at a 'reasonable' price. Any thoughts? > =20 > Thanks - Brian > =09=09 > --------------------------------- > Do you Yahoo!? > Make Yahoo! your home page=20=20=20 > > -- > http://www.freelists.org/webpage/oracle-l > > --=20 > This transmission is intended only for use by the addressee(s) named > herein= > and may contain information that is proprietary, confidential and/or > legal= > ly privileged. If you are not the intended recipient, you are hereby > notifi= > ed that any disclosure, copying, distribution, or use of the > information co= > ntained herein (including any reliance thereon) is STRICTLY > PROHIBITED. If = > you received this transmission in error, please immediately contact > the sen= > der and destroy the material in its entirety, whether in electronic or > hard= > copy format. Thank you. > > > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l