x

Database Mirroring 'split brain' scenario

Hi, In high availablity mirroring if the connection between witness server and primary server is break off but if primary server is still up. The witness server will up mirror server. In this scenario both primary server and mirror server is up and this scenario is called as SPLITBRAIN.

Question1 : In this case the users are connected to primary? or mirror server?

Question2 : Once the connection between witness server and primary server break even primary server is up , are users connected to primery server or secondary server?

please support.

rgds,
more ▼

asked May 03 '12 at 01:48 PM in Default

pits gravatar image

pits
830 73 91 92

Thank you Kev,

regarding failover partner,is it placed between Users and Primary/mirror server or The failover partner receives signal of failover from witness server and divert users according to witness server signal? or failover partner work independently and directly with primery/mirror server without any signal from witness server? rgds
May 04 '12 at 01:38 PM pits
(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

Your users will be connected to whichever server they are configured to access. If they have (for example) the "Failover Partner =" part in their connection strings, then if they have lost connection to the principal, they will try to connect to the mirror.

It kind of depends on the nature of the loss in connection between the principal, mirror and witness. If the primary is up on Site A, but the link is down between it and the mirror (and witness) on Site B, hence causing the scenario you have described, but the users are also at Site A, then they will still be on the principal.

If the users are at Site C, and there is no break in the link between C->A or C->B, they will probably still be connected to the principal.
more ▼

answered May 03 '12 at 02:01 PM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

Thank you Kev,

regarding failover partner,is it placed between Users and Primary/mirror server or The failover partner receives signal of failover from witness server and divert users according to witness server signal? or failover partner work independently and directly with primery/mirror server without any signal from witness server? rgds
May 04 '12 at 01:52 PM pits
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x56

asked: May 03 '12 at 01:48 PM

Seen: 933 times

Last Updated: May 04 '12 at 01:52 PM