StackGres Running on EKS

StackGres (https://stackgres.io) is an open source project to run Postgres on Kubernetes. This session will cover the most relevant features of StackGres and live demo how to run Postgres on EKS, Managed Prometheus and Grafana services, and using S3 for backups.

StackGres has innovated in many areas to adapt Postgres to Cloud Native, like distributed log servers, using Envoy to proxy Postgres traffic and terminate SSL; or the ability to dynamically load Postgres extensions into the containers.

Business Problem/Use case :
AWS users that want to run their Postgres database alongside their applications in Kubernetes; and/or need Postgres extensions that may not be available in RDS/Aurora, may benefit from using StackGres on EKS.
(note: this paragraph summarizes the use case, but can as well be used as the last part of the session abstract)

Code/Demo:
StackGres installation on EKS. Creating Postgres clusters. Dynamically loading Postgres extension into the containers. Show the integrated dashboards in Prometheus and Grafana (as provided by AWS Managed Services).

Transcript

1. Running Postgres on EKS
   @ahachete
   StackGres:
   Running Postgres on EKS
   Alvaro Hernandez
   

   View Slide

2. Running Postgres on EKS
   @ahachete
   ` 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
   ● Frequent speaker at Postgres,
   database conferences
   ● Principal Architect of StackGres,
   ToroDB
   ● Founder and President of the
   NPO Fundación PostgreSQL
   ● AWS Data Hero
   

   View Slide

3. Running Postgres on EKS
   @ahachete
   StackGres:
   Running Postgres on EKS
   

   View Slide

4. Running Postgres on EKS
   @ahachete
   What is StackGres
   ● Enterprise Postgres made easy. On Kubernetes.
   ● StackGres is a fully-featured platform for running
   Postgres on Kubernetes.
   ● Deploy in minutes an Enterprise-Grade
   Postgres-as-a-Service in your infrastructure.
   ● 100% Open Source.
   

   View Slide

5. Running Postgres on EKS
   @ahachete
   StackGres in EKS
   

   View Slide

6. Running Postgres on EKS
   @ahachete
   When to use StackGres
   ● You want all your stack in Kubernetes (EKS)
   ○ All your workloads are containerized.
   ○ Extend the benefits of containers to the database.
   ○ You want a K8s-like UX to manage your database.
   ● You need Postgres extensions unavailable in RDS
   ○ Postgres killer feature are extensions.
   ○ RDS/Aurora offers a high number of extensions
   compared with other managed services, but small
   subset compared with open source.
   ○ StackGres provides hundreds of extensions.
   

   View Slide

7. Running Postgres on EKS
   @ahachete
   StackGres innovations
   

   View Slide

8. Running Postgres on EKS
   @ahachete
   Some StackGres innovations
   ● Integration with AMP
   ● Cloud-Nativization of Postgres DBA Operations
   ● Postgres extensions
   

   View Slide

9. Running Postgres on EKS
   @ahachete
   Monitoring integration: AMP and Grafana
   StackGres integrates easily with AMP.
   It includes:
   ● Postgres exporter
   ● PgBouncer exporter (using Postgres exporter + dblink)
   ● Customized Grafana dashboards
   ● Customizing exporter queries
   ● Providing pre-configured AlertManager alerts
   ● Embed Grafana dashboards into the Web Console!
   

   View Slide

10. Running Postgres on EKS
    @ahachete
    Monitoring integration: AMP and Grafana
    

    View Slide

11. Running Postgres on EKS
    @ahachete
    Monitoring integration: Prometheus, Grafana
    

    View Slide

12. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

13. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

14. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

15. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

16. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

17. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

18. Running Postgres on EKS
    @ahachete
    Cloud-Nativization of Postgres DBA Operations
    

    View Slide

19. Running Postgres on EKS
    @ahachete
    Postgres extensions
    ● Postgres Extensions are Postgres’ killer feature.
    ● RDS/Aurora support (with reason!) a limited number of
    extensions.
    ● StackGres extensions are loaded dynamically into the
    container images. They may be added/updated
    anytime.
    ● StackGres supports hundreds of extensions.
    ● It will even support BYOE (bring-your-own extensions).
    

    View Slide

20. Running Postgres on EKS
    @ahachete
    Recap
    ● If you want all your workloads in Kubernetes (EKS), use
    StackGres for your Postgres database.
    ● If you require Postgres extensions unavailable in
    RDS/Aurora, leverage StackGres.
    ● StackGres allows you to export metrics either to
    Prometheus running on EKS or to AMP.
    ● It provides custom Postgres-specialized metrics and
    integration with the Web Console.
    ● StackGres also automates via YAML/Web Console usual
    DBA “Day 2” Operations, like benchmarks, vacuum,
    repack and upgrades.
    

    View Slide

21. Running Postgres on EKS
    @ahachete
    Thank you
    Join our Community in Slack and/or Discord to stay up to date!
    slack.stackgres.io discord.stackgres.io
    

    View Slide