Deconstructing Postgres into a Cloud Native Platform - #25 DoK Community
With:
Álvaro Hernández - Founder, OnGres
Presenter: Bart Farrell
https://go.dok.community/slack
Is deploying Postgres in Kubernetes just repackaging it into a container? Can’t Postgres leverage the wide range of Cloud-Native software and integrate well with K8s? Join this journey that will cover and demonstrate, with demos running on StackGres:
How to structure Postgres into an init-less container, plus several sidecar containers for connection pooling, backups, agents, etc.
Defining high level CRDs as the single API to interact with the Postgres operator.
Using K8s RBAC for user authentication of a web UI management interface.
Using Prometheus for monitoring; bundling a node, Postgres and PgBouncer exporters together.
Proxying Postgres traffic through Envoy. Terminate Postgres SSL with an Envoy plugin, that also exports wire protocol metrics to Prometheus.
Using Fluentbit to capture Postgres logs and forward them to Fluentd, which stores them on a centralized Postgres database.
Key take-aways from the talk…
Understand how and why to "de-construct" Postgres into a cloud native application.
Learn how to leverage K8s CRDs to interact with Postgres in Kubernetes, without being a
Postgres expert.
Understand the benefits of proxying Postgres traffic with the Envoy proxy and its Postgres
filter.
How to use FluentBit and Fluentd to capture and collect logs from Postgres pods and
consolidate into a central location.
Learn about the open source StackGres platform, a Postgres Distribution for Kubernetes.
The goal of this talk is to share with the Community all the knowledge and best practices
learned while integrating Postgres with the Kubernetes ecosystem. They stem from the
development of the open source StackGres (https://stackgres.io) Postgres platform. StackGres
followed instead a novel approach: re-analyze all Postgres architecture and find what
components and subsystems could be externalized to K8s ecosystem tools, and construct
sidecars for all the agents and related software, avoiding the use of init systems.
About Data on Kubernetes Community (DoKC)
DoKC is an independent tech community where practitioners go to run data workloads on Kubernetes. It is managed by Constantia.io. We produce a range of resources for end users looking to run DoK including:
DoK Landscape
An interactive landscape of products and services for running data workloads on Kubernetes. (https://dok.community/landscape/)
Videos and Blogs
Hundreds of videos and blogs including how tos, tutorials, use cases, case studies, and more. (https://dok.community/landscape/) (https://dok.community/blog/)
DoK Reports
DoKC works with an independent research firm to annually produce the industry’s only DoK-focused report. (https://dok.community/dok-reports/)
Livestreams and Local Meetups
Weekly livestreams on DoK-related topics including demos, tutorials, visionary talks, panels, and more. (https://www.meetup.com/data-on-kubern...)
DoK Days @ KubeCon
We host hybrid events twice a year for people to get together and learn in-person or online. Details are published on our main website. (https://dok.community/)
Connect With Us:
https://dok.community/
/ @dokcommunity
/ dokcommunity
/ data-on-kubernetes-community
https://github.com/dokc