In distributed, networked environments, a system can consist of multiple applications. Each application can have its own database. The Advanced Replication architecture supports a model where a replica database contains data from multiple master databases. For instance, a local database can contain a replica from a billing host system and network configuration host system. Both two-tier and many-tier architectures are scalable to accommodate multiple master databases. The two-tier architecture shown in the following diagram makes use of multi-master synchronization.
The example illustrates the concept of multi-master synchronization at a table level.
▪ SYSTEM A and SYSTEM B have master databases that are separate and independent of each other.
▪ For each master database, a database catalog is created in the replica database.
▪ Catalog A in the replica database synchronizes with the master catalog on SYSTEM A. Catalog B in the replica database synchronizes with the master catalog on SYSTEM B.
▪ Catalog C on the replica database is for data that is only in the replica database.
Key features in multi-master synchronization models
▪ Replica databases can register to synchronize data with multiple master databases.
▪ Replica data from different master databases is kept separate by using catalogs.