6 Replies Latest reply: Feb 22, 2012 1:01 AM by 841474 RSS

    Refrential Integirty on masters ( 5.2 )

    841474
      Hi,

      We're having two masters on 11g and then four on 5.2. We would be enabling Referential Integrity on 11g, however the below link recommends that we should "enable" on all masters. What are downside of not enabling on other 5.2 masters? Do anyone has strong suggestion to put in.

      http://docs.oracle.com/cd/E19693-01/819-0995/repl-ref-int/index.html

      Thanks.
        • 1. Re: Refrential Integirty on masters ( 5.2 )
          841083
          If you don't run the referential integrity plugin on each master you risk missing the removal of anr references when you remove an entry on a machine without the plugin enabled.

          You either need it enabled on all masters or none -- and if none, you must take care of removing references to a deleted entry yourself.

          Its probably also worth mentioning that you can only have FOUR masters total in any replication system which includes one or more DS5.2 instances.
          Sounds like you have six.
          • 2. Re: Refrential Integirty on masters ( 5.2 )
            841474
            Thanks Philip

            Well - here is the setup, let me know if this is not recommendable :

            Server 1 ( 11G ) > Server 3 ( 5.2 )
            Server 1 ( 11G ) > Server 5 ( 5.2 )

            Server 2 ( 11G ) > Server 4 ( 5.2 )
            Server 2 ( 11G ) > Server 6 ( 5.2 )

            All the above are master to master, also Server 1 and Server 2 are in master setup as well. does this still exceed number of masters limitation?

            TIA.
            • 3. Re: Refrential Integirty on masters ( 5.2 )
              841083
              To determine if you are exceeding the limit, simply look at all the interconnected systems and count the masters.
              If in the entire system, there are more than 4 there are too many.

              Its not how many masters are directly connected to each other, its how many masters are connected at all, even indirectly.
              • 4. Re: Refrential Integirty on masters ( 5.2 )
                841474
                Thanks Philip.

                I beleive this setup is working fine, what are downsides of this if we've more then 4 masters.? Things to watch for etc?

                If you see there are only 4 masters for 5.2 and 2 masters for 11g, will that still be within limit?

                Thakns
                • 5. Re: Refrential Integirty on masters ( 5.2 )
                  841083
                  There is no hard limit on masters in DS5.2, but testing showed that there was the possibility of fairly severe performance issues with too many masters.
                  The more masters you have, and the longer you run with >4 masters, the more likely you are to run into performance issues. No guarantee that you will, its just a possibility.

                  The biggest downside is that configurations with > 4 masters are not supported, so any issues and you call Oracle for support, they may just tell you its an unsupported configuration.
                  • 6. Re: Refrential Integirty on masters ( 5.2 )
                    841474
                    Thanks Philip.