Unsure what alternatives there are to MySQL?
Looking for increases in MySQL performance?
You might not realize that there are some compatible relational database engines. That you can drop in to replace MySQL.
You can even run SQLite without needing a server stack.
SQLite is the most widely deployed database engine in the world
Each engine has it’s own pros and cons to consider before switching from one to another. Most are available as a drop in replacement for MySQL, but yet dropping out and back to MySQL may not be as smooth. Development of new versions means the code bases and features diverge from each other.
MariaDB, Percona Server and Amazon Aurora all offer performance improvements over vanilla MySQL. All for free:
|Relational Database Engine
||Amazon Aurora is a MySQL-compatible relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL with the security, availability, and reliability of a commercial database at one tenth the cost.
||AWS has a free usage tier, otherwise costs depend on server spec x usage.
||One of the most popular database servers. Made by the original developers of MySQL. Guaranteed to stay open source.
||MySQL is the world’s most popular open source database. Whether you are a fast growing web property, technology ISV or large enterprise, MySQL can cost-effectively help you deliver high performance, scalable database applications.
||Community Edition is free.
||Is a free, fully compatible, enhanced, open source drop-in replacement for MySQL that provides superior performance, scalability and instrumentation. Percona Server’s self-tuning algorithms and support for extremely high-performance hardware delivers excellent performance and reliability.
Percona Server subreddit
||SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed database engine in the world.
Thinking of moving from regular MySQL to MariaDB?
MariaDB has a considerable performance gain over MySQL 5.6
Need any more reasons than performance to switch?
- Switching from MySQL to MariaDB is easy, it’s still considered a drop in replacement.
- MariaDB definitely has more of an open source attitude.
- Galera implementation is better.
- Maria comes by default with some distros, like the Red Hat series.
I recently found MariaDB 10 was available on my hosting environment. I saw that MariaDB was compatible with MySQL having not heard of it before then. I tried setting it up and switching was dead easy, just like MySQL and I didn’t have to make any code changes.
If you found the reasons above to consider switching to MariaDB helpful. Please comment and subscribe below so you don’t miss out on my next tips…
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:
If you liked this post, be sure to subscribe below and be the first to get my next post…