Re: High Availability PostgresDB on K8s - Mailing list pgsql-general

From Jan Kohnert
Subject Re: High Availability PostgresDB on K8s
Date
Msg-id 4775030.GXAFRqVoOG@kohni-mobil
Whole thread Raw
In response to High Availability PostgresDB on K8s  (Marco Schmucki <marco.schmucki@revendex.com>)
List pgsql-general
Hi,

Am Freitag, 19. August 2022, 17:09:35 CEST schrieb Marco Schmucki:
> I want to run an HA-Postgres-DB on a Kubernetes cluster for testing purposes
> (Proof of Concept).
> 
> Do you have some links or documentation?

We're usually using Bitnami's Helm charts [1], [2] to deploy PostgreSQL into 
our K8S clusters. They also have -ha variants that might fit your needs, 
though I haven't tested them myself.

Be aware, that you'll get a single-master-multiple-replica, so you still only 
have one Postgres-instance actually *writing* data. As long as most of the 
traffic is reading traffic, that might just work well; if you have a lot of 
writing traffic, you will be limited by the master pod, the node it is running 
on, and of course the underlying PVC.

If you need multi-master, you might have a look at CockroachDB [3] which 
mostly Postgres-compatible.

[1] https://bitnami.com/stack/postgresql/helm
[2] https://github.com/bitnami/charts/tree/master/bitnami/postgresql/
#installing-the-chart
[3] https://www.cockroachlabs.com/product/kubernetes/

-- 
MfG Jan





pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: recovery_command has precedence over phisical slots?
Next
From: Peter Geoghegan
Date:
Subject: Re: Monitoring multixact members growth