PostgreSQL on Kubernetes

Kubernetes is the new way of deploying software, programmatically, on almost any infrastructure (be it cloud or on-prem). But is a complex beast. How to get started? How to dive deeper? What are the specific best-practices and special hints for Postgres DBAs dealing with Kubernetes? Join this half-day tutorial to learn, practically, among other topics:

* How to quickly get started with Kubernetes
* Manage storage
* Manage services and networking
* How to make Postgres cloud-native in Kubernetes

Transcript

1. POSTGRESQL ON KUBERNETES
   POSTGRESQL
   ON
   KUBERNETES
   Álvaro Hernández
   

   View Slide

2. POSTGRESQL ON KUBERNETES
   ` whoami`
   ● Founder & CEO, OnGres
   ● 20+ years PostgreSQL user and DBA
   ● Mostly doing R&D to create new,
   innovative software on Postgres
   ● Frequent speaker at PostgreSQL,
   database conferences
   ● Principal Architect of ToroDB
   ● Founder and President of the NPO
   Fundación PostgreSQL
   ● AWS Data Hero
   Álvaro Hernández
   
   @ahachete
   

   View Slide

3. POSTGRESQL ON KUBERNETES
   WHAT IS KUBERNETES
   (non-classical intro)
   

   View Slide

4. POSTGRESQL ON KUBERNETES
   //WHAT IS KUBERNETES?
   An HTTP Server
   

   View Slide

5. POSTGRESQL ON KUBERNETES
   //WHAT IS KUBERNETES?
   An object HTTP Server
   

   View Slide

6. POSTGRESQL ON KUBERNETES
   //WHAT IS KUBERNETES?
   An object HTTP Server
   That executes actions on containers when
   create/modify/delete operations are run
   on the HTTP-exposed objects
   

   View Slide

7. POSTGRESQL ON KUBERNETES
   //WHAT IS KUBERNETES?
   An object HTTP Server
   Where the URLs of the objects and their
   fields form an API façade that represents
   the actions to be taken on containers
   

   View Slide

8. POSTGRESQL ON KUBERNETES
   //WHAT IS KUBERNETES?
   https://blog.openshift.com
   /kubernetes-deep-dive-api
   -server-part-2/
   

   View Slide

9. POSTGRESQL ON KUBERNETES
   //WHAT IS KUBERNETES?
   

   View Slide

10. POSTGRESQL ON KUBERNETES
    //WHY KUBERNETES?
    ● K8s is “the JVM” of the architecture of distributed
    systems: an abstraction layer & API to deploy and
    automate infrastructure.
    ● K8s provides APIs for nodes and IPs discovery,
    secret management, network proxying and load
    balancing, storage allocation, etc
    ● A PostgreSQL deployment can be fully automated!
    

    View Slide

11. POSTGRESQL ON KUBERNETES
    DEMO - POSTGRESQL on K8S
    (“show the code”)
    

    View Slide

12. POSTGRESQL ON KUBERNETES
    https://gitlab.com/ahachet
    e/k8s-pg-demo/
    

    View Slide

13. CLOUD NATIVE POSTGRESQL ON KUBERNETES
    QUESTIONS?
    Álvaro Hernández
    
    @ahachete / www.ongres.com
    //THANK YOU
    

    View Slide