Moving from MySQL to MariaDB?
How Do I?
about 5 months ago
My hosting provider only goes up to MySQL 5.7 - which is already EOL. My only other option is MariaDB 10.6.
I read the System Requirements
MariaDB has long been a drop-in replacement for MySQL and has been used as the database by many EE sites. MariaDB often appears more performant than MySQL; however, there are a few edge cases and queries where the opposite is true.In short, am I safe to migrate to MariaDB 10.6? Is it going to kill my site?
Thanks.
about 5 months ago
You should be good. We run it all the time.
To our knowledge there’s 1 add-on that ends up being slower (due to a very specific join type in it, that doesn’t preform as well in MariaDB).
We’re in the middle of adding an alternative join type to active record in the core, that this specific add-on can use instead, which addresses the issue.
Good question!
-Tom Jaeger