paradedb / paradedb

Postgres for Search and Analytics
https://paradedb.com
GNU Affero General Public License v3.0
6.16k stars 182 forks source link

Implement Postgres Operator for failover, high-availability, backups, etc. #261

Closed philippemnoel closed 1 year ago

philippemnoel commented 1 year ago

What Eventually, we'll want to have high availability. To do this with Postgres, there is a tool called Patroni. Citus has native support for it, so I propose we use this since it seems safe to say we'll be using Citus. If we end up not using Citus, we can use Spilo to do this, which is a combination of Postgres+Patroni directly.

Why Offer high availability!

How Citus has native support for Patroni, so we should just use the Citus+Patroni configuration

philippemnoel commented 1 year ago

https://github.com/zalando/patroni/blob/master/docs/kubernetes.rst

philippemnoel commented 1 year ago

https://github.com/CrunchyData/postgres-operator

philippemnoel commented 1 year ago

After some reading, I believe the CrunchyData one is the right decision to use: https://github.com/CrunchyData/postgres-operator

philippemnoel commented 1 year ago

@MauAraujo once we add this, we should add it to the THANKYOU.md file :)

philippemnoel commented 1 year ago

@MauAraujo has done this in the /infrastructure repo