maxmether

About a year ago I wrote a blog post comparing MariaDB 10 to MySQL 5.6. You can find that post here. Since then MariaDB 10 has changed quite a bit, many new features have gone in, such as Parallell replication, GTIDs etc, but many features from MySQL 5.6 have also been merged in to MariaDB. MariaDB 10 has now also advanced to a near GA status so it is perhaps time to renew the table.

Again, note that this table is very much a high-level feature comparison, there is no particular performance tests related to this, only a feature level comparison. This is also my subjective view, so there might be some features left out or missing or badly covered. Some features are available in both but are implemented differently, the most notable of these is the GTID feature.

Feature and Link MySQL 5.5 MariaDB 5.5 MySQL 5.6 MariaDB 10.0
Multi-source replication        
Flexible Parallell slave replication        
Parallel slave repliction per Schema      
1)
Global Transaction ID (GTID)    
2)
 
Sharding through Spider        
Table Partitioning Improvements        
Engine Independent Statistics        
Sub-query and join optimizations        
Histogram Statistics for non-indexed columns        
Fusion-IO optimizations        
Improved threadpool
3)
 
3)
 
Improved Performance Schema        
Improved InnoDB Storage Engine        
TokuDB Storage Engine        
CONNECT Storage Engine        
Sequence Storage Engine        
Cassandra Storage Engine        
Dynamic Columns        
Virtual Columns        
Handlersocket interface        
memcached interface        
Table discovery        
SHUTDOWN command        
KILL QUERY ID  
Online ALTER TABLE        
ALTER TABLE progress report        
SHOW EXPLAIN for  
Per thread memory statistics        
Roles        
Audit plugin    
3)
 
PAM Plugin
3)
 
3)
 
  1. Can be achieved by setting separate domains for each schema
  2. GTID in MySQL 5.6 is tied to a server UUID and not flexible like the one in MariaDB 10
  3. Only available in the Enterprise version not the Community Edition

About the Author

maxmether's picture
Max Mether

As a co-founder Max now manages the field services and training departments at MariaDB and helps advance the MariaDB and MySQL eco-systems around the world. Max is a frequent speaker at LinuxCon, meetups and other conferences around the globe.

Newsletter Signup

Subscribe to get MariaDB tips, tricks and news updates in your inbox: