Load balancing in Replication

  • I have little bit knowledge in Replication. I have a requirement to do the bi-directional replication. Means i have two databases A, B resides in two different servers, and needs to replicate these. If i made changes to A it should reflect in B and if i made changes in B it should reflect in A also. I want to know two things.

    1.) What type of replication should i use? Merge, Transactiona or Snapshot !!!

    2.) How can achieve load balance through replication.

    Please help

    Regards

    Rajesh V R

  • Bi-directional is a type of transactional replication. Do some research on that. You can use merge, which gives you more control over collisions, but also it is more complex.

    Snapshot will not work.

    You can't load balance with replication, at least not reliably. You can always have possible issues from the delay in getting data from one server to the other. To handle larger loads, what some people do is replicate read only information over, and have people read from one or more servers and then write back to the main one. This gives you a little better performance.

  • Also be aware that peer to peer transactional replication is available only in SQL Server 2005 Enterprise Edition (it may work on 2008 i am not sure)

    So i don't think that it is an option for 2000

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply