List:General Discussion« Previous MessageNext Message »
From:David Griffiths Date:August 21 2003 6:05pm
Subject:Re: RAID or not?
View as plain text  
3Ware makes reasonably priced ATA and SATA RAID-5 cards (IDE, not SCSI). You
can get hot-swappable enclosures so that when a drive fails, you swap it
without shutting down the machine.

We are gradually adding this hardware to our webservers, etc so that we
don't have to rebuild them when a drive dies.

Some good URLs:

http://www.3ware.com/

These guys sell the cards at a good price, plus they sell 3rd-party
enclosures (I've used them with 3ware, and they work great):

http://www.pc-pitstop.com/

David.
----- Original Message -----
From: "Lefevre, Steven" <SLefevre@stripped>
To: "Jackson Miller" <jackson@stripped>; <mysql@stripped>
Sent: Thursday, August 21, 2003 10:20 AM
Subject: RE: RAID or not?


> I say go with RAID 5, on a controller card.
>
> Mirroring just gives you backup, and you lose half your diskspace. It
offers
> no performance benefit, and actually the computer might have to work
harder
> to make sure the drives are in sync.
>
> Disk striping makes things *fast*, BUT THERE IS NO PROTECTION. If you lose
a
> drive, you are screwed; hope you have a backup.
>
> Raid 5 spreads data out over all the disks, and keeps one for checksums or
> whatever. You lose only one drive to the checksum.
>
> You get better performance than mirroring or regular drive, because the
data
> is spread out over your drives. It's not as good as disk striping, though.
>
> You get great redudancy, because if you lose one disk, the RAID still
> operates (in 'degraded mode') -- it's slower, but the server is still up.
> When you get your replacement drive in, you just hook it up, and the RAID
> rebuilds itself.
>
> So, all in all, RAID 5 gives fault tolerance and better performance.
>
> You can have the OS do the RAID, but that puts a lot of burden on the
> processor and OS. I recommend getting a RAID card, and not a cheap one,
> either. Plan on spending ~$500.
>
>
> -----Original Message-----
> From: Jackson Miller [mailto:jackson@stripped]
> Sent: Thursday, August 21, 2003 11:56 AM
> To: Jon Drukman
> Cc: mysql@stripped
> Subject: Re: RAID or not?
>
>
> On Thursday 21 August 2003 2:23, Jon Drukman wrote:
> > if you're mostly running SELECTs then i would recommend a mirrored
> > configuration.
>
> I would say I am running about %50 SELECTS, 30% UPDATE, 20% INSERT.
However
> I
> don't know how to find that out for sure.
>
> Would that affect how I set up the RAID?
>
> -Jackson
>
> jackson miller
>
> cold feet creative
> 615.321.3300 / 800.595.4401
> jackson@stripped
>
>
> cold feet presents Emma
> the world's easiest email marketing
> Learn more @  http://www.myemma.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
RAID or not?Jackson Miller21 Aug
  • Re: RAID or not?Jon Drukman21 Aug
    • Re: RAID or not?Jackson Miller21 Aug
      • RE: RAID or not?Steven) (Lefevre21 Aug
        • Re: RAID or not?David Griffiths21 Aug
        • Re: RAID or not?Per Andreas Buer21 Aug
        • Re: RAID or not?Jon Drukman22 Aug
          • Re: RAID or not?Dan Nelson22 Aug
          • RE: RAID or not?Steven) (Lefevre22 Aug
            • RE: RAID or not?Michael Loftis2 Sep
  • Re: RAID or not?Colbey21 Aug
  • Re: RAID or not?Per Andreas Buer21 Aug
RE: RAID or not?Alec.Cawley22 Aug
  • Re: RAID or not?Jim McAtee23 Aug
    • Re: RAID or not?Michael Loftis2 Sep
RE: RAID or not?Alec.Cawley22 Aug
Re: RAID or not?Alec.Cawley26 Aug