I've been a MySQL user for a long time now. I'd like to start using all the different variations between the most popular forks. The problem is that I can't find any good comparison between them, and I'll end up just trying all of them. My concerns are in terms of production, because I won't experiment with all these forks in production.
Have you ran any of MySQL forks in production?
What are the advantages? What are the disadvantages?
MySQL is the largest open source database community. MariaDB is a fork from MySQL and is 100% compatible with prior versions of MySQL. However, while the charter for MariaDB remains open source and cross-platform, the future is unclear for MySQL.
As a rule of thumb, if you constantly experience performance or stability issues with MySQL, your site might perform better with Percona.
When it comes to performing queries or replication, MariaDB is faster than MySQL. So if you need a high-performance relational database solution, MariaDB is a good choice. In addition, MariaDB also easily supports a high concurrent number of connections without much performance degradation.
Percona is the premier support provider for open source databases, including MariaDB, the most well-known fork of MySQL.
Basically:
Disclaimer: I worked for MySQL AB and Sun on MySQL, am a core Drizzle developer (since the start) and am currently Director of Server Development at Percona and I count many MariaDB and Oracle MySQL developers as friends (and long time colleagues).
If you don't want to change any application code at all: that's the choice between MariaDB, Percona Server and Oracle MySQL.
If you're wanting a database server that is designed for cloud like environments, is modular and entirely an open source project: go check out Drizzle.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With