Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inquisitive
Starting Member
2 Posts |
 Posted - 2011-01-27 : 09:58:18
|
| I am not a database administrator, how ever i have been looking into peer to peer topolgy of microsoft sql server 2008 R2. I have a major doubt.all the msdn material and blogs say - sql server peer to peer replication is a High Scalability + High Availibility strategy.the examples say that if i have 4 nodes in the peer to peer topology - eg Node1 London , Node 2 Berlin ,Node 3 California and Node 4 Tokyo.I understand that each of these nodes can handle writes and reads independently. so when i write into Tokyo all the records are replicated in the other 3 nodes -london , berlin and california.Now my doubt is - How is failure handled in peer to peer topology. Theory say that if Tokyo is down the users at tokyo might still manage to use the node from berlin ,london or califoria and have live data. How exactly is this done?? Does this need to be configured in the application or is there some config in the sql server nodes?plz check this link http://msdn.microsoft.com/en-us/library/ms151244.aspx __________________________________i was talking of a case were i have a small data center with 4 machines and each machine is a node. There 's no internet detection at all. the webservers are load balanced using windows 2008 NLB and each web server is attached to the nodes london or california or berlin or tokyo.No lets say the hard disks at tokyo fails or there is some corruption of data. A user request comes in for tokyo.It has no clue that tokyo has failed.It tries to open a connection to the tokyo server but it struggles. How do i detect a failure of the tokyo node at the application level ? there may be other requests that are just being queued up at Tokyo,because the webserver is not down,only the db is down ! _____________________can any one elaborate? thanks |
|
|
|
|
|
Peer to peer Replication - Node Failure Detection