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

Опубликовано: 13 Ноябрь 2020
на канале: Hussein Nasser

161,932

2.7k

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