Related to Replication from multiple remotes to one Master

Hi,

In my replication setup I want to do the replication from multiple
remotes to one master node.
I have defined all the remote?s target type as "peer-topeer"
because each one of them will be the source of replication.
I have defined the master database as "peer-to-peer". But for
this case replication to happened I have to define the Propagation
paths from remote to master as well as from master to remote (
actually speeking there is no need of path from master to remote
because master will be destination of the replication) then only
replication happens properly from multiple remotes.

I have tested this scenario by making master as "Protected read
only" instead of "peer-to-peer" but in that case only one remote
node whose replication server started first is able to replicate the
data, and for all other remote nodes the records are transfered to
input queue but remains there only and not processed further.

So if any one can give me solution for this problem.....

-Ajay

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Ingres-Related-Replication-multiple-remotes-Master-ftopict250948.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=868176
.

Relevant Pages

  • Re: project BIG AppleCrate
    ... request page "123.123.123.123/NADAOPEN FILE ... recognizes it as being for NadaNet. ... It sends the command over a serial connection to the Master ... So we have some options on how to get the "remote" code to LOAD. ...
    (comp.sys.apple2)
  • Re: DNS Forward lookup problem - now having problems with a period
    ... How did you set the replication scopes in the zone's properties in DNS on ... > each DNS server? ... to the remote 10.0.2.3 server, which runs on cable (we are working on ...
    (microsoft.public.windows.server.dns)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central o
    ... Looking for a SQL Server replication book? ... field offices return data to the central office so some of this "advanced" ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)
  • Re: Fixing Replication Failures
    ... If we get replication problems as indicated by repadmin /showrepl, ... We have two local DCs both of which replicate with the remote DC. ... caused by numerous issues from DNS misconfigs, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Failure recovery for ADAM master
    ... central site instance. ... you tried this when FSMO roles are not reachable? ... think about the impact on replication if you lose your hub site as the NTDS ... master instance (I mean 'Site' in AD/ADAM jargon, ...
    (microsoft.public.windows.server.active_directory)