What are the advantages of switching to MariaDB from MySQL?
And are there any disadvantages?
If you like me, you may have only just heard about MariaDB. I came across it as a new option when adding a database to RackSpace Cloud hosting environment. After a quick read up about MariaDB and seeing that it was MySQL compatible. I thought why not give it a shot for the website I was working on. The website was a demo site, so there weren’t any concerns about production stability. Rackspace Cloud Hosting provided PHPMyAdmin for accessing the MariaDB. Just like you would have with MySQL. Everything appeared to look the same and work the same setting up the database. Once set-up I immediately saw that MariaDB is definitely faster than MySQL.
So what are the pros and cons for switching to MariaDB from MySQL?
Pros of MariaDB vs MySQL
- MariaDB has better query performance.
- MariaDB has more of an open source attitude.
- Switching to MariaDB is easy.
- Galera implementation is better in MariaDB.
- MariaDB is available as an option with some hosting environments, like RackSpace Cloud.
- MariaDB comes by default with some distros, like the Red Hat series.
I took a big site from MySQL to MariaDB with zero issues.
Cons of MariaDB vs MySQL
- Switching back from MariaDB to MySQL may not be so easy.
- If you are using AWS, Amazon Aurora may be even faster than MariaDB and MySQL.
- Your Operating System may not support MariaDB yet.
- Your hosting environment may not support MariaDB yet.
- Percona may be an even better option than MariaDB.
As with all software there are new versions in development. Each release bringing better performance with it.
So if you are looking to switch from MySQL, make sure the benefits outweigh the risks.
Wikipedia made the switch in 2013 as outlined in this blog post
Rackspace is updating all it’s Cloud Sites from MySQL to MariaDB in 2016.
Useful knowledge base articles from Maria:
- Feature comparison: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/
- Compatibilty with MySQL: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
- Maria DB knowledge base: https://mariadb.com/kb/en/
If you liked this post, be sure to subscribe below and be the first to get my next post…