← Back to team overview

maria-discuss team mailing list archive

R: 5.5.x vs 10.x



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.


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
 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?
 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