PostgreSQL 基于PG内置流复制的,靠谱的PostgreSQL高可用方案(Patroni) - 珍藏级
背景
可能是目前除“基于共享存储的数据库高可用方案”以外,基于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/