List:General Discussion« Previous MessageNext Message »
From:Steven Lefevre Date:August 21 2003 5:20pm
Subject:RE: RAID or not?
View as plain text  
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

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