Re: Patroni set up
| От | DINESH NAIR |
|---|---|
| Тема | Re: Patroni set up |
| Дата | |
| Msg-id | PN4P287MB438147CBCADB2674257EC3839C40A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM обсуждение исходный текст |
| Ответ на | Re: Patroni set up (kaido vaikla <kaido.vaikla@gmail.com>) |
| Ответы |
Re: Patroni set up
Re: Patroni set up |
| Список | pgsql-admin |
Hi,
In my opinion this 5-node set up is very elaborate and should work , which is distributed different across different seismic zone (across Mumbai (primary DC) and Chennai (DR site)) . Probably below mentioned parameters were factored when designing the system
- network latency between Mumbai and Chennai
- application switch over in case of fail-over and the downtime.
Thanks
Dinesh Nair
From: kaido vaikla <kaido.vaikla@gmail.com>
Sent: Wednesday, July 2, 2025 2:28 PM
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Patroni set up
Sent: Wednesday, July 2, 2025 2:28 PM
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Patroni set up
You don't often get email from kaido.vaikla@gmail.com. Learn why this is important |
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.
Hi,
Based on my opinion and setups.
I would keep etcd cluster on separate nodes and separate data centre.
Mumbai down means whole pg patroni cluster is down, because you dont have an etcd quorum. And other reasons, why create separet etcd cluster.
Take a backup from leader. Leader donw means no replicas. Replica down does not mean leader down.
br
Kaido
Based on my opinion and setups.
I would keep etcd cluster on separate nodes and separate data centre.
Mumbai down means whole pg patroni cluster is down, because you dont have an etcd quorum. And other reasons, why create separet etcd cluster.
Take a backup from leader. Leader donw means no replicas. Replica down does not mean leader down.
br
Kaido
On Wed, 2 Jul 2025 at 10:38, Raj <rajeshkumar.dba09@gmail.com> wrote:
I am looking to DR set up patroni. For 5 node set upMumbai: Node 1: postgres+etcd+patroniMumbai: Node 2: postgres+etcd+patroniChennai: Node 3: postgres+etcd+patroniMumbai: haproxy+keepalivedChennai: haproxy+keepalivedWill this work? And I want to know in which node should I take daily backup. Meaning- in which node I should configure pgbackrest backup
В списке pgsql-admin по дате отправления: