Re: Need assistance for replication sync issue
От | Ron |
---|---|
Тема | Re: Need assistance for replication sync issue |
Дата | |
Msg-id | 0253c15b-a75e-4bc6-9049-8224d0ceb9e2@gmail.com обсуждение исходный текст |
Ответ на | Need assistance for replication sync issue (Veerendra Pulapa <veerendra.pulapa@ashnik.com>) |
Список | pgsql-admin |
On 10/19/23 05:08, Veerendra Pulapa wrote:
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.
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.
Born in Arizona, moved to Babylonia.
В списке pgsql-admin по дате отправления: