search

hasura / hasura-k8s-stack

A feature-complete Hasura stack on Kubernetes
MIT License
138 stars 26 forks source link

Patroni instead of Non HA Postgres #6

Open bakayolo opened 5 years ago

bakayolo commented 5 years ago

Hey guys, The stable Posgtres does not have the automatic failover. We are most likely gonna migrate from Prisma to Hasura. Therefore we need to migrate from Mongodb to Postgres. Any recommendations on a HA Postgres? I am currently evaluating https://github.com/helm/charts/tree/master/incubator/patroni/

coco98 commented 5 years ago

Also, have you thought about using the managed Postgres from the cloud vendor or from compose / aiven? They should have HA options too.

On Tue, May 14, 2019 at 12:12 AM, Appréderisse Benjamin < notifications@github.com> wrote:

Hey guys, The stable Posgtres does not have the automatic failover. We are most likely gonna migrate from Prisma to Hasura. Therefore we need to migrate from Mongodb to Postgres. Any recommendations on a HA Postgres? I am currently evaluating https://github.com/helm/charts/tree/master/incubator/patroni/

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/hasura/hasura-k8s-stack/issues/6?email_source=notifications&email_token=AABAAWCLT4GKTP2W6YC5IPDPVJQ6PA5CNFSM4HMW6GL2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4GTTBL2A, or mute the thread https://github.com/notifications/unsubscribe-auth/AABAAWBSU3HQ4SVTXH54IPDPVJQ6PANCNFSM4HMW6GLQ .

bakayolo commented 5 years ago

@coco98 nop, we aim to be cloud agnostic and deployable on private DC. So cloud services are not an option.

coco98 commented 5 years ago

👌 makes sense. There’s also crunchydata that you can check out: https://github.com/CrunchyData/postgres-operator

On Tue, May 14, 2019 at 12:21 AM, Appréderisse Benjamin < notifications@github.com> wrote:

@coco98 https://github.com/coco98 nop, we aim to be cloud agnostic and deployable on private DC. So cloud services are not an option.

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/hasura/hasura-k8s-stack/issues/6?email_source=notifications&email_token=AABAAWCI4B4OSJWNVY67A5LPVJR6ZA5CNFSM4HMW6GL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVKQF3A#issuecomment-492110572, or mute the thread https://github.com/notifications/unsubscribe-auth/AABAAWCVG2MENCHI4SD6WZLPVJR6ZANCNFSM4HMW6GLQ .

bakayolo commented 5 years ago

Thanks, it might be a bit overkilled but I'll have a look. :) 👍

sachaarbonel commented 5 years ago

Hi @bappr, you should take a look to kubedb postgresql