Re: High Availability PostgresDB on K8s

Поиск
Список
Период
Сортировка
От Jan Kohnert
Тема Re: High Availability PostgresDB on K8s
Дата
Msg-id 4775030.GXAFRqVoOG@kohni-mobil
обсуждение исходный текст
Ответ на High Availability PostgresDB on K8s  (Marco Schmucki <marco.schmucki@revendex.com>)
Список 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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: recovery_command has precedence over phisical slots?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Monitoring multixact members growth