DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Mirroring and Striping

  1. #1
    Join Date
    Sep 2007
    Posts
    19

    Mirroring and Striping

    Hi,

    Can anyone tell me the difference between mirroring and striping?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by lg123
    Hi,

    Can anyone tell me the difference between mirroring and striping?
    When you mirror two disks each disk is a "mirror" copy of the other. All changes happen to both drives simultaneously. When you stripe two drives, the look like one physical drive, but data gets written to one of the two drives. So mirroring give you redundancy and striping gives you more storage space but no redundancy.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by gandolf989
    When you stripe two drives, the look like one physical drive, but data gets written to one of the two drives. So mirroring give you redundancy and striping gives you more storage space but no redundancy.
    ...and better I/O throughput.
    Jeff Hunter

  4. #4
    Join Date
    Apr 2006
    Posts
    377

  5. #5
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote Originally Posted by gandolf989
    ... All changes happen to both drives simultaneously.
    You're exactly right on this. If I might add... ASM has a really cool paradigm for mirroring. Instead of the mirror copy being on the exact same cylinder and track of both drives, it applies an "anywhere else but here" rule to the mirror copy. Mirrored data can live on drives of different sizes and speeds, although the latter is not recommended, it does work.

    Cheers,
    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width