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.