MySQL is having a bumpy journey

Показать описание

MySQL has been having bumpy journey since 2018 with the release of the version 8.0. Critical crashes that made to the final product, significant performance regressions, and tons of stability and bugs issues. In this video I explore what happened to MySql, are these issues getting fixed? And what is the current state of MySQL at the end of 2024.

0:00 Intro
2:00 MySQL 8.0 vs 5.7 Performance
11:00 Critical Crash in 8.0.38, 8.4.1 and 9.0.0
15:40 Is 8.4 better than 8.0.36?
16:30 More Features = More Bugs
22:30 Summary and my thoughts

resources

Fundamentals of Operating Systems Course

Backend Troubleshooting Course

Fundamentals of Backend Engineering (link redirects to udemy with coupon)

Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)

Follow me on Medium

Introduction to NGINX (link redirects to udemy with coupon)

Python on the Backend (link redirects to udemy with coupon)

Become a Member on YouTube

Buy me a coffee if you liked this

Arabic Software Engineering Channel

🔥 Members Only Content

🏭 Backend Engineering Videos in Order

💾 Database Engineering Videos

🎙️Listen to the Backend Engineering Podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva

Stay Awesome,
Hussein

Рекомендации по теме

Комментарии

Unironically, the 2018->2014 in the thumbnail made me click the video

voikalternos

I enjoy your podcasts so much. You have no idea how much I have learnt from you. Thank you so much.

brightklutse

I think you have mistakenly mentioned 2014 instead of 2024 in thumbnail :D

AjithkumarSekar

Aren't the MariaDB devs the original MySQL devs?

HyperionStudiosDE

I can't imagine a case where I'd be running a site and assuming just a single DB query per user, an absurd assumption, where I'd go... 3 users per second, yeah that's good enough. Like WTF.

cheako

That's called "The Oracle disease"

johnswanson

AWS RDS uses My SQL 8.0 by default for new databases. Also looking at there announcement it doesn't look like they are keen on supporting 5.7 for a long time.

akshay-kumar-

Please make a video about multi-tenant database design and how to shard it. It would be very informative. I chose MySQL over PostgreSQL because it seems it can be sharded via Vitess, whereas there isn't a good, battle-tested sharding solution for PostgreSQL.

erfanium

I don't see why someone would use MYSQL vs Postgres. I learned the basics of MYSQL first but the knowledge is somewhat transferable to other relational DB's. I am not a DB expert by any means so I may be incorrect I just don't see the reason to make that choice technically.

MrJfergs