Tweet
Tweet

Slide 1

Slide 1 text

Postgres on Kubernetes - Hands-on Lab Postgres on Kubernetes Hands-on Lab Álvaro Hernández @ahachete

Slide 2

Slide 2 text

Postgres on Kubernetes - Hands-on Lab ` whoami ` Álvaro Hernández 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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

Postgres on Kubernetes - Hands-on Lab Containers are NOT dangerous

Slide 5

Slide 5 text

Postgres on Kubernetes - Hands-on Lab Containers are just a process wrapper ● Filesystem namespace ● Network namespace ● Process namespace

Slide 6

Slide 6 text

Postgres on Kubernetes - Hands-on Lab Containers storage ● External!!

Slide 7

Slide 7 text

Postgres on Kubernetes - Hands-on Lab Containers DEMO

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

Postgres on Kubernetes - Hands-on Lab This is the stack you need to deploy Postgres

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

Postgres on Kubernetes - Hands-on Lab Kubernetes (“the hard way”) DEMO

Slide 12

Slide 12 text

Postgres on Kubernetes - Hands-on Lab Kubernetes (“the easy way”) StackGres DEMO

Slide 13

Slide 13 text

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/

Slide 14

Slide 14 text

Postgres on Kubernetes - Hands-on Lab Q & A Álvaro Hernández @ahachete