How Fast is MySQL on HTTP/3?

Рет қаралды 19,173

Күн бұрын

The communication between backend applications and database systems always fascinated me. The protocols keep evolving and we are in constant search for an efficient protocol that best fit the workload of Backend-DB communication.
In this episode of the backend engineering show I go through a blog written by ‪@PlanetScale‬ doing an experimentation of using HTTP/3 and HTTP/2 comparing it with MySQL Binary protocol.
planetscale.com/blog/faster-m...
0:00 Intro
7:45 MySQL Binary vs HTTP
10:20 The Tests
15:00 Connection Cost + Select 1
22:00 Parallel Select
26:00 The cost of H2 and H3
Fundamentals of Backend Engineering Design patterns udemy course (link redirects to udemy with coupon)
backend.husseinnasser.com
Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)
network.husseinnasser.com
Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
database.husseinnasser.com
Follow me on Medium
/ membership
Introduction to NGINX (link redirects to udemy with coupon)
nginx.husseinnasser.com
Python on the Backend (link redirects to udemy with coupon)
python.husseinnasser.com
Become a Member on KZfaq
/ @hnasr
Buy me a coffee if you liked this
www.buymeacoffee.com/hnasr
Arabic Software Engineering Channel
/ @husseinnasser
🔥 Members Only Content
• Members-only videos
🏭 Backend Engineering Videos in Order
backend.husseinnasser.com
💾 Database Engineering Videos
• Database Engineering
🎙️Listen to the Backend Engineering Podcast
husseinnasser.com/podcast
Gears and tools used on the Channel (affiliates)
🖼️ Slides and Thumbnail Design
Canva
partner.canva.com/c/2766475/6...
Stay Awesome,
Hussein

Пікірлер: 25

@hnasr Жыл бұрын

Grab my fundamentals of database engineering course here database.husseinnasser.com

@megalodon4272 Жыл бұрын

Iv been watching this channel for quite a while now and just wanted to ping here they you have been a massive influence in my career as a backend engineer. Thank you so much for such regular and quality content!

@impatient-tech Жыл бұрын

+1!

@luciusartoriusdante Жыл бұрын

I just love how you assume we know what you're talking about - makes me want to learn that stuff right away.

@samuelowad4683 Жыл бұрын

working as a backend developer here and ever since I sumbled on your channel never missed a show and been help helpful to me to undertstand some concept I always shied away from. Thanks so much

@prashlovessamosa Жыл бұрын

Your channel is a heaven to me.

@user-rf2tx4mf8e Жыл бұрын

your videos are very useful and interesti

@mahmoudjoumaa6692 Жыл бұрын

I usually press the like before the video starts, bcz I know what I am going to watch and how awesome it will be, greetings from lebanon 🇱🇧 ❤

@minhajabidin Жыл бұрын

I just love the way he speaks and explains. I would give a like just to watch him speak "beautiful TCP connection".

@minhajabidin Жыл бұрын

Not related but Hussein would look great as wolverine 🔥

@videosforthegoodlife2253 Жыл бұрын

Also, connecting to EC2 is always going to be - at least to some degree, testing AWS infrastructure.

@thecloudterminal Жыл бұрын

Thank you for creating this amazing video Mr Hussein

@efkastner Жыл бұрын

This was great and now I have a whole lot of articles and guides to read! One thing you didn’t go in to and has me wondering is the cost of sequencing packets. WIth HTTP/2, I assume the kernel is ordering the packets before sending them to the process/pipe/fd? And conversely, I’m guessing that has to happen at a higher (OSI) layer for HTTP/3 (since it’s UDP). Is that cost totally blown a way by the cost of reconstructing the streams?

@videosforthegoodlife2253 Жыл бұрын

PlanetScale rocks. Really love them. CockroachDB is doing great work as well.

@lakshshergill9637 Жыл бұрын

Good morning🌞

@goldibollocks Жыл бұрын

Sorry for the likely stupid question but in school (granted, long time ago) we learned that you use TDP when you want to make sure everything gets there and UDP when you don't care if some packets get lost. How does that work with TLS? Wouldn't TLS need every single packet to get there in order to encrypt? Or does TLS provide some sort of statefulness to the underlying UDP?

@MrAtomUniverse Жыл бұрын

What is your view of Vitess vs maybe citus data?

@brymstoner Жыл бұрын

sometimes i feel like shunning all mainline db solutions and just going with json-based flat files.

@leonie9248 Жыл бұрын

Someone have a summary?

@michaelbasher Жыл бұрын

Hey. Why not every user upon the internet be responsible for their own domain which also acts for username etc on any other domain..? Great channel lol