Which RAID option would you recommend?

You are working as a DBA in ABC Corp. You are working on an online transaction processing (OLTP) database. The database size has grown to 100 GB. The database will support new applications and more users will be added. Presently, the database uses normal file system storage. However, before the new applications are added, you want to move the storage to RAID. You are in consultation with the OS Administrator for finalizing the RAID option.Performance is the primary goal of the database because applications are demanding in terms of I/O operations and it should have lower mean recovery time (MTTR) than the current MTTR.
Which RAID option would you recommend?

You are working as a DBA in ABC Corp. You are working on an online transaction processing (OLTP) database. The database size has grown to 100 GB. The database will support new applications and more users will be added. Presently, the database uses normal file system storage. However, before the new applications are added, you want to move the storage to RAID. You are in consultation with the OS Administrator for finalizing the RAID option.Performance is the primary goal of the database because applications are demanding in terms of I/O operations and it should have lower mean recovery time (MTTR) than the current MTTR.
Which RAID option would you recommend?

A.
RAID level 0

B.
RAID level 1

C.
RAID level 5

D.
RAID level 1 over 0(0+1)

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

bmfloyd

bmfloyd

Why not 0+1???

Reply

vasya

vasya

Because RAID 1 over 0 has a high MTTR.

Reply