I have two servers and one RAID array. I am building an active/active SQL 2008 cluster meaning that at all times there will be two instance of SQL running on this cluster. In case of a server failure both instances of SQL Server will be running on the one remaining server.
This means I need seven disk letters:
Two for data files
Two for log files
Two for tempdb.
One for quorum
2 x Dell R710 with Perc 5/e
1 x MD3000 w/ 15 x 136GB
I am unsure which way to setup the disks for a two node active-active cluster.
1) Do I create one large 14-disk RAID 10 and then carve out the needed 7 drive letters?
2) Do I create 2 2-disk RAID 1 (Logs) and 2 5-disk RAID 5 (Data) then carve out the needed 7 drive letters? (The quorum and tempdb drives will be carved out of a log disk).
My concern with #1 is that both servers will be reading and writing to the same RAID 10 array and will bog it down. What if server A is writing and server B is reading? If they each get their own array then they won't compete-- theoretically.