← Back to team overview

maria-discuss team mailing list archive

R: 5.5.x vs 10.x

 

Hi

10.0 is the newest stable release. So you should use it, unless you have a specific reason to prefer an older version.

The reason why this version is called 10.0 is exactly that it is not a drop-in replacement of a MySQL version. It is, however, compatible in most cases. The main incompatibility between MariaDB 10.0 and MySQL 5.6 is a different GTID implementation - this means that you shouldn't (and probably you can't) have a mixed MySQL/MariaDB replication setup.

Also, MySQL 5.6 has some rarely-used features that are not (yet?) implemented in MariaDB (using memcache via InnoDB, EXPLAIN output in JSON, and maybe something else I'm not aware of).

Keep in mind that Oracle is deprecating/removing some old features (SQL_MODE flags, INSERT DELAYED, --skip-innodb...) that won't probably be removed soon from MariaDB.

Regards
Federico



--------------------------------------------
Dom 28/12/14, Tanstaafl <tanstaafl@xxxxxxxxxxxxxxx> ha scritto:

 Oggetto: [Maria-discuss] 5.5.x vs 10.x
 A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Domenica 28 dicembre 2014, 13:38
 
 So, thinking of building a totally
 new server from scratch on a new
 vmWare host for playing around, and was curious of the
 differences.
 
 Is 5.5 still being maintained just because it is the last
 major stable
 version before 10.x? But then isn't 10.x the way forward?
 
 Is 10.x still considered a drop-in replacement for MySQL?
 
 Thanks,
 
 Charles
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp



Follow ups

References