This discussion is archived
6 Replies Latest reply: Feb 21, 2012 11:01 PM by 841474 RSS

Refrential Integirty on masters ( 5.2 )

841474 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks Philip.

Legend

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