Re: BDR OR MASTER SLAVE REPLICATION WITH REPMGR IS SUITABLE FOR LARGEONLINE APPLICATION

Поиск
Список
Период
Сортировка
От Rijo Roy
Тема Re: BDR OR MASTER SLAVE REPLICATION WITH REPMGR IS SUITABLE FOR LARGEONLINE APPLICATION
Дата
Msg-id CADGM9_cc5M95sqs211eXmAUqw_uEaRp2eco=2U4_AOSZCsP__Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BDR OR MASTER SLAVE REPLICATION WITH REPMGR IS SUITABLE FOR LARGEONLINE APPLICATION  (soumitra bhandary <soumitra.bhandary@hotmail.com>)
Ответы Re: BDR OR MASTER SLAVE REPLICATION WITH REPMGR IS SUITABLE FOR LARGEONLINE APPLICATION
Список pgsql-admin
Дерево обсуждения
BDR is best when you have a need of multi-master environment like a distributed database paradigm where you have a need of writing/reading to/from local masters let's say masters in NY, London, China, India etc.. And it uses pglogical to achieve this with a globally managed transaction XID's. It needs to be properly tested how it handles conflicts in a heavy oltp workload application.
If you only need high availability for a heavy oltp application, a well set active passive model of streaking replication backed by repmgr where writes are only hitting primary and reads on standby will help. Otherwise you can also consider citusdata.. 

Note: I am not an advocate of any vendors, my comments are purely based on my experience and I love Postgresql the way it is!

Regards, 
Rijo Roy 


On Fri, 12 Apr 2019, 6:34 am soumitra bhandary, <soumitra.bhandary@hotmail.com> wrote:
To ensure zero down time. 

Sent from my iPhone

On 12-Apr-2019, at 12:35 AM, Prince Pathria <prince.pathria@goevive.com> wrote:

It very much depends upon your use case. Why you want a multi master implementation? 
 
Happy to help :)
Prince Pathria Systems Engineer Evive +91 9478670472 goevive.com


On Thu, Apr 11, 2019 at 8:03 PM soumitra bhandary <soumitra.bhandary@hotmail.com> wrote:
Hi ,

Can anyone suggest me for large OLTP application which sort of replication is suitable BDR or master slave replication with synchronous and asynchronous node and REPMGR enabled.
Can BDR handle real-time conflicts arises due to high network latency or Dataintegrity conflicts?? Please suggest

Sent from my iPhone

В списке pgsql-admin по дате отправления: