DoK #58 Benchmarking for PostgreSQL workloads in Kubernetes // Gabriele Bartolini & Francesco Canovai
Data on Kubernetes Community18 Kesä 2021

DoK #58 Benchmarking for PostgreSQL workloads in Kubernetes // Gabriele Bartolini & Francesco Canovai

Abstract of the talk…

Databases like PostgreSQL cannot run on Kubernetes. That’s the refrain we hear all the time, as well as the motivation for us to break this barrier, once and for all. Hear the story of our journey so far about bringing PostgreSQL to Kubernetes. Discover why we believe that benchmarking both the storage and the database before production leads to a healthier and longer experience of the DBMS, even in Kubernetes. We’ll be sharing our process, and the results obtained so far, and unveil our plans for the future.

Bio…

A long time open-source programmer and entrepreneur, Gabriele has a degree in Statistics from the University of Florence. After having consistently contributed to the growth of 2ndQuadrant and its members through nurturing a lean and devops culture, he is now leading the Cloud Native initiative at EDB. Gabriele lives in Prato, a small but vibrant city located in the northern part of Tuscany, Italy - famous for having hosted the first European PostgreSQL conferences. His second home is Melbourne, Australia, where he studied at Monash University and worked in the ICT sector. He loves playing the Blues with his Fender Stratocaster, but his major passions are called Elisabeth and Charlotte!

Francesco is a senior software engineer and member of the EDB Cloud Native team. With a background in system and PostgreSQL administration, he works on automation, CI/CD, testing, and compliance for the Cloud Native PostgreSQL operator.

Key take-aways from the talk…

1. A methodology for benchmarking a PostgreSQL database in Kubernetes 2. Open source set of tools for benchmarking a PostgreSQL database in Kubernetes 3. Reasons why benchmarking the storage and the database is important

Jaksot(243)

DoK Specials - Learn by doing in the DoK Community // Bart Farrell

DoK Specials - Learn by doing in the DoK Community // Bart Farrell

https://go.dok.community/slack https://dok.community/ ABSTRACT OF THE TALK As a community we are committed to making learning how to run stateful workloads on Kubernetes as accessible and inclusi...

14 Kesä 202215min

DoK Talks #135 - DoK isn't just Database on Kubernetes // Patrick McFadin

DoK Talks #135 - DoK isn't just Database on Kubernetes // Patrick McFadin

https://go.dok.community/slack https://dok.community ABSTRACT OF THE TALK What about your streaming and analytic workloads? If you are all-in on Kubernetes you can't forget about these important parts...

10 Kesä 202246min

DoK Talks #134 - Introducing CloudNativePG // Gabriele Bartolini & Leonardo Cecchi

DoK Talks #134 - Introducing CloudNativePG // Gabriele Bartolini & Leonardo Cecchi

https://go.dok.community/slack https://dok.community/ ABSTRACT OF THE TALK CloudNativePG is an open source operator for the orchestration of Postgres workloads with a primary and an arbitrary numb...

9 Kesä 20221h 5min

Dok Talks #133 - My First 90 days with Clickhouse // Alkin Tezuysal

Dok Talks #133 - My First 90 days with Clickhouse // Alkin Tezuysal

https://go.dok.community/slack https://dok.community ABSTRACT OF THE TALK This talk will tell the story of an analytics use case database from a non-OLAP and ACID-compliant RDBMS (MySQL) perspective. ...

8 Kesä 202247min

DoK Specials - DEI Panel - We can do better

DoK Specials - DEI Panel - We can do better

https://go.dok.community/slack https://dok.community/ With: Melissa Logan - Director, Data on Kubernetes Lisa-Marie Namphy - Head of Developer Relations, Cockroach Labs Alexandra Rowell - Communi...

3 Kesä 202257min

DoK Talks #132 - Time-series on SQL Server on Kubernetes on ARM64… without SQL Server! // Álvaro Hernández

DoK Talks #132 - Time-series on SQL Server on Kubernetes on ARM64… without SQL Server! // Álvaro Hernández

https://go.dok.community/slack https://dok.community/ ABSTRACT OF THE TALK Oh wow. What a weird title. Full of terms that don’t fit together. Or do they? This talk is for believers, those who belie...

2 Kesä 20221h 5min

Why we created one more Operator for MySQL (DoK Day EU 2022) // Sergey Pronin

Why we created one more Operator for MySQL (DoK Day EU 2022) // Sergey Pronin

https://go.dok.community/slack https://dok.community/ From the DoK Day EU 2022 (https://youtu.be/Xi-h4XNd5tE) There are plenty Kubernetes Operators for MySQL, including our own at Percona. In this se...

28 Touko 20229min

Why run Postgres in Kubernetes (DoK Day EU 2022) // Gabriele Bartolini

Why run Postgres in Kubernetes (DoK Day EU 2022) // Gabriele Bartolini

https://go.dok.community/slack https://dok.community/ From the DoK Day EU 2022 (https://youtu.be/Xi-h4XNd5tE) Postgres should run inside your Kubernetes cluster. Yes, inside, not outside Kubernetes. ...

28 Touko 202210min