Opening Old Wounds - Why Uber Engineering Switched from Postgres to MySQL

An article from 2016 caused a lot of discussions in the software engineering community. We bring it back and open old wounds and discuss it again. This is when uber moved from Postgres to MySQL.

0:00 Intro
3:00 Problems with Architecture of Postgres
4:00 Postgres on-Disk Format
9:45 Replication
13:19 Write Amplification
16:44 Replication Bandwidth
21:16 Data Corruption
24:00 Replica MVCC
31:30 Postgres Upgrades
33:00 MySQL on-Disk Format
37:00 MySQL Replication
40:00 Connection Handling

Resources
https://eng.uber.com/postgres-to-mysq...
https://news.ycombinator.com/item?id=...

🔥 Members Only Content
   • Members-only videos  

🎙️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast

🏭 Backend Engineering Videos
   • Backend Engineering (Beginner)  

💾 Database Engineering Videos
   • Database Engineering  

🏰 Load Balancing and Proxies Videos
   • Proxies  

🏛️ Software Archtiecture Videos
   • Software Architecture  

📩 Messaging Systems
   • Message Queues & PubSub Systems  

Become a Member
   / @hnasr  

Support me on PayPal
https://bit.ly/33ENps4

Stay Awesome,
Hussein