About
Alexey started with PostgreSQL at 2003 as a C programmer. He learned how to debug the backend code before learning SQL, but caught up on the latter pretty quickly. He is now using both of those skills and years of experience as a database consultant to help his employer manage a growing number of PostgreSQL database clusters and deal with terabytes of analytical data. Oleksii is based in Berlin and works as a PostgreSQL Engineer at Adjust GbmH. Over the years, he contributed code and documentation to the PostgreSQL project, as well as promoted Postgres by starting PostgreSQL User Group Berlin in 2015.
Alexey Klyukin has presented the following presentations
Understanding and implementing PostgreSQL High Availability with Patroni
at
Postgres Conference
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
Ace it with ACID
at
Postgres Conference
Postgres transactions for fun and profit
presented by Alexey Klyukin
Did you ever wonder why vacuum cannot be run in a transaction? Can you make foreign data storages magically support ACID transactions by wrapping your statements against foreign tables in Postgres with BEGIN ... COMMIT? If you ever asked those questions or want to learn what is possible with Postgres transactions, then this talk is for you! Postgres can durably store your data, but it is also m...
more Fri 22 2019 Development
ALTER DATABASE ADD more SANITY
at
PGConf US 2015 [PgConf.US]
presented by Alexey Klyukin
In this talk I'm going to touch different techniques and tools for managing changes inside PostgreSQL databases, including schema deployments, data changes and usage of stored procedures as a versioned API layer. Based on my experience of no-downtime deployments at Zalando SE, one of the biggest European fashion retailers, I'm going to highlight different approaches to database deployments and ...
more Developer
Managing PostgreSQL clusters with Patroni
at
PostgresConf US 2018
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