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)
Mmm. Why not 0+1??? My choice is D because 0+1 provides protection plus better performance.
A is right.
Performance is the
primary goal of the database
I agree: A is correct. We want performance, RAID level 0 does striping.
RAID level 1 is mirroring. We want performance, so B is not correct.
RAID level 0 over 1 (1+0) would be an option, but we cannot choose it, just we RAID level 1 over 0 (0+1). So this is not an option.