Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Merge Replication Question

3 views
Skip to first unread message

nj

unread,
Nov 11, 2009, 6:11:43 PM11/11/09
to
Hi,

I am configuring Merge replication for one of our new critical
project..This project has requirment to have servers on multiple
locations..Here is the basic architecture of replication setup..

Node A -- Publisher
Node B -- Subscriber 1
Node C -- Subscriber 2
Node D -- Subscriber 3

So I have few question about this architecture..If Publisher goes down
for 2 hours the all the subscriber would work independently or there
is any way to sync both subscriber until publisher is down..

Or Is there any other way where we can have 3-4 node (updateable) in
sync all the time without the restriction of publisher going down..

Basically we are trying to have something like Multi-Master
replication in Oracle which provides real-time synching among all the
nodes..

Thanks,
NJ

Hilary Cotter

unread,
Nov 11, 2009, 7:22:11 PM11/11/09
to
You might have some success with an alt sync partner. However, you really
should be using peer to peer replication for this functionality.

"nj" <njan...@gmail.com> wrote in message
news:c66a256e-9ca6-4161...@s21g2000prm.googlegroups.com...

nj

unread,
Nov 11, 2009, 7:57:17 PM11/11/09
to
But Peer-to-Peer replication doesn't provide conflict resolution and
also per books online prefers that update sent to one node only..Which
is a big restriction for our env..

Any other ideas..

Thanks,
NJ

Hilary Cotter

unread,
Nov 12, 2009, 10:02:02 AM11/12/09
to
Yes, p2p does not provide conflict detection in SQL 2005, it does in SQL
2008.

Keep in mind that the best way to handle conflicts is to avoid them,
preferably by partitioning your data so that they don't occur.

The recommendation to make all updates happen on one node is to prevent
conflicts, its not a hard rule per se.

Hilary


"nj" <njan...@gmail.com> wrote in message

news:31f90741-53e8-4dd6...@w37g2000prg.googlegroups.com...

Paul Ibison

unread,
Nov 21, 2009, 10:04:45 AM11/21/09
to
There is the option to "p2p_continue_onconflict" but this doesn't guarantee
convergence. Works ok for update-update conflicts but not all other types.
HTH,
Paul Ibison

Paul Ibison

unread,
Nov 21, 2009, 10:03:03 AM11/21/09
to
In SQL 2000 you could have an alternative sync partner.
In SQL 2005/8 you can specify -PublisherFailoverPartner and use mirroring
(http://www.replicationanswers.com/MergeHA.asp).
HTH,
Paul Ibison

0 new messages