PostgreSQL 基于PG内置流复制的,靠谱的PostgreSQL高可用方案(Patroni) - 珍藏级

less than 1 minute read

背景

可能是目前除“基于共享存储的数据库高可用方案”以外,基于PG内置流复制的,最靠谱的PostgreSQL高可用方案。

《Patroni: PostgreSQL High Availability made easy 2018》

《Patroni: PostgreSQL High Availability made easy 2016》

看完下面这个PPT,你会发现Zalando和探探类似,把PG用得比较狠的一家公司。

《Why Zalando trusts in PostgreSQL》

https://github.com/zalando-stups/java-sproc-wrapper

参考

https://github.com/Zalando

https://www.opsdash.com/blog/postgres-getting-started-patroni.html

https://media.readthedocs.org/pdf/patroni/latest/patroni.pdf

https://pypi.org/project/patroni/

https://postgresconf.org/system/events/document/000/000/228/Patroni_tutorial_4x3-2.pdf

https://www.linode.com/docs/databases/postgresql/create-a-highly-available-postgresql-cluster-using-patroni-and-haproxy/#what-is-postgresql

https://www.cybertec-postgresql.com/en/services/postgresql-replication/clustering-failover/

Flag Counter

digoal’s 大量PostgreSQL文章入口