#12 DoK community: PostgreSQL as a Service on K8s at Zalando // Alexander Kukushkin

// Abstract: PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance, but a production-grade deployment requires many complementary technologies to the database core: high availability and automated failover, backup and recovery, monitoring and alerting, centralized access control and logging, connection pooling, and so on.

Being not initially accustomed for running stateful workloads, Kubernetes with its infrastructure as a code paradigm, CustomResourceDefinition, and Operator pattern turned out to be extremely convenient for deploying and running PostgreSQL at scale.

I will talk about a few open-source project developed and maintained by database team at Zalando which anybody could use to build own PgaaS:
1. https://github.com/zalando/patroni - Tool for PostgreSQL high availability and cluster management. Integrates with K8s API and makes PostgreSQL cloud-native.
2. https://github.com/zalando/spilo - The Docker image that packages Patroni, multiple versions of PostgreSQL, and tools for backup and recovery.
3. https://github.com/zalando/postgres-operator - Implements Kubernetes operator pattern, orchestrates hundreds and thousands deployments of Patroni/Spilo clusters.
Aforementioned projects would never get to the current state without an effort of dozens of external contributors.

// Bio: During his professional career, Alexander touched PostgreSQL from all possible sides: as a Web Developer, as System Administrator, and as a Database Engineer now. Five years ago he started working on Patroni project and achieved quite a big success with it. Nowadays Patroni is used in the heart of PostgreSQL-as-a-Service on Kubernetes at Zalando to run 1000+ PostgreSQL HA clusters. Besides that, Alexander periodically reports bugs and contributes patches to PostgreSQL and some other open-source projects (usually Postgres related).

▬▬▬▬▬▬ Show Notes ▬▬▬▬▬▬
Remember to put your toys away: https://twitter.com/braddwyer/status/1303751133765283840 Getting Write happy and burning out your SSDs https://blog.okmeter.io/real-world-ssd-wearout-a3396a35c663 GitLab Postmortem https://about.gitlab.com/blog/2017/02/10/postmortem-of-database-outage-of-january-31/

▬▬▬▬▬▬ Connect with us 👋 ▬▬▬▬▬▬
Join our slack: https://go.dok.community/slack Follow us on Twitter: @dokcommunity Register for the next meetup: // Register here: https://go.dok.community/register

Connect with Demetrios on LinkedIn: https://www.linkedin.com/in/dpbrinkm/ Connect with Alexander on Twitter: https://twitter.com/cyberdemn Connect with Bart on LinkedIn: https://www.linkedin.com/in/bart-farrell/

▬▬▬▬▬▬ Supporters of the DoKc ▬▬▬▬▬▬
This meetup is sponsored by MayaData, which helped start the DOK.community and remains an active supporter. MayaData sponsors two Cloud Native Computing Foundation (CNCF) projects, OpenEBS (http://www.openEBS.io) - the leading open-source container attached storage solution - and Litmus (https://litmuschaos.io/) - the leading Kubernetes native chaos engineering project, which was recently donated to the CNCF as a Sandbox project. As of August 2020, MayaData is the fifth-largest contributor to CNCF projects. Well-known users of MayaData software include the CNCF itself, Bloomberg, Comcast, Arista, Orange, Intuit, and others. Check out more info at https://mayadata.io/

// Final thoughts This is a Fireside chat all audience can participate and ask questions and you can also join the conversation beforehand in our slack group: https://go.dok.community/slack

You can also check out some of our old meetups on youtube here: https://www.youtube.com/channel/UCUnXJbHQ89R2uSfKsqQwGvQ