Comparison of single-master and multi-master replication v7

Replication Server supports are two models of replication systems:

  • Single-master replication (SMR). Changes (inserts, updates, and deletions) to table rows are allowed to occur in a designated primary database. These changes are replicated to tables in one or more secondary databases. The replicated tables in the secondary database aren't permitted to accept any changes except from its designated primary database. (This is also known as primary-to-secondary replication.)
  • Multi-master replication (MMR). Two or more databases are designated in which tables with the same table definitions and initial row sets are created. Changes (inserts, updates, and deletions) to table rows are allowed in any database. Changes to table rows in a database are replicated to their counterpart tables in every other database.

For a single-master replication system, a variety of configurations are supported including:

  • Replication between PostgreSQL and EDB Postgres Advanced Server databases (between products in either direction)
  • Replication in either direction between Oracle and EDB Postgres Advanced Server
  • Replication in either direction between SQL Server and PostgreSQL
  • Replication in either direction between SQL Server and EDB Postgres Advanced Server
  • Replication in either direction between PostgreSQL and Oracle

For multi-master replication, the participating database servers in a given multi-master replication system must be of the same type:

  • PostgreSQL database servers
  • PostgreSQL database servers and EDB Postgres Advanced Servers operating in PostgreSQL compatible mode
  • EDB Postgres Advanced Servers operating in PostgreSQL compatible mode
  • EDB Postgres Advanced Servers operating in Oracle compatible mode
Note

A given database can't simultaneously participate in both a single-master replication system and a multi-master replication system.