Migrating Facebook to MySQL 8.0

Re:Migrating Facebook to MySQL 8.0 by hellcow on Thursday July 22, 2021 @03:27PM (#27923110)

The issues I encountered while using MariaDB in place of MySQL were subtle -- most things worked as expected, which makes the issues so much more unexpected. But at the end of the day, the same migrations produced a different schema.

Arguably MariaDB made the correct decision to fix some MySQL 5.7 bugs that we were unwittingly relying upon, but the different behavior caused issues for us all the same.

Rather than worry about MySQL vs MariaDB and whether the one I need is packaged and available for my distro/OS of choice, I reach for Postgres on new projects.

[ Parent | on HN ]

Re:Migrating Facebook to MySQL 8.0 by PeterZaitsev on Thursday July 22, 2021 @03:36PM (#27923214)

I think this is a key difference - where MariaDB continues to evolve MySQL 5.6/5.7 codebase Oracle chose the "big leap" with MySQL 8 - introducing data dictionary and many other internal architecture changes. This is one of the reasons migration to MySQL 8 can be more painful than releases before it but for good reason

[ Parent | on HN ]