June 29, 2012 at 3:44 am
Hello,
we have to configure cluster on a 2 node server, i have to gather some points before suggesting active- passive or active - active on 2005 node.
I want to know the negatives of both types and server team asked about the storage drive failure point recovery also.
experts advice pls.
Regards
Durai Nagarajan
June 29, 2012 at 3:51 am
Clustering is not a DR technology, its a HA technology. You can use Geo clustering to provide DR but typically this costs a lot of money.
http://www.sql-server-performance.com/2002/clustering-intro/
June 29, 2012 at 4:51 am
durai nagarajan (6/29/2012)
Hello,we have to configure cluster on a 2 node server, i have to gather some points before suggesting active- passive or active - active on 2005 node.
I want to know the negatives of both types and server team asked about the storage drive failure point recovery also.
experts advice pls.
I am not an expert...just sharing few points...
1) Active/Passive - one node is always idle.
2) Active/Active - hardware (esp. RAM, CPU) should be capable of bearing load of all the instances.
3) Storage drive failure - Use RAID. It should be left to SAN team.
June 29, 2012 at 5:48 am
Suresh B. (6/29/2012)3) Storage drive failure - Use RAID. It should be left to SAN team.
does that mean raid will have very minimal failure or SAn will take care in proper way.
one more doubt does this cluster has to be mirrored or log shipping when RAID drives are used.
Regards
Durai Nagarajan
June 29, 2012 at 6:17 am
durai nagarajan (6/29/2012)
Suresh B. (6/29/2012)3) Storage drive failure - Use RAID. It should be left to SAN team.
does that mean raid will have very minimal failure or SAn will take care in proper way.
one more doubt does this cluster has to be mirrored or log shipping when RAID drives are used.
In RAID, redudent disks are used. It can withstand failure of a disk.
SAN is needed for clustering.
It is NOT necessary use database mirroring/log-shipping with failver clustering.
Please check the link given by Anthony.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply