Patroni was openly developed from day 0. The repo was created in early July 2015, but before that it was living as the fork of Compose Governor. The Spilo docker container which packages PostgreSQL + Patroni was also…
> if you accessing the DB but can't contact etcd/consul then you should stop accessing the DB because you might start doing unsafe writes. If patroni can't update leader lock in Etcd, it will restart postgres in…
> well I think that is not the same what stolon-proxy actually provides. (actually I use patroni) but if your network gets split and you end up with two masters (one application writes to the old master) there would be…
> I currently prefer Stolon over Patroni because statically typed languages make it easier to have less bugs (Stolon is Go, Patroni is Python) Sounds like a holy-war topic :) But lets be serious. How statically typed…
Correct. Writes need to be directed to master. May be not only writes but some reads as well. Only application can know which statement can be executed on replicas and which must be executed on master.
You also can have a look on slides of my talk about at PGConf.US 2017: https://www.slideshare.net/AlexanderKukushkin1/patroni-ha-po... Talk was also recorded but video is not yet published. And one more thing, you can…
Patroni has REST API providing a health-checks for load-balancers. patroni:8008/replica will respond with http status code 200 only if node is running as replica. In the HAProxy config file you just need to list all…
Compose guys are kind of happy with existing functionality of Governor and didn't really wanted to add something new. That was the main reason of making a fork. If you read a further comments to this news you can get…
on-marked-down shutdown-sessions should do the trick
Doesn't HAProxy provide such functionality? Patroni has REST API which can be used by HAProxy for a health-check. patroni:8008/master will return http status code 200 only if the node running as elected master…
Patroni was openly developed from day 0. The repo was created in early July 2015, but before that it was living as the fork of Compose Governor. The Spilo docker container which packages PostgreSQL + Patroni was also…
> if you accessing the DB but can't contact etcd/consul then you should stop accessing the DB because you might start doing unsafe writes. If patroni can't update leader lock in Etcd, it will restart postgres in…
> well I think that is not the same what stolon-proxy actually provides. (actually I use patroni) but if your network gets split and you end up with two masters (one application writes to the old master) there would be…
> I currently prefer Stolon over Patroni because statically typed languages make it easier to have less bugs (Stolon is Go, Patroni is Python) Sounds like a holy-war topic :) But lets be serious. How statically typed…
Correct. Writes need to be directed to master. May be not only writes but some reads as well. Only application can know which statement can be executed on replicas and which must be executed on master.
You also can have a look on slides of my talk about at PGConf.US 2017: https://www.slideshare.net/AlexanderKukushkin1/patroni-ha-po... Talk was also recorded but video is not yet published. And one more thing, you can…
Patroni has REST API providing a health-checks for load-balancers. patroni:8008/replica will respond with http status code 200 only if node is running as replica. In the HAProxy config file you just need to list all…
Compose guys are kind of happy with existing functionality of Governor and didn't really wanted to add something new. That was the main reason of making a fork. If you read a further comments to this news you can get…
on-marked-down shutdown-sessions should do the trick
Doesn't HAProxy provide such functionality? Patroni has REST API which can be used by HAProxy for a health-check. patroni:8008/master will return http status code 200 only if the node running as elected master…