[wplug] Large Database

[Nathan Embery]

Sorry, but I really have to disagree here. There is no reason why a
properly laid out and configured SAN would have any less performance
than a RAID controller.

I will agree that RAID-10 is the way to go, and also note that virtually
every SAN out there can configure LUNs as RAID-10 arrays. I just built a
10 Terabyte EMC array about 2 years ago in this same exact fashion and
the performance was excellent.


-Nate

On Fri, 2009-03-06 at 11:12 -0500, Bill Moran wrote:
> In response to Michael Semcheski <mhsemcheski at gmail.com>:
> 
> > If you're buying a storage system for this data too, I'd be happy to
> > share a few recent quotes I got (off list) for a new, middle of the
> > road SAN setup.
> 
> Gonna have to be contrary again ...
> 
> SANs are notorious for crappy performance under database load.  Granted,
> there are a few SAN systems that actually do well ... but there are far
> more that crumble under the frequent random access of a DB.
> 
> If you're considering a SAN to back a database system, take some serious
> time to ensure you're not getting into something that's going to be way
> too slow.  Get a demo unit from the vendor and test it out.
> 
> SCSI RAID-10 is your safest bet.
> 
> -- 
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug
>