xDB Replication Server - Multi Master

 Who needs multi-master replication?

Is your organization de-centralized into multiple units that are geographically dispersed? Does each unit manage similar or identical data? Are users in one unit finding they need quick access to data from other units within minutes and not hours or days? Are you struggling to maintain write availability for all your units?

A ‘yes’ to any one of these questions means you need to consider an xDB Replication Server Multi-Master configuration. With a multi-master configuration it’s easy for everyone to keep writing data they can all view in near real time and read more data than in single master configurations.



What can multi-master replication do?

When you have multiple master databases it is possible to achieve faster access to consolidated data, better uptime performance for round the clock updates, and read scalability, all using commodity hardware!

Frequently Asked Questions...

Continuous Data Integration

Say goodbye to scheduled batch jobs that temporarily synchronize data across locations from a central master. Continuous asynchronous master to master replication means one region’s data is available to all regions in near real time.


High Availability for Writes

If a master in one region fails, users won’t have long delays to enter / update data until a replacement is brought online. You can re-route the downed region’s database requests to another region’s database. When the replacement master re-joins the cluster, it will re-synchronize with the other masters automatically.

Automatic Conflict Resolution

If conflicting edits occur on the same row during replication (i.e. a uniqueness, update or delete conflict), you can choose from Earliest Timestamp, Latest Timestamp, Node Priority, custom algorithms, or manual options for determining a resolution. You can even have a standby resolution should your first choice not resolve the conflict.



Scalability for Reads

In addition to each of your local regions or users having faster access to integrated data, your systems will be able to handle more reads and queries.  Each master will be available to handle queries from any region or any query needing consolidated data.  To scale further you can build out Hot Standby replicas to each master that handle even more read loads providing you a very flexible and scalable architecture for the future.

What's New in 6.0

• Log Based Replication for Postgres 9.4+
• Simplified High Availability for Multi Master
• Wildcard based selection of publication tables
• Read more in the Release Notes and the What's New section of the documentation

EDB Postgres Integration Suite

Learn more about the EDB Postgres Integration Suite 

xDB Single-Master Replication

• Improve Read Performance
• Improve Read Scalability
• Improve master performance
• Replicate to/from Oracle®
• Replicate to/from SQL Server®
• Replicate filtered records
• Easy to use GUI console
• Supports cascading configurations
Learn more... | Download

How to buy this tool

EDB Tools for Performance, Scalability, High Availability, and Management 

Tools are included in database subscription purchases as checked and noted in the table on the Postgres Plus Subscription Plans and Prices page.

Compare and buy here...

Read our Blog Post

EDB Support for PostgreSQL BDR

EnterpriseDB has received many questions regarding a new PostgreSQL Bi-Directional Replication (BDR) feature under development. This blog post will help Postgres users understand this feature and their choices for Postgres replication solutions, including our own EDB xDB Replication Server.

Read here...

For Inquiries and product purchases call:

US +1 781-357-3390
or   +1 877-377-4352

EMEA +31 70 891 8451

Japan +81 3 5488 6007

UK +44 (0) 1235 227276

India +91 20 30589500/01

or Write to us...