Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database mirroring with transactional replication


Database mirroring with transactional replication

Author
Message
meghna.bhargav
meghna.bhargav
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 429
Hi

How database mirroring is useful with transactional replication and in which situation it should be used?

Regards
avinashily
avinashily
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 195
its for scalability and high availability that we use replication and mirroring together.
meghna.bhargav
meghna.bhargav
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 429
Can you tell me in which situations it can be used?
avinashily
avinashily
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 195
yes sure,

before that i would like you to ask yourself few questions

1. what are the options by which you can make your server available 99.9999% up in an year?
2. what are the high availablity options available with sql server?

ok lets take replication:

there are different types of replications available.

1.snapshot replication
2. transactional replication
3. merge replication

replication has three servers

1. publisher: the server from which data is published to the different servers in different or same location with the help of distribution server.
2. distribution server distributes the data changes from the publisher to the different subscribers
3. subscribers are the servers where data from publisher is replicated with the help of distributor.

for a successful replication all the three servers should function correctly. if any of the servers dont do their function properly the replication is failed.

coming to mirroring :

this also has three servers

1. principal server: this the server from which data is taken and mirrored on mirror server.
2. witness server; it just watches whether the principal and mirror servers are able to communicate or not. if due to any reason if the principal server fails then the fail over is switched to mirror server and there will be no down time due the server failure.
3. mirror server: this server will be in recovery mode and tranactions from principal server is mirrored to this server.


note: only databases are mirrored or replicated it is not the instances which are done.

and the important point to remember is in replication you can do the partial data to be replicated among the servers while in mirroring the whole database is mirrored and you cant select the subset of the data.

when you combine the both high availability options you get double protection that is near 99.999 percent uptime.

you can check the attachment to know how it is done.
Attachments
high availablity.bmp (123 views, 578.00 KB)
meghna.bhargav
meghna.bhargav
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 429
Thanks a lot.It really helped to clear the concept.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search