question

pits avatar image
pits asked

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,
database-mirroring
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.