public inbox for [email protected]
help / color / mirror / Atom feedPostgresql active-active nodes in cluster
7+ messages / 4 participants
[nested] [flat]
* Postgresql active-active nodes in cluster
@ 2024-05-09 06:54 Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Re: Postgresql active-active nodes in cluster Kashif Zeeshan <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Vidyashree H S @ 2024-05-09 06:54 UTC (permalink / raw)
To: [email protected] <[email protected]>
Hi,
I'm using Postgresql 15.4 version on RISCV architecture
I'm trying to implement active-active nodes in cluster, I have gone through various websites, there they have mentioned the theory concept of it. But I want to implement to verify how active-active nodes actually work.
Are there any resources which talks about Postgresql active-active node implementation? If yes, please provide me the resource information or url.
Thanks
Vidyashree H S
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql active-active nodes in cluster
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
@ 2024-05-09 10:58 ` Kashif Zeeshan <[email protected]>
2024-05-09 22:33 ` Re: Postgresql active-active nodes in cluster Greg Sabino Mullane <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Kashif Zeeshan @ 2024-05-09 10:58 UTC (permalink / raw)
To: Vidyashree H S <[email protected]>; +Cc: [email protected] <[email protected]>
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 <[email protected]>
wrote:
> Hi,
>
> I'm using Postgresql 15.4 version on RISCV architecture
> I'm trying to implement active-active nodes in cluster, I have gone
> through various websites, there they have mentioned the theory concept of
> it. But I want to implement to verify how active-active nodes actually work.
>
> Are there any resources which talks about Postgresql active-active node
> implementation? If yes, please provide me the resource information or url.
>
>
> Thanks
> Vidyashree H S
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql active-active nodes in cluster
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Re: Postgresql active-active nodes in cluster Kashif Zeeshan <[email protected]>
@ 2024-05-09 22:33 ` Greg Sabino Mullane <[email protected]>
2024-05-09 23:23 ` Re: Postgresql active-active nodes in cluster Bruce Momjian <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Greg Sabino Mullane @ 2024-05-09 22:33 UTC (permalink / raw)
To: Kashif Zeeshan <[email protected]>; +Cc: Vidyashree H S <[email protected]>; [email protected] <[email protected]>
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql active-active nodes in cluster
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Re: Postgresql active-active nodes in cluster Kashif Zeeshan <[email protected]>
2024-05-09 22:33 ` Re: Postgresql active-active nodes in cluster Greg Sabino Mullane <[email protected]>
@ 2024-05-09 23:23 ` Bruce Momjian <[email protected]>
2024-05-10 05:18 ` Re: Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Bruce Momjian @ 2024-05-09 23:23 UTC (permalink / raw)
To: Greg Sabino Mullane <[email protected]>; +Cc: Kashif Zeeshan <[email protected]>; Vidyashree H S <[email protected]>; [email protected] <[email protected]>
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql active-active nodes in cluster
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Re: Postgresql active-active nodes in cluster Kashif Zeeshan <[email protected]>
2024-05-09 22:33 ` Re: Postgresql active-active nodes in cluster Greg Sabino Mullane <[email protected]>
2024-05-09 23:23 ` Re: Postgresql active-active nodes in cluster Bruce Momjian <[email protected]>
@ 2024-05-10 05:18 ` Vidyashree H S <[email protected]>
2024-05-13 06:38 ` Re: Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Vidyashree H S @ 2024-05-10 05:18 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; Greg Sabino Mullane <[email protected]>; +Cc: Kashif Zeeshan <[email protected]>; [email protected] <[email protected]>
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 <[email protected]>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <[email protected]>
Cc: Kashif Zeeshan <[email protected]>; Vidyashree H S <[email protected]>; [email protected] <[email protected]>
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
[EXT]
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql active-active nodes in cluster
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Re: Postgresql active-active nodes in cluster Kashif Zeeshan <[email protected]>
2024-05-09 22:33 ` Re: Postgresql active-active nodes in cluster Greg Sabino Mullane <[email protected]>
2024-05-09 23:23 ` Re: Postgresql active-active nodes in cluster Bruce Momjian <[email protected]>
2024-05-10 05:18 ` Re: Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
@ 2024-05-13 06:38 ` Vidyashree H S <[email protected]>
2024-05-13 14:13 ` Re: Postgresql active-active nodes in cluster Greg Sabino Mullane <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Vidyashree H S @ 2024-05-13 06:38 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; Greg Sabino Mullane <[email protected]>; +Cc: Kashif Zeeshan <[email protected]>; [email protected] <[email protected]>
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 <[email protected]>
Sent: Friday, May 10, 2024 10:48 AM
To: Bruce Momjian <[email protected]>; Greg Sabino Mullane <[email protected]>
Cc: Kashif Zeeshan <[email protected]>; [email protected] <[email protected]>
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 <[email protected]>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <[email protected]>
Cc: Kashif Zeeshan <[email protected]>; Vidyashree H S <[email protected]>; [email protected] <[email protected]>
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
[EXT]
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql active-active nodes in cluster
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Re: Postgresql active-active nodes in cluster Kashif Zeeshan <[email protected]>
2024-05-09 22:33 ` Re: Postgresql active-active nodes in cluster Greg Sabino Mullane <[email protected]>
2024-05-09 23:23 ` Re: Postgresql active-active nodes in cluster Bruce Momjian <[email protected]>
2024-05-10 05:18 ` Re: Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-13 06:38 ` Re: Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
@ 2024-05-13 14:13 ` Greg Sabino Mullane <[email protected]>
0 siblings, 0 replies; 7+ messages in thread
From: Greg Sabino Mullane @ 2024-05-13 14:13 UTC (permalink / raw)
To: Vidyashree H S <[email protected]>; +Cc: Bruce Momjian <[email protected]>; Kashif Zeeshan <[email protected]>; [email protected] <[email protected]>
On Mon, May 13, 2024 at 2:53 AM Vidyashree H S <
[email protected]> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-05-13 14:13 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-09 06:54 Postgresql active-active nodes in cluster Vidyashree H S <[email protected]>
2024-05-09 10:58 ` Kashif Zeeshan <[email protected]>
2024-05-09 22:33 ` Greg Sabino Mullane <[email protected]>
2024-05-09 23:23 ` Bruce Momjian <[email protected]>
2024-05-10 05:18 ` Vidyashree H S <[email protected]>
2024-05-13 06:38 ` Vidyashree H S <[email protected]>
2024-05-13 14:13 ` Greg Sabino Mullane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox