Postgres replication through 2 DCs

engmohamedeltok · 08-17-2020 05:59 AM

We are planning to install apigee in 2 sites, Main and DR.

We plan to install 2 Postgres nodes in each site (Master and slave in each site) and all the 4 nodes should be replicated.

According to apigee documentation, only 2 Postgres nodes can be replicated either both at the same site (Master and Slave) or one and each site (Master ate Main and Slave at DR).

Is it applicable to 2 Postgres nodes in each site (Master and slave in each site) and all the 4 nodes are replcated?

If yes, How this could be configured in the response

Thanks

Report Inappropriate Content

in each side you can have one master and one standby.

engmohamedeltok

By this no replication will be done between Master and DR site?

Report Inappropriate Content

Master master will not replicate with each other. But you can have one standby for two masters.

engmohamedeltok

I think one master with multiple standby will be better. Correct?

Report Inappropriate Content

We need to understand your requirement. If you want for DR then one standby in the other DC is enough. If you want to divide the analytics of each DC then you can go for two master and two standby.

We do purge analytics data in 180 days. So, we prefer to have one master in DC1 and one standby in DC2.

engmohamedeltok

Thanks Priyadarshi for your reply.

The case is that we must have HA nodes in main site DC1. DC2 is for DR only serving only when main site is done.

So we need one master and one standby in DC1 and at least one standby in DC2 with replication enabled between the master node and the other two standby nodes.

Is it applicable?

Report Inappropriate Content

Standby node directly cannot be written from qpid. it needs to go through the master. So, if you put only standby and during DR activity master is down, then no meaning of the standby. You have to make that master before DR. So, simple solution is have one master and one standby in each DC if you do DR activities.