April 17, 2009 at 1:31 am
Hello,
I am a rookie in SQL Server 2005 technologies. While doing database mirroring i cam across the word "split brain". I googled it but couldn't got satisfactory answer that explains this situation. So can any one can please tell me what does split brain situation means ?...Thanx in advance.........
April 17, 2009 at 1:58 am
Consider a mirroring or clustering setup where there's an active server and a failover server that's offline. Split brain refers to a scenario where, for whatever reason, the communication link between the two goes down, the server that's active remains active and the offline failover server, thinking that it's partner is down, becomes active.
Now there are two servers trying to serve the same data for the same requests - split brain.
Both windows clustering and database mirroring have safeguards in place to ensure that this cannot happen. Clustering has the quorum drive, mirroring has the witness server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply