Select Page

MariaDB vs Oracle MySQL vs Percona MySQL

Srinivasa Krishna | | September 5, 2019

MariaDB, Oracle MySQL, and Percona MySQL give you several options for using MySQL within your organization. They all have their strengths and weaknesses, so the right choice for your use cases may be quite different from another company’s. Let’s take a look at them.

Oracle MySQL

Oracle MySQL has the most longevity out of these three database management systems. It’s commonly seen as the default installation on web hosts and it also acts as the default selection for WordPress.

Oracle offers two versions of MySQL: a free community edition and a commercially licensed version. Depending on the way that you’re using Oracle MySQL, the company may require you to use the commercial edition. Both MariaDB and Percona MySQL are fully open source. MariaDB also offers an Enterprise Subscription Model.

The biggest advantage to using Oracle MySQL is the stable code base and the large community. When you have web applications that depend on an incredibly reliable and predictable system, then Oracle’s offering stands out.

MariaDB

MariaDB and Percona MySQL are forks of MySQL. You can use them as a drop-in replacement. While they do have some similar features and will draw from each other in several ways, there are some major differences when it comes to their overall focuses.

MariaDB pushes the envelope with MySQL. They look towards the future of database management and develop new features based on that view. The query optimizer is one of the biggest draws for MariaDB, as it adds a lot of flexibility for developers that use many types of queries for a project, rather than the same ones over and over. Features such as GTID replication, AD integration and more were first developed and implemented by MariaDB. Redhat and CentOS replaced (Version 7 onwards) MySQL with MariaDB as their default distribution repository

You also have a better selection of storage engines and on-disk database encryption. Another area where this fork shines is through its scalability features, such as multi-source replication. The idea use cases are for large cloud hosting applications that leverage multiple servers, and projects that have varying queries.

Percona MySQL

Percona MySQL takes a more conservative approach to better support extremely demanding application requirements. Your resource-intensive applications will appreciate the performance improvements and optimization tools that Percona MySQL has available.

It features XtraDB, which is an alternative to InnoDB that is more performance-oriented, and plenty of ways to monitor and improve its operation. XtraDB Cluster and XtraBackup offer other tools to work with that engine. If you have compatibility issues with other MySQL forks, Percona MySQL is closer to the base code. Percona also offers a set of Opensource MySQL tools as part of their MySQL toolkit which is very handy for the DBAs to help with their daily administration activities.

Another area that Percona MySQL stands out is bringing enterprise features into their fully open-source MySQL version. If the commercial licenses for Oracle MySQL exceed a project’s budget, Percona may have the features that you’re looking for.

Ultimately, the best choice for your applications depends on the size, scale, and resource demands that you have for the database. Each MySQL flavor offers plenty of benefits, and in some cases, it may come down to the development team’s personal preferences.

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017
Oracle DBA Skills

8 Things Every Beginner Oracle DBA Should Know

A checklist of eight critical skills and areas an entry-level Oracle DBA should be familiar with to succeed on the job.

Patrick Gates | November 30, 2016

Shortcut to Fixing a Corrupted Oracle Inventory

Oracle Central Inventory files are essential to installing and patching software, ensuring it’s operating correctly and is critical to database stability and availability. The process for fixing a corrupted file can be found here.

Chad Cleveland | February 23, 2016

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS