From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
---|---|
To: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
Cc: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Firthouse banu <penguinsfairy(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Re: |
Date: | 2021-11-24 17:33:08 |
Message-ID: | e6222927-b6b3-56ce-c555-028afe790f86@sqlexec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Unfortunately, it should be stated that BDR is not open source. You
have to be a EnterpriseDB customer to get it. I think this applies to
BDR versions 2 and 3. I think only version 1 is truly open source at
this point.
Simon Riggs wrote on 11/24/2021 12:21 PM:
> On Wed, 24 Nov 2021 at 14:17, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
>>> On Nov 24, 2021, at 2:18 AM, Firthouse banu <penguinsfairy(at)gmail(dot)com> 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | MichaelDBA | 2021-11-24 17:38:00 | Re: Re: |
Previous Message | Simon Riggs | 2021-11-24 17:21:24 | Re: |