We just got a brand new HP DL370 G6 server with 14 X 146 gb and 2 X 300 gb sas drives. Inside we got 3 raid controllers (one HP DL370, one HP P410 and one HP P812). It has 2 disk bays and each of them is full. There are 4 cables that come out of them and go into the controllers. And i've connected them to the P410 and P812 array controllers. The server will be used as the central server for our ERP. I want to do the raid arrays like this: 1 X raid 1 from 2 small hdds (operating system) 1 x raid 1 from 2 small hdds (tempdb) 1 x raid 10 from 4 small hdds (database files) 1 x raid 10 from 4 small hddes (database logs - on another controller from the one above) 1 x raid 1 from 2 large hdds (backups, etc). I want to have 2 hotspares (one for each controller, except the big drives raid). My question is: can I assign some drives as hot spare from one controller to be a hot spare even for the other controller? Or as a global hot spare for all the controllers?
You can't assign "global hotspares" across controllers.
Spanning the workload across two controllers is not a bad idea. I would go with the P410 and P812 only though. I would however strive to get as many drives as possible in each array, which is why I would forget about the hotspares. Using RAID-1 and RAID-10, you don't have a need for the hotspare. We have more than 500 HP servers of various models (5.000+ drives). We have raid-10 arrays spanning more than 24 drives, and not a single hotspare configured on ANY of our servers. Been doing this for almost 10 years. Never lost an array due to "missing hotspare".
Just my 2 cents :)
I'm a HP-geek, you don't want to do it like that at all, here's how;
Is that clear? basically all the 146GB disks are in one big R10, backups are from a R1 array and use the P812 to just logically carve up the drives - it's easy and why you pay so much for the P812, let it do your work for you :)