pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMulti master implementation
13+ messages / 8 participants
[nested] [flat]
* Multi master implementation
@ 2018-12-19 18:24 Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-21 09:12 ` Re: Multi master implementation Simon Riggs <simon@2ndquadrant.com>
0 siblings, 2 replies; 13+ messages in thread
From: Prince Pathria @ 2018-12-19 18:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
I want to how people are implementing multi master architecture in
Postgres. For now, I've come across BDR3 and bucardo for multimaster
approach.
Though both doesn't seem to be much promising to me.
Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production site
and [1 master + 1 slave]
in DR site.
Can you guys share how you did it and what issues did you faced?
Thanks in advance!
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
@ 2018-12-20 02:00 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-20 02:24 ` Re: Multi master implementation Ron <ronljohnsonjr@gmail.com>
2018-12-20 06:51 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-21 09:07 ` Re: Multi master implementation Simon Riggs <simon@2ndquadrant.com>
1 sibling, 3 replies; 13+ messages in thread
From: soumitra bhandary @ 2018-12-20 02:00 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Prince,
BDR is something which is not that much robust as conventional master slave replication.
Why do you want master node in DR set up ?
Do you want to enable simultaneous write operations at DR site as well?? Normally DR setups remain in cascade replication from one of the stand by node at production side .
Sent from my iPhone
On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com<mailto:prince.pathria@goevive.com>> wrote:
Hi,
I want to how people are implementing multi master architecture in Postgres. For now, I've come across BDR3 and bucardo for multimaster approach.
Though both doesn't seem to be much promising to me.
Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production site and [1 master + 1 slave]
in DR site.
Can you guys share how you did it and what issues did you faced?
Thanks in advance!
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com<http://goevive.com;
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-12-20 02:24 ` Ron <ronljohnsonjr@gmail.com>
2 siblings, 0 replies; 13+ messages in thread
From: Ron @ 2018-12-20 02:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I think he wants masters *and* slaves.
On 12/19/18 8:00 PM, soumitra bhandary wrote:
> Hi Prince,
>
> BDR is something which is not that much robust as conventional master
> slave replication.
>
> Why do you want master node in DR set up ?
> Do you want to enable simultaneous write operations at DR site as well??
> Normally DR setups remain in cascade replication from one of the stand by
> node at production side .
>
> Sent from my iPhone
>
> On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com
> <mailto:prince.pathria@goevive.com>> wrote:
>
>> Hi,
>>
>> I want to how people are implementing multi master architecture in
>> Postgres. For now, I've come across BDR3 and bucardo for multimaster
>> approach.
>>
>> Though both doesn't seem to be much promising to me.
>>
>> Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production
>> site and [1 master + 1 slave]
>> in DR site.
>>
>> Can you guys share how you did it and what issues did you faced?
>>
>> Thanks in advance!
>>
>> Happy to help :)
>> Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
>> <http://goevive.com;
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-12-20 06:51 ` Prince Pathria <prince.pathria@goevive.com>
2018-12-20 18:10 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2 siblings, 1 reply; 13+ messages in thread
From: Prince Pathria @ 2018-12-20 06:51 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Soumitra,
Sorry, please consider it as another site instead of DR.
Or if I want multiple masters in main site only i.e. [2masters+3slaves].
How should I implement that?
Our devs are planning to push applications that might have a lot of write
operations. If I say read to write ratio, [65% reads]:[35% writes]. I do
have automatic failover configured[in single master arch] but don't want
that postgres crashes due to unable to handle writes since writes contains
complex queries and blobs as well which makes them heavy. App code change
isn't an option for me.
Need your suggestions please!
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
On Thu, Dec 20, 2018 at 7:30 AM soumitra bhandary <
soumitra.bhandary@hotmail.com> wrote:
> Hi Prince,
>
> BDR is something which is not that much robust as conventional master
> slave replication.
>
> Why do you want master node in DR set up ?
> Do you want to enable simultaneous write operations at DR site as well??
> Normally DR setups remain in cascade replication from one of the stand by
> node at production side .
>
> Sent from my iPhone
>
> On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com>
> wrote:
>
> Hi,
>
> I want to how people are implementing multi master architecture in
> Postgres. For now, I've come across BDR3 and bucardo for multimaster
> approach.
>
> Though both doesn't seem to be much promising to me.
>
> Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production
> site and [1 master + 1 slave]
> in DR site.
>
> Can you guys share how you did it and what issues did you faced?
>
> Thanks in advance!
>
> Happy to help :)
> Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-20 06:51 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
@ 2018-12-20 18:10 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-21 07:13 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
0 siblings, 1 reply; 13+ messages in thread
From: soumitra bhandary @ 2018-12-20 18:10 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Well Prince , I have never worked with multiple master to be working in master slave replication . As you mentioned you have configured auto failover is this using EFM ? If you are using EFM then it won’t support multiple master in the cluster . I have worked with BDR where all nodes are worked as Master node but as you know it has downside as well .
Coming to your application operation , you can segregate all read request to be diverted to the slave nodes , may be to one synchronous node and all write operation to be diverted only in Master node. In tis manner your application should be able to share read and write load . Anyways that you would be the best person to take a call on this depending on your application .
For multi master replication you can go through below link if that helps you out subjected to the implementation and compatibility with your application process . If any other member in this group has any experience with multiple master with multi slave replication (apart from BDR) configuration experience , please share the same .
https://wiki.postgresql.org/wiki/Postgres-XC
Thanks
Soumitra
On 20-Dec-2018, at 12:21 PM, Prince Pathria <prince.pathria@goevive.com<mailto:prince.pathria@goevive.com>> wrote:
Hi Soumitra,
Sorry, please consider it as another site instead of DR.
Or if I want multiple masters in main site only i.e. [2masters+3slaves]. How should I implement that?
Our devs are planning to push applications that might have a lot of write operations. If I say read to write ratio, [65% reads]:[35% writes]. I do have automatic failover configured[in single master arch] but don't want that postgres crashes due to unable to handle writes since writes contains complex queries and blobs as well which makes them heavy. App code change isn't an option for me.
Need your suggestions please!
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com<http://goevive.com/;
On Thu, Dec 20, 2018 at 7:30 AM soumitra bhandary <soumitra.bhandary@hotmail.com<mailto:soumitra.bhandary@hotmail.com>> wrote:
Hi Prince,
BDR is something which is not that much robust as conventional master slave replication.
Why do you want master node in DR set up ?
Do you want to enable simultaneous write operations at DR site as well?? Normally DR setups remain in cascade replication from one of the stand by node at production side .
Sent from my iPhone
On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com<mailto:prince.pathria@goevive.com>> wrote:
Hi,
I want to how people are implementing multi master architecture in Postgres. For now, I've come across BDR3 and bucardo for multimaster approach.
Though both doesn't seem to be much promising to me.
Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production site and [1 master + 1 slave]
in DR site.
Can you guys share how you did it and what issues did you faced?
Thanks in advance!
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com<http://goevive.com/;
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-20 06:51 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 18:10 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-12-21 07:13 ` Prince Pathria <prince.pathria@goevive.com>
2018-12-21 08:03 ` Re: Multi master implementation Abhinav Mehta <mail@abhinavmehta.com>
2018-12-21 08:42 ` Re: Multi master implementation Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
0 siblings, 2 replies; 13+ messages in thread
From: Prince Pathria @ 2018-12-21 07:13 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Thanks Soumitra, Postgres-XC isn't getting any updates since 2015. Don't
know where it might get fail. I've also considered Postgres-XL which is in
active development state. But ver. 10 is very new to be used for production.
Curious to know how others are implementing multi master architecture!!
Prince Pathria
Systems Architect Intern Evive +91 9478670472 goevive.com
On Thu, Dec 20, 2018 at 11:40 PM soumitra bhandary <
soumitra.bhandary@hotmail.com> wrote:
> Well Prince , I have never worked with multiple master to be working in
> master slave replication . As you mentioned you have configured auto
> failover is this using EFM ? If you are using EFM then it won’t support
> multiple master in the cluster . I have worked with BDR where all nodes are
> worked as Master node but as you know it has downside as well .
>
> Coming to your application operation , you can segregate all read request
> to be diverted to the slave nodes , may be to one synchronous node and all
> write operation to be diverted only in Master node. In tis manner your
> application should be able to share read and write load . Anyways that you
> would be the best person to take a call on this depending on your
> application .
>
> For multi master replication you can go through below link if that helps
> you out subjected to the implementation and compatibility with your
> application process . If any other member in this group has any experience
> with multiple master with multi slave replication (apart from BDR)
> configuration experience , please share the same .
>
> https://wiki.postgresql.org/wiki/Postgres-XC
>
> Thanks
> Soumitra
>
>
>
>
> On 20-Dec-2018, at 12:21 PM, Prince Pathria <prince.pathria@goevive.com>
> wrote:
>
> Hi Soumitra,
>
> Sorry, please consider it as another site instead of DR.
>
> Or if I want multiple masters in main site only i.e. [2masters+3slaves].
> How should I implement that?
>
> Our devs are planning to push applications that might have a lot of write
> operations. If I say read to write ratio, [65% reads]:[35% writes]. I do
> have automatic failover configured[in single master arch] but don't want
> that postgres crashes due to unable to handle writes since writes contains
> complex queries and blobs as well which makes them heavy. App code change
> isn't an option for me.
>
> Need your suggestions please!
>
> Happy to help :)
> Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
>
>
> On Thu, Dec 20, 2018 at 7:30 AM soumitra bhandary <
> soumitra.bhandary@hotmail.com> wrote:
>
>> Hi Prince,
>>
>> BDR is something which is not that much robust as conventional master
>> slave replication.
>>
>> Why do you want master node in DR set up ?
>> Do you want to enable simultaneous write operations at DR site as well??
>> Normally DR setups remain in cascade replication from one of the stand by
>> node at production side .
>>
>> Sent from my iPhone
>>
>> On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com>
>> wrote:
>>
>> Hi,
>>
>> I want to how people are implementing multi master architecture in
>> Postgres. For now, I've come across BDR3 and bucardo for multimaster
>> approach.
>>
>> Though both doesn't seem to be much promising to me.
>>
>> Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production
>> site and [1 master + 1 slave]
>> in DR site.
>>
>> Can you guys share how you did it and what issues did you faced?
>>
>> Thanks in advance!
>>
>> Happy to help :)
>> Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
>>
>>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-20 06:51 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 18:10 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-21 07:13 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
@ 2018-12-21 08:03 ` Abhinav Mehta <mail@abhinavmehta.com>
1 sibling, 0 replies; 13+ messages in thread
From: Abhinav Mehta @ 2018-12-21 08:03 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: soumitra bhandary <soumitra.bhandary@hotmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Try Citus.
> On 21-Dec-2018, at 12:43 PM, Prince Pathria <prince.pathria@goevive.com> wrote:
>
> Thanks Soumitra, Postgres-XC isn't getting any updates since 2015. Don't know where it might get fail. I've also considered Postgres-XL which is in active development state. But ver. 10 is very new to be used for production.
>
> Curious to know how others are implementing multi master architecture!!
>
> Prince Pathria
> Systems Architect Intern
> Evive
> +91 9478670472
> goevive.com <http://goevive.com/;
>
>
> On Thu, Dec 20, 2018 at 11:40 PM soumitra bhandary <soumitra.bhandary@hotmail.com <mailto:soumitra.bhandary@hotmail.com>> wrote:
> Well Prince , I have never worked with multiple master to be working in master slave replication . As you mentioned you have configured auto failover is this using EFM ? If you are using EFM then it won’t support multiple master in the cluster . I have worked with BDR where all nodes are worked as Master node but as you know it has downside as well .
>
> Coming to your application operation , you can segregate all read request to be diverted to the slave nodes , may be to one synchronous node and all write operation to be diverted only in Master node. In tis manner your application should be able to share read and write load . Anyways that you would be the best person to take a call on this depending on your application .
>
> For multi master replication you can go through below link if that helps you out subjected to the implementation and compatibility with your application process . If any other member in this group has any experience with multiple master with multi slave replication (apart from BDR) configuration
> experience , please share the same .
>
> https://wiki.postgresql.org/wiki/Postgres-XC <https://wiki.postgresql.org/wiki/Postgres-XC;
>
> Thanks
> Soumitra
>
>
>
>
>> On 20-Dec-2018, at 12:21 PM, Prince Pathria <prince.pathria@goevive.com <mailto:prince.pathria@goevive.com>> wrote:
>>
>> Hi Soumitra,
>>
>> Sorry, please consider it as another site instead of DR.
>>
>> Or if I want multiple masters in main site only i.e. [2masters+3slaves]. How should I implement that?
>>
>> Our devs are planning to push applications that might have a lot of write operations. If I say read to write ratio, [65% reads]:[35% writes]. I do have automatic failover configured[in single master arch] but don't want that postgres crashes due to unable to handle writes since writes contains complex queries and blobs as well which makes them heavy. App code change isn't an option for me.
>>
>> Need your suggestions please!
>>
>> Happy to help :)
>> Prince Pathria Systems Architect Intern Evive +91 9478670472
>> goevive.com <http://goevive.com/;
>>
>>
>> On Thu, Dec 20, 2018 at 7:30 AM soumitra bhandary <soumitra.bhandary@hotmail.com <mailto:soumitra.bhandary@hotmail.com>> wrote:
>> Hi Prince,
>>
>> BDR is something which is not that much robust as conventional master slave replication.
>>
>> Why do you want master node in DR set up ?
>> Do you want to enable simultaneous write operations at DR site as well?? Normally DR setups remain in cascade replication from one of the stand by node at production side .
>>
>> Sent from my iPhone
>>
>> On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com <mailto:prince.pathria@goevive.com>> wrote:
>>
>>> Hi,
>>>
>>> I want to how people are implementing multi master architecture in Postgres. For now, I've come across BDR3 and bucardo for multimaster approach.
>>>
>>> Though both doesn't seem to be much promising to me.
>>>
>>> Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production site and [1 master + 1 slave]
>>> in DR site.
>>>
>>> Can you guys share how you did it and what issues did you faced?
>>>
>>> Thanks in advance!
>>>
>>> Happy to help :)
>>> Prince Pathria Systems Architect Intern Evive +91 9478670472
>>> goevive.com <http://goevive.com/;
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-20 06:51 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 18:10 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-21 07:13 ` Re: Multi master implementation Prince Pathria <prince.pathria@goevive.com>
@ 2018-12-21 08:42 ` Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
1 sibling, 0 replies; 13+ messages in thread
From: Jehan-Guillaume (ioguix) de Rorthais @ 2018-12-21 08:42 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: soumitra bhandary <soumitra.bhandary@hotmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Fri, 21 Dec 2018 12:43:57 +0530
Prince Pathria <prince.pathria@goevive.com> wrote:
> Thanks Soumitra, Postgres-XC isn't getting any updates since 2015. Don't
> know where it might get fail. I've also considered Postgres-XL which is in
> active development state. But ver. 10 is very new to be used for production.
I would not deploy Postgres-XC/XL over a WAN anyway!
> Curious to know how others are implementing multi master architecture!!
They are using Bucardo or BDR. Or they just don't.
Before sketching a very complex multi-master architecture, bench easier and
safer solution first. Put all your energy to define the simplest and
effective architecture you can, and bench it.
You might be surprised.
> On Thu, Dec 20, 2018 at 11:40 PM soumitra bhandary <
> soumitra.bhandary@hotmail.com> wrote:
>
> > Well Prince , I have never worked with multiple master to be working in
> > master slave replication . As you mentioned you have configured auto
> > failover is this using EFM ? If you are using EFM then it won’t support
> > multiple master in the cluster . I have worked with BDR where all nodes are
> > worked as Master node but as you know it has downside as well .
> >
> > Coming to your application operation , you can segregate all read request
> > to be diverted to the slave nodes , may be to one synchronous node and all
> > write operation to be diverted only in Master node. In tis manner your
> > application should be able to share read and write load . Anyways that you
> > would be the best person to take a call on this depending on your
> > application .
> >
> > For multi master replication you can go through below link if that helps
> > you out subjected to the implementation and compatibility with your
> > application process . If any other member in this group has any experience
> > with multiple master with multi slave replication (apart from BDR)
> > configuration experience , please share the same .
> >
> > https://wiki.postgresql.org/wiki/Postgres-XC
> >
> > Thanks
> > Soumitra
> >
> >
> >
> >
> > On 20-Dec-2018, at 12:21 PM, Prince Pathria <prince.pathria@goevive.com>
> > wrote:
> >
> > Hi Soumitra,
> >
> > Sorry, please consider it as another site instead of DR.
> >
> > Or if I want multiple masters in main site only i.e. [2masters+3slaves].
> > How should I implement that?
> >
> > Our devs are planning to push applications that might have a lot of write
> > operations. If I say read to write ratio, [65% reads]:[35% writes]. I do
> > have automatic failover configured[in single master arch] but don't want
> > that postgres crashes due to unable to handle writes since writes contains
> > complex queries and blobs as well which makes them heavy. App code change
> > isn't an option for me.
> >
> > Need your suggestions please!
> >
> > Happy to help :)
> > Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
> >
> >
> > On Thu, Dec 20, 2018 at 7:30 AM soumitra bhandary <
> > soumitra.bhandary@hotmail.com> wrote:
> >
> >> Hi Prince,
> >>
> >> BDR is something which is not that much robust as conventional master
> >> slave replication.
> >>
> >> Why do you want master node in DR set up ?
> >> Do you want to enable simultaneous write operations at DR site as well??
> >> Normally DR setups remain in cascade replication from one of the stand by
> >> node at production side .
> >>
> >> Sent from my iPhone
> >>
> >> On 19-Dec-2018, at 11:55 PM, Prince Pathria <prince.pathria@goevive.com>
> >> wrote:
> >>
> >> Hi,
> >>
> >> I want to how people are implementing multi master architecture in
> >> Postgres. For now, I've come across BDR3 and bucardo for multimaster
> >> approach.
> >>
> >> Though both doesn't seem to be much promising to me.
> >>
> >> Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production
> >> site and [1 master + 1 slave]
> >> in DR site.
> >>
> >> Can you guys share how you did it and what issues did you faced?
> >>
> >> Thanks in advance!
> >>
> >> Happy to help :)
> >> Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
> >>
> >>
> >
--
Jehan-Guillaume de Rorthais
Dalibo
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` Re: Multi master implementation soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-12-21 09:07 ` Simon Riggs <simon@2ndquadrant.com>
2 siblings, 0 replies; 13+ messages in thread
From: Simon Riggs @ 2018-12-21 09:07 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: Prince Pathria <prince.pathria@goevive.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Thu, 20 Dec 2018 at 02:01, soumitra bhandary <
soumitra.bhandary@hotmail.com> wrote:
> Hi Prince,
>
> BDR is something which is not that much robust as conventional master
> slave replication.
>
Completely wrong. Sounds like we have some misunderstandings there.
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/;
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Multi master implementation
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
@ 2018-12-21 09:12 ` Simon Riggs <simon@2ndquadrant.com>
1 sibling, 0 replies; 13+ messages in thread
From: Simon Riggs @ 2018-12-21 09:12 UTC (permalink / raw)
To: Prince Pathria <prince.pathria@goevive.com>; +Cc: pgsql-admin@lists.postgresql.org
On Wed, 19 Dec 2018 at 18:25, Prince Pathria <prince.pathria@goevive.com>
wrote:
> I want to how people are implementing multi master architecture in
> Postgres. For now, I've come across BDR3 and bucardo for multimaster
> approach.
>
> Though both doesn't seem to be much promising to me.
>
> Goal: 2 master and their 3 slaves. [1 master + 2 slaves] in production
> site and [1 master + 1 slave]
> in DR site.
>
That's exactly the case that BDR solves.
https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/
Please sign up to the next BDR webinar or download the white paper.
https://www.2ndquadrant.com/en/webinars/
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/;
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 13+ messages in thread
* MULTI MASTER IMPLEMENTATION
@ 2020-02-13 16:19 Peter Wainaina <petwah17@gmail.com>
2020-02-14 05:52 ` Re: MULTI MASTER IMPLEMENTATION soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Peter Wainaina @ 2020-02-13 16:19 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Kindly help with a tool that can use for implementing master master slave
replication
*WEB developer and programmer*
*system analyst-Crm*
*blogger*
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: MULTI MASTER IMPLEMENTATION
2020-02-13 16:19 MULTI MASTER IMPLEMENTATION Peter Wainaina <petwah17@gmail.com>
@ 2020-02-14 05:52 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2020-02-14 05:56 ` Re: MULTI MASTER IMPLEMENTATION Rahul Saha <rahul.blooming@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: soumitra bhandary @ 2020-02-14 05:52 UTC (permalink / raw)
To: Peter Wainaina <petwah17@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
You can try with BDR from 2ndQuadrant.
Thanks
Soumitra
Sent from my iPhone
On 13-Feb-2020, at 9:50 PM, Peter Wainaina <petwah17@gmail.com> wrote:
Kindly help with a tool that can use for implementing master master slave replication
WEB developer and programmer
system analyst-Crm
blogger
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: MULTI MASTER IMPLEMENTATION
2020-02-13 16:19 MULTI MASTER IMPLEMENTATION Peter Wainaina <petwah17@gmail.com>
2020-02-14 05:52 ` Re: MULTI MASTER IMPLEMENTATION soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2020-02-14 05:56 ` Rahul Saha <rahul.blooming@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Rahul Saha @ 2020-02-14 05:56 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: Peter Wainaina <petwah17@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
You can also try Bucardo, I have tested it. It works great. But they have
limitations.
On Fri, Feb 14, 2020 at 11:22 AM soumitra bhandary <
soumitra.bhandary@hotmail.com> wrote:
> You can try with BDR from 2ndQuadrant.
>
> Thanks
> Soumitra
>
> Sent from my iPhone
>
> On 13-Feb-2020, at 9:50 PM, Peter Wainaina <petwah17@gmail.com> wrote:
>
>
> Kindly help with a tool that can use for implementing master master slave
> replication
> *WEB developer and programmer*
>
> *system analyst-Crm*
>
> *blogger*
>
>
--
Thanks & Regards
Rahul Saha
+91 8806351116
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2020-02-14 05:56 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-12-19 18:24 Multi master implementation Prince Pathria <prince.pathria@goevive.com>
2018-12-20 02:00 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-20 02:24 ` Ron <ronljohnsonjr@gmail.com>
2018-12-20 06:51 ` Prince Pathria <prince.pathria@goevive.com>
2018-12-20 18:10 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-12-21 07:13 ` Prince Pathria <prince.pathria@goevive.com>
2018-12-21 08:03 ` Abhinav Mehta <mail@abhinavmehta.com>
2018-12-21 08:42 ` Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
2018-12-21 09:07 ` Simon Riggs <simon@2ndquadrant.com>
2018-12-21 09:12 ` Simon Riggs <simon@2ndquadrant.com>
2020-02-13 16:19 MULTI MASTER IMPLEMENTATION Peter Wainaina <petwah17@gmail.com>
2020-02-14 05:52 ` Re: MULTI MASTER IMPLEMENTATION soumitra bhandary <soumitra.bhandary@hotmail.com>
2020-02-14 05:56 ` Re: MULTI MASTER IMPLEMENTATION Rahul Saha <rahul.blooming@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox