Re: Advice on cluster architecture for two related, but distinct, use cases

2024-11-11 Thread sunyuc...@gmail.com
CC On Mon, Nov 11, 2024 at 09:28 Greg Sabino Mullane wrote: > Some of those requirements are vague, but yes, Patroni should probably be > the first approach you look at. If the second datacenter is just for > redundancy, then a simple setup would be: > > DCA (data center A): > Postgres server 1

Re: Advice on cluster architecture for two related, but distinct, use cases

2024-11-11 Thread Greg Sabino Mullane
Some of those requirements are vague, but yes, Patroni should probably be the first approach you look at. If the second datacenter is just for redundancy, then a simple setup would be: DCA (data center A): Postgres server 1 Postgres server 2 DCB: Postgres server 3 (set no_failover: true) You wil

Re: Advice on cluster architecture for two related, but distinct, use cases

2024-11-07 Thread Zahid Rahman
Perhaps a 14 minute investment in this article may prove fruitful. https://medium.com/@martin.hodges/adding-a-postgres-high-availability-database-to-your-kubernetes-cluster-634ea5d6e4a1 On Thu, 7 Nov 2024, 21:06 Matthias Leisi, wrote: > Dear all, > > (This is a follow-up to a question I asked