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

Merge replication for load balancing Expand / Collapse
Author
Message
Posted Monday, October 28, 2013 7:50 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:44 AM
Points: 66, Visits: 437
I have inherited an environment where Merge replication is used to replicate the whole database to another server on the same site. One DB is used for the inhouse system and the replicated one used for a web application. Both are using the same tables.

They say it is used for both load balancing and a HA solution. Has anyone else come across something like this? I know Merge replication is not designed for this, but are there ANY benefits in this setup. Wont the load balancing reasoning be counter productive because of the addition workload of the triggers and replication?

Any advise on this will help, as I want to make a proposal to management

Thanks..

Post #1508888
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse