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
   

   View Slide

2. 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
   

   View Slide

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
   

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

7. Postgres on Kubernetes - Hands-on Lab
   Containers
   DEMO
   

   View Slide

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
   

   View Slide

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

   View Slide

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
    

    View Slide

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

    View Slide

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

    View Slide

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/
    

    View Slide

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

    View Slide