EDB Replication Server

Data replication for Postgres-based digital business solutions

EDB Replication Server

EDB Replication Server

EDB Replication Server (EPRS) provides a robust data replication platform that replicates between Postgres databases in a single-master or multi-master mode, or from non-Postgres databases to Postgres in a single master mode. EPRS provides geographic load balancing, simplifies real-time migration, and enables heterogeneous data integration.

Overview

Architecture

EDB Replication Server Architecture

Multi-Master Replication

Multi-Master Replication

EDB Postgres Replication Server is a replication technology that enables geographically distributed Postgres data management with fast read/write access in every geography. EDB Postgres Replication Server supports PostgreSQL and EDB Advanced Server.

Based on logical decoding, introduced in PostgreSQL 9.4, EDB Replication Server uses the Write-Ahead Logs (WAL) to extract relevant changes for replication. This replaces the use of triggers, which created overhead on the publication databases, and reduces latency significantly.

Even though application and architecture design aim to avoid data update conflicts, not every conflict can be avoided. This is why EDB Replication Server also offers proper conflict resolution methods to ultimately prevent data inconsistencies.

For replication management EDB Replication Server provides a comprehensive graphical user interface (GUI).

Replication from SQL Server or Oracle to Postgres

Replication from SQL Server or Oracle to Postgres

EDB Postgres Replication Server enables single master replication between Postgres and Oracle or Postgres and SQL Server. Configurations are supported with PostgreSQL and EDB Postgres Advanced Server.

When replicating from a remote database, EDB Postgres Replication Server allows enterprises to add read replicas for reporting, possibly reducing license cost for add-ons such as Oracle Active Data Guard.

When replicating either from or to a remote data source, it makes specific data available within the remote database as one leg of data federation.

For replication management EDB Replication Server provides a comprehensive graphical user interface (GUI).

Using the Replication Console

Using the Replication Console

EDB Postgres Replication Server offers a comprehensive graphical user interface (GUI) to manage both single master and multi-master replication. The console helps users easily setup publications and subscriptions, create initial snapshots, monitor replication, and resolve conflicts.

EDB Replication Server Architecture Overview

EDB Replication Server Architecture Overview

EDB Replication Server is based on publications and subscriptions. Masters provide publications; replicas subscribe to publications. The configuration is held in EDB Replication Server’s control database.

Replication from EDB Postgres Advanced Server 9.4 or higher and PostgreSQL 9.4 or higher uses log-based replication, extracting any changes from the Write-Ahead Logs (WAL) of the master and applying these changes to the replicas reducing the overhead on the master and reducing latency significantly. Trigger-based replication is also available.

Replication from a earlier versions of EDB Postgres Advanced Server and PostgreSQL, as well as replication from Oracle and SQL Server is trigger-based.

Why not to use Slony, BDR or pgLogical?

Why not to use Slony, BDR or pgLogical?

Slony has been a reliable trigger-based single master replication solution for years also offering cross-version replication. EnterpriseDB supports Slony, but Slony does not provide the faster log-based replication and does not offer multi-master replication, features that users of EDB Postgres Replication Server can benefit from in terms of performance and use case compatibility.

Bi-Directional Replication (BDR) is a PostgreSQL fork with multi­-master replication functionality. It is based on PostgreSQL’s logical decoding, as is EDB Postgres Replication Server. BDR has similar functionality, but does not offer the replication of a subset of data (no row­level filtering) and conflict detection is rudimentary. It does not offer single master replication and does not integrate with Oracle nor SQL Server.

pgLogical offers single master replication based on PostgreSQL’s logical decoding - the same method that is used by the EDB Postgres Replication Server. EDB Replication Server has much of the same functionality as pgLogical, but also offers single master replication in heterogeneous database environments and multi­-master replication from within the same graphical user interface (GUI). pgLogical does not offer a GUI and requires more effort to configure and manage than EDB Postgres Replication Server.

Resources