Hybrid Configurations

Hybrid configuration is one of the types of replication environments. Hybrid configuration is a combination of different configurations to meet different application requirements.

Multimaster replication and materialized views can be combined in hybrid or "mixed" configurations to meet different application requirements. Hybrid configurations can have any number of master sites and multiple materialized view sites for each master.

For example, multimaster (or n-way) replication between two masters can support full-table replication between the databases that support two geographic regions. Materialized views can be defined on the masters to replicate full tables or table subsets to sites within each region.

Key differences between materialized views and replicated masters include the following:

• Replicated masters must contain data for the full table being replicated, whereas materialized views can replicate subsets of master data.

• Multimaster replication enables you to replicate changes for each transaction as the changes occur. Materialized view refreshes are set oriented, propagating changes from multiple transactions in a more efficient, batch-oriented operation, but at less frequent intervals.

• If conflicts occur from changes made to multiple copies of the same data, then detection and resolution of conflicts always occurs at a master, which can either be a master site or a master materialized view site.