Why is RAID So Important for Databases?(www.sqlservercurry.com)

submitted by flyingkickflyingkick(331) 3 months, 19 days ago

A good server design has no, or very few, single points of failure. One of the most common server component that fails, are disks. So data redundancy becomes essential to recoverability. Redundant Array of Independent/Inexpensive Disks (RAID) is a disk system that provides better fault-tolerance by making use of redundancy of disk(s).

1 comment |category: |Views: 175

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

posted by dpetersondpeterson(4397) 3 months, 19 days ago 0

It's actually more common to see RAID 6 than RAID 5 when dealing with larger arrays. As the number of drives in the array increases, the likelihood that a second drive will fail while already rebuilding a failed drive increases dramatically (the stress of the rebuild often triggers the failure). RAID 6 ensures that 3 drives must fail before any data loss occurs, of which the chances are much lower.
RAID 50 (mirrored arrays of RAID 5) is also a common setup as it provides increased security over RAID 10 (2 drives from both arrays must fail for all data to be lost, rather than 1 from each array in RAID 10). For databases that are critical, I would recommend RAID 50 over RAID 10, decreasing the chances that you'll need to experience downtime should a failure occur.

Reply

information Login or create an account to comment on this story