3 ms·

Ever since CockroachDB changed their license, I'm searching for alternatives. PostgreSQL is an obvious choice but is there a good HA solution? What people usual

Ever since CockroachDB changed their license, I'm searching for alternatives. PostgreSQL is an obvious choice but is there a good HA solution? What people usually do for HA with PostgreSQL or do they just not care about it? I tested Patroni, which is the most popular one in my knowledge, but found some HA issues that makes me hesitate to use: https://www.binwang.me/2024-12-02-PostgreSQL-High-Availability-Solutions-Part-1.html https://www.binwang.me/2024-12-02-PostgreSQL-High-Availabili...

mble_ 2y ago
> What people usually do for HA with PostgreSQL or do they just not care about it? Patroni for most cases. At Heroku we have our own control plane to manage HA and fencing which works very reliably. I also like the approach the Cloud Native PG folks have taken with implementing it in the k8s API via the instance manager[1]. Other options like Stolon or repmgr are popular too. Patroni is, despite the Jepsen testing, used well without issues in the majority of circumstances. I wouldn't over think it. [1]: https://cloudnative-pg.io/documentation/1.24/instance_manager/ https://cloudnative-pg.io/documentation/1.24/instance_manage...