Postgresql active-active nodes in cluster

Hi

You can use BDR, you can have a look on the following link.

https://wiki.postgresql.org/wiki/Multimaster

Thanks
Kashif Zeeshan
Bitnine Global

On Thu, May 9, 2024 at 3:28 PM Vidyashree H S <Shreevidya.hs@exaleapsemi.com>
wrote:

https://wiki.postgresql.org/wiki/Multimaster

That is a pretty old page. There are other solutions, such as pgedge, but
the three most important questions when it comes to active-active
replication are:

* Do you really, really need it? (hint: the answer is no)
* What problem are you trying to solve?
* Are you really willing to suffer the tradeoffs?

Cheers,
Greg

P.S. Please upgrade to v15.7

On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote:

https://wiki.postgresql.org/wiki/Multimaster

That is a pretty old page. There are other solutions, such as pgedge, but the
three most important questions when it comes to active-active replication are:

* Do you really, really need it? (hint: the answer is no)
* What problem are you trying to solve?
* Are you really willing to suffer the tradeoffs?

Agreed, see this:

https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

Thanks all for your inputs.

*
Currently I'm working on active-passive(Primary and standby scenario).
*
I'm preparing one study report on active-active node implementation which talks about active-active nodes background, theoretical explanation, implementation part which includes some trails on this. For that, I'm checking for the resources.

Thanks
Vidyashree H S
________________________________
From: Bruce Momjian <bruce@momjian.us>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Kashif Zeeshan <kashi.zeeshan@gmail.com>; Vidyashree H S <Shreevidya.hs@exaleapsemi.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql active-active nodes in cluster

On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote:

https://wiki.postgresql.org/wiki/Multimaster

That is a pretty old page. There are other solutions, such as pgedge, but the
three most important questions when it comes to active-active replication are:

* Do you really, really need it? (hint: the answer is no)
* What problem are you trying to solve?
* Are you really willing to suffer the tradeoffs?

Agreed, see this:

https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.
[EXT]

Hi,

*
Is that multi master replication is not recommended to do ?
*
If we can do, can I get any resource for implementing that on PostgreSQL which is open-source?

Thanks,
Vidyshree H S

________________________________
From: Vidyashree H S <Shreevidya.hs@exaleapsemi.com>
Sent: Friday, May 10, 2024 10:48 AM
To: Bruce Momjian <bruce@momjian.us>; Greg Sabino Mullane <htamfids@gmail.com>
Cc: Kashif Zeeshan <kashi.zeeshan@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql active-active nodes in cluster

Thanks all for your inputs.

*
Currently I'm working on active-passive(Primary and standby scenario).
*
I'm preparing one study report on active-active node implementation which talks about active-active nodes background, theoretical explanation, implementation part which includes some trails on this. For that, I'm checking for the resources.

Thanks
Vidyashree H S
________________________________
From: Bruce Momjian <bruce@momjian.us>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Kashif Zeeshan <kashi.zeeshan@gmail.com>; Vidyashree H S <Shreevidya.hs@exaleapsemi.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql active-active nodes in cluster

On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote:

https://wiki.postgresql.org/wiki/Multimaster

That is a pretty old page. There are other solutions, such as pgedge, but the
three most important questions when it comes to active-active replication are:

* Do you really, really need it? (hint: the answer is no)
* What problem are you trying to solve?
* Are you really willing to suffer the tradeoffs?

Agreed, see this:

https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.
[EXT]

On Mon, May 13, 2024 at 2:53 AM Vidyashree H S <
Shreevidya.hs@exaleapsemi.com> wrote:

- Is that multi master replication is not recommended to do ?

No, it is not recommended, as it has a very, very narrow use case, and
comes with a lot of drawbacks. Sure, you COULD configure your car to also
be able to ride across the river like a boat, but it's far easier to use a
bridge, or a barge. And now your car is harder to care for, and has a lot
more ways in which it could break.

- If we can do, can I get any resource for implementing that on
PostgreSQL which is open-source?

You still have not told us your use case. That can help us to guide you to

the right solution. But for totally open source solutions there are not
many out there. Here are some:

* https://github.com/JumpMind/symmetric-ds
* https://github.com/bucardo/bucardo

You can also in theory use logical replication if at least version 16:

* https://www.crunchydata.com/blog/active-active-postgres-16

Cheers,
Greg