MySQL on HTTP/3 | The Backend Engineering Show
The Backend Engineering Show with Hussein Nasser
English - January 05, 2023 03:31 - 37 minutes - 34 MB - ★★★★★ - 5 ratingsTechnology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: How Shopify’s engineering improved writes by 50% with ULID | The Backend Engineering Show
Next Episode: DropBox Removed their SSDs, got 20% faster writes
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.
https://planetscale.com/blog/faster-mysql-with-http3
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