Re:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 24 Nov 2021 at 14:17, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
>
> > On Nov 24, 2021, at 2:18 AM, Firthouse banu <penguinsfairy@xxxxxxxxx> wrote:
> >
> > Please do let me know best tool for this I have 5 servers all should be in sync with data.
>
> Have you analyzed what data conflicts will occur and how to resolve them?

Which makes it sound like a problem exists, so I think some additional
information is needed for a balanced assessment.

BDR has facilities that allow you to find out whether any conflicts
occur for an application, so it is easy to assess this. Conflicts that
do occur are resolved automatically using programmable rules, yet
logged for later assessment. Data quality tools allow you to confirm
no anomalies exist in realtime.

Any conflicts that occur would be as a result of 1) data access
patterns, 2) choice of consistency, 3) how transactions are routed to
nodes. It isn't random and many applications are naturally conflict
free, even with randomly routed transactions.

If you use BDR using the AlwaysOn architecture then all transactions
are routed via a single node and no conflicts occur in normal running.
Depending on how failover is achieved, there may be a small window for
conflicts.

-- 
Simon Riggs                http://www.EnterpriseDB.com/





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux