Postgres on Kubernetes Hands-on Lab

Get started with running Postgres on Kubernetes in just one session! No prior Kubernetes experience required. Kubernetes is and should be the default platform for running Postgres workloads. Become in 2h a Postgres on Kubernetes Hero!

Transcript

1. Postgres on Kubernetes - Hands-on Lab Postgres on Kubernetes Hands-on Lab Álvaro Hernández @ahachete
2. Postgres on Kubernetes - Hands-on Lab ` whoami ` Álvaro Hernández <aht@ongres.com> aht.es • Founder & CEO, OnGres • 20+ years Postgres user and DBA • Mostly doing R&D to create new, innovative software on Postgres • More than 100 tech talks, most about Postgres • Founder and President of the NPO Fundación PostgreSQL • AWS Data Hero
3. Postgres on Kubernetes - Hands-on Lab Agenda • Brief discussion about containers • Demo! • Brief discussion about Kubernetes • Why to run databases on Kubernetes • Demo! Kubernetes “the hard way” • Demo! Kubernetes the easy way: StackGres
4. Postgres on Kubernetes - Hands-on Lab Containers are NOT dangerous
5. Postgres on Kubernetes - Hands-on Lab Containers are just a process wrapper • Filesystem namespace • Network namespace • Process namespace
6. Postgres on Kubernetes - Hands-on Lab Containers storage • External!!
7. Postgres on Kubernetes - Hands-on Lab Containers DEMO
8. Postgres on Kubernetes - Hands-on Lab Why to run databases on Kubernetes • Should be your default decision! • Automation, automation, automation • Cost • Environment portability https://aht.es/#talks-why_you_should_be_deploying_postgres_primarily_on_kubernetes Kubernetes Will Revolutionize Enterprise Database Management
9. Postgres on Kubernetes - Hands-on Lab This is the stack you need to deploy Postgres
10. Postgres on Kubernetes - Hands-on Lab Total time to deploy whole Postgres Stack Non Kubernetes Kubernetes Postgres Configuration 2-8h (DBA) Connection pooling 4-16h (DevOps + DBA) High Availability 8-24h (DevOps + DBA) Backups 4-16h (DevOps) Monitoring 8-24h (DevOps + DBA) Distributed Logs 4-48h (DevOps) Envoy proxy 8-16h (DevOps) Cluster Management ???? IaC 48-96h (DevOps) Total: 86-248h (DevOps + DBA) 4-16h CKA
11. Postgres on Kubernetes - Hands-on Lab Kubernetes (“the hard way”) DEMO
12. Postgres on Kubernetes - Hands-on Lab Kubernetes (“the easy way”) StackGres DEMO
13. Postgres on Kubernetes - Hands-on Lab Practice at home! Source code for the demos: https://gitlab.com/ahachete/k8s-pg-demo Ask questions on StackGres Slack: https://slack.stackgres.io/
14. Postgres on Kubernetes - Hands-on Lab Q & A Álvaro Hernández @ahachete