Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database mirroring with transactional replication Expand / Collapse
Author
Message
Posted Thursday, March 03, 2011 2:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 06, 2013 12:09 PM
Points: 110, Visits: 398
Hi

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

Regards
Post #1072930
Posted Friday, March 04, 2011 2:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 7:40 AM
Points: 57, Visits: 186
its for scalability and high availability that we use replication and mirroring together.
Post #1073158
Posted Friday, March 04, 2011 2:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 06, 2013 12:09 PM
Points: 110, Visits: 398
Can you tell me in which situations it can be used?
Post #1073163
Posted Friday, March 04, 2011 3:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 7:40 AM
Points: 57, Visits: 186
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.




  Post Attachments 
high availablity.bmp (97 views, 578.74 KB)
Post #1073168
Posted Friday, March 04, 2011 4:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 06, 2013 12:09 PM
Points: 110, Visits: 398
Thanks a lot.It really helped to clear the concept.

Post #1073193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse