Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MariaDB vs Drizzle vs Percona Server vs MySQL [closed]

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?

like image 857
santiagobasulto Avatar asked Oct 01 '12 10:10

santiagobasulto


People also ask

What is the difference between MariaDB and MySQL?

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.

Is percona faster than MySQL?

As a rule of thumb, if you constantly experience performance or stability issues with MySQL, your site might perform better with Percona.

Is MariaDB better than MySQL?

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.

Is percona a MariaDB?

Percona is the premier support provider for open source databases, including MariaDB, the most well-known fork of MySQL.


1 Answers

Basically:

  • Percona Server - MySQL plus 10% for "real production"
  • MariaDB - a "drop in replacement" fork that aims for compatibility while adding own features
  • Drizzle - a database server that speaks the same network protocol and is largely DML compatible with MySQL, sharing some code ancestry.

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.

like image 186
Stewart Smith Avatar answered Nov 15 '22 19:11

Stewart Smith