OAAM 11g Multisite Cluster Implementation: How To Do Partial Replication Of DB?

Last updated on OCTOBER 02, 2017

Applies to:

Goal

We have 3 sites in production for SSO and we are performing native OAAM integration with OpenSSO. Each site has its own database and accordingly we would need OAAM tables to be present in all the three data centers. We would need assistance on getting information on which tables can be replicated and which data cannot be.
Give these requirements; we see three categories of data (tables) with their own peculiar replication needs

1. Configuration tables [these need only be synced from the "main" data center to the other two one way]
2. Static tables like IPGeoLocation data [this does not need to be synchronized, the load scripts can be run on the 3 data centers]
3. Transactional tables [These will need to be replicated 3 way]

We need your help in dividing up the 250+ tables into these 3 categories. Is this possible in the architecture for OAAM deployment topologies?
 

Solution