dbTalk Databases Forums  

Failover with Replication

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Failover with Replication in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bk29
 
Posts: n/a

Default Failover with Replication - 01-27-2005 , 06:19 PM






Hello,

I am not sure how to approach this problem. What I need to do is setup
failover as well as data copying. I need to setup clustering on two nodes.
If one node goes down then the other node should pick up the load. But the
problem is that you need to have a shared SAN. Is there anyway to get away
from a shared SAN (disk array) and still setup clustering.

Can you have two servers with their own seperate storage. Node A
(Primary) also replicates the data to Node B (Seconday). But if node A goes
done, node B picks up the load but it already has all the data from Node A.

Basically what I am trying to do is setup failover as well have data
replication so that if the data gets corrupt on Node A for any reason, Node B
would be a Hot stand by and would switch over automatically.

Please let me know how this could be possible or if you need any
further explanation.

Thanks,
--
bk29

Reply With Quote
  #2  
Old   
bk29
 
Posts: n/a

Default RE: Failover with Replication - 01-28-2005 , 11:59 AM






Thank You for the response. It was very helpful. I have found some third
party software like incepto and geoclusters that seem to accomplish what we
are trying to do. But they are not supported by microsoft.

I guess our main concern with Clustering was the Shared disk being the
single point of failure due to user interaction, corruption, etc. If we
implement the log shipping we will not have a hot standby. If for some
reason the shared disk does fail, we can bring up the log shipped server, but
this will have to be a manual process and for some applications it may be too
time consuming.

I will resarch further with the third party software. Any further advice
would be appreciated. Thank you again for your help.


"bk29" wrote:

Quote:
Hello,

I am not sure how to approach this problem. What I need to do is setup
failover as well as data copying. I need to setup clustering on two nodes.
If one node goes down then the other node should pick up the load. But the
problem is that you need to have a shared SAN. Is there anyway to get away
from a shared SAN (disk array) and still setup clustering.

Can you have two servers with their own seperate storage. Node A
(Primary) also replicates the data to Node B (Seconday). But if node A goes
done, node B picks up the load but it already has all the data from Node A.

Basically what I am trying to do is setup failover as well have data
replication so that if the data gets corrupt on Node A for any reason, Node B
would be a Hot stand by and would switch over automatically.

Please let me know how this could be possible or if you need any
further explanation.

Thanks,
--
bk29

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.