On Thu, 2023-10-19 at 10:08 +0000, Veerendra Pulapa wrote:
> 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?
Yes: don't use synchronous replication.
You are fighting with physics (speed of light), not with an implementation
deficiency. You cannot win that fight.
Yours,
Laurenz Albe