Re: Postgresql active-active nodes in cluster

Поиск
Список
Период
Сортировка
От Vidyashree H S
Тема Re: Postgresql active-active nodes in cluster
Дата
Msg-id MAZPR01MB6815114742553C2273A15F82FCE22@MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Postgresql active-active nodes in cluster  (Vidyashree H S <Shreevidya.hs@exaleapsemi.com>)
Ответы Re: Postgresql active-active nodes in cluster
Список pgsql-general
Дерево обсуждения
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]

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Feature Request: Option for TLS no SSLRequest with psql
Следующее
От: Dimitrios Apostolou
Дата:
Сообщение: Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions