On Fri, 21 Dec 2018 12:43:57 +0530 Prince Pathria <prince.pathria@xxxxxxxxxxx> 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@xxxxxxxxxxx> 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@xxxxxxxxxxx> > > 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@xxxxxxxxxxx> 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@xxxxxxxxxxx> > >> 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
