They are honestly equally fine for most use cases. I find MariaDB tooling better and have a lower mental overhead dealing with it, but perhaps I'm just more used to it.

We used to hit a wall when reaching 100bn rows on MySQL but that was 15 years ago.