This discussion is archived
3 Replies Latest reply: Oct 14, 2012 1:27 AM by ChrisJenkins RSS

Using propagators to replicate to many subscribers

930542 Newbie
Currently Being Moderated
Hi All,

The document says "Propagators are also useful for distributing replication loads in configurations that involve a master database that must replicate to a large number of subscribers".
Link [http://docs.oracle.com/cd/E18283_01/timesten.112/e13072/overview.htm]

My question is how do we define this " large number ". Is 5 a large number or 10 a large number ?

I've a bidirectional legacy replication scheme wherein a node replicates to 10 other nodes. Should i introduce Propagator between these nodes.

The Timesten version that i'm using is 11.2.2.4.

Any idea experts ?

Thanks , Ved
  • 1. Re: Using propagators to replicate to many subscribers
    ChrisJenkins Guru
    Currently Being Moderated
    There is no hard and fast rule for what constitutes 'large number' in this context. It depends on workload, hardware spec, network bandwidth etc. 10 might certainly be bordering on 'large' if the workload is heavy or the hardware underpowered.

    If you are not seeing any issues with replication performance then I would stick with what you have. Adding propagators can be beneficial in some usage scenarios but they do add an extra level of complexity and if a propagator fails then this will interrupt replication to the downstream databases until the propagator is back up and running.

    Chris
  • 2. Re: Using propagators to replicate to many subscribers
    930542 Newbie
    Currently Being Moderated
    Thanks Chris. I get your point.
    But I've a following question to it...What should be ideal scenario of using Propagators ? Does propagators make sense only if the replication performance is not optimum and it is limited by infrastructural constraints.
  • 3. Re: Using propagators to replicate to many subscribers
    ChrisJenkins Guru
    Currently Being Moderated
    Well, propagators are just a tool or capability like anything else so you use them where it makes sense to do so.

    The two common use scenarios are:

    1. Where the overall number of subscribers are such that the CPU/IO load on the master or the network bandwidth is stressed. Adding one or more propagar=tors will reduce the load.

    2. Where you have multiple subscribers remote over a WAN type connection. By locating a propagator at the remote site you reduce the multipel replication streams to the site down to a single replication stream thus reducing bandwidth requirements.


    Chris

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points