3 Replies Latest reply: Jul 9, 2014 3:45 AM by Sylvain Duloutre-Oracle RSS

    What is the limitation of the number of replicas a supplier should have ?

    bhadra12

      Hi,

       

      What is the maximum number of replication agreements that we can configure for a supplier in Multi master topology?

       

      Thanks you.

        • 1. Re: What is the limitation of the number of replicas a supplier should have ?
          Sylvain Duloutre-Oracle

          Hello,

           

          You can configure a replication deployment with an unlimited number of masters and you are not required to include any replica or hubs in your topology.

          Fully meshed replication deployment are supported too, so there is no hard-coded max number of replication agreements a supplier can handle.

          However, the number of consumers a supplier can replicate to depends on the capacity to the supplier server.

           

          Because the masters in a replication topology handle all update traffic, it could put them under a heavy load to support replication traffic to the consumers. You can off-load replication traffic to several hubs that can each service replication updates to a subset of the consumers. So it all depends on the write traffic and the capacity of the server.

          How many servers have you deployed ?


          -Sylvain


          ------

          When closing a thread as answered remember to mark the correct and helpful posts to make it easier for others to find them

          • 2. Re: What is the limitation of the number of replicas a supplier should have ?
            bhadra12

            Many thanks Sylvain!

            We have 2 master 2 HUB and and 20 read servers.

            It would be great if I could estimate/calculate the write traffic and so maximum number of consumers for each HUB and master servers in our topology.

             

            -bhadra

            • 3. Re: What is the limitation of the number of replicas a supplier should have ?
              Sylvain Duloutre-Oracle

              Bhadra,

               

              The number of replica per hub impacts replication performances/latency.

               

              In your case, each replica is probably connected to both hubs (to avoid single point of failure), so each hub has to manage 20 replicas. This is quite

              a significant number and may introduce delays in write replays. You can monitor replication delays using insync - 11g Release 1 (11.1.1.7.0)

               

              If possible, it would be better to add 2 more hubs, and connect each replica to 2 hubs, so that each hub has only 10 replicas to manage.

               

              -Sylvain

               

              ------

              When closing a thread as answered remember to mark the correct and helpful posts to make it easier for others to find them