About
During his professional career, Alexander touched PostgreSQL from all possible sides: as Web Developer, as System Administrator, and as a Database Engineer now. About four years ago he started working on Patroni project and achieved quite a big success with it. Periodically he reports bugs and contributes patches to PostgreSQL and some other open source projects (usually postgres related). He is a regular speaker at different postgres events.
Understanding and implementing PostgreSQL High Availability with Patroni
Automating PostgreSQL failovers, the sane way.
presented by Alexander Kukushkin and Alexey Klyukin
You can get slides at https://github.com/patroni-training/2019/raw/master/slides.pdf
Postgres has a rock-solid single master physical replication, but lacks built-in failover. A number of open-source and proprietary tools aim to fill this niche. Patroni stands apart because it doesn’t try to solve all hard problems by itself. ...
more Tue 19 2019 Ops and Administration
Patroni - HA PostgreSQL made easy
presented by Alexander Kukushkin
video
Patroni is a high availability solution for PostgreSQL developed by Zalando to manage hundreds of databases in the cloud, as well as in traditional data centers. It implements automatic failover and works together with Etcd, Zookeeper or Consul to store and retrieve Postgres cluster information in a consistent way and ensure there is only one leader at a time, avoiding split-brains. In more tha...
more Wed 29 2017 Operations
Managing PostgreSQL clusters with Patroni
Step-by-step PosgreSQL High Availability
presented by Alexander Kukushkin and Alexey Klyukin
PostgreSQL has built-in support for creating hot standby nodes and keeping them up-to-date with streaming replication; alas, there is no out-of-box failover. Patroni is a small Python daemon to fill that niche, enabling anyone in a few simple steps to create high availability PostgreSQL clusters based on hot standby and streaming replication. It manages the PostgreSQL database instance and util...
more Operations and Administration
PostgreSQL on AWS: Tips & Tricks (and horror stories)
Things you should be aware of, before you start first production services
presented by Alexander Kukushkin
At a blistering pace and for a variety of reasons, companies are migrating their on-premise database infrastructures to cloud-based solutions - to save costs on hardware, tame the impact of disaster recovery, or even to improve security. Zalando is not an exception: more than two years ago we migrated our first production services to AWS.
In addition to the fully managed database services li...
more Fri 20 2018 Cloud