From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Need assistance for replication sync issue |
Date: | 2023-10-19 12:36:50 |
Message-ID: | 0253c15b-a75e-4bc6-9049-8224d0ceb9e2@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 10/19/23 05:08, Veerendra Pulapa wrote:
> Hello,
>
> I need some help with a database issue we’re facing. We have a situation
> where our primary data center and our disaster recovery site are far
> apart, and this long distance is causing delays in keeping our data
> synchronized. It’s become a problem as we want our data to be as
> up-to-date as possible.
>
> Do you have any suggestions for dealing with this kind of situation? We’ve
> tried a few things, but we’re still struggling with the replication delays
> caused by the high latency between the sites.
>
> Note: Bandwidth is very low and latency is very high.
>
> I’d appreciate any advice you can provide.
/Never/ use /synchronous/ replication over a WAN. Not only because
"physics", as Laurenz mentions, but also because WAN links can be /slow/,
and break more often than LAN links.
Thus, use "async" replication instead.
--
Born in Arizona, moved to Babylonia.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2023-10-19 12:59:19 | Re: connection timeout expired |
Previous Message | Laurenz Albe | 2023-10-19 10:55:08 | Re: Need assistance for replication sync issue |