Implement Bidirectional Replication for PostgreSQL in Multi-DC Setup for APIM

[dakshina99]

Problem

In a multi-data center (multi-DC) deployment of WSO2 API Manager (APIM), ensuring data consistency across different geographical locations is a critical requirement. Currently, the system lacks a mechanism to synchronize PostgreSQL databases across multiple data centers in a bidirectional manner. Without bidirectional replication, there is a risk of data inconsistencies, especially in scenarios where both data centers need to handle read and write operations simultaneously.

Solution

Implement bidirectional replication for PostgreSQL to synchronize data across multiple data centers in a WSO2 APIM deployment using Logical Replication.

Affected Component

APIM

Version

4.x.x

Implementation

No response

Related Issues

No response

Suggested Labels

No response