[Maria-discuss] 5.5.x vs 10.x
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
Hi, Tanstaafl! On Dec 28, Tanstaafl wrote:
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?
Yes. And yes. You'd be surprised to know how many people still use 5.5. Heck, some are still using MySQL-5.0 and MySQL-4.x. But 10.0 is, certainly, the preferred and recommended version to use in production.
Is 10.x still considered a drop-in replacement for MySQL?
Depends on what MySQL version you're thinking about. It is a superset of MySQL 5.5, but not a superset of MySQL 5.6. MariaDB 10.0 has some of the MySQL 5.6 features, but not all of them. And, of course, it has features that MySQL 5.6 doesn't. So whether it's a superset of MySQL 5.6 or not for you depends on what features you plan to use. Regards, Sergei
Am 28.12.2014 um 18:17 schrieb Sergei Golubchik:
Is 10.x still considered a drop-in replacement for MySQL?
Depends on what MySQL version you're thinking about.
It is a superset of MySQL 5.5, but not a superset of MySQL 5.6. MariaDB 10.0 has some of the MySQL 5.6 features, but not all of them. And, of course, it has features that MySQL 5.6 doesn't. So whether it's a superset of MySQL 5.6 or not for you depends on what features you plan to use.
i think the question goes more into the direction "is any application written for MySQl 5.0/5.5 expected to work with MariaDB 10.x until now without changes and known regressions" well, since i am running Fedora on server infrastructures and Fedora 21 brings MariaDB 10.x that's also a relevant question for me - i could for sure build packages to ship a MariaDB 5.5 server and have 10.x client libraries for dependencies, well, i would like to avoid that burden :-)
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@libertytrek.org> ha scritto: Oggetto: [Maria-discuss] 5.5.x vs 10.x A: "Maria Discuss" <maria-discuss@lists.launchpad.net> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 28.12.2014 um 18:17 schrieb Federico Razzoli:
10.0 is the newest stable release. So you should use it, unless you have a specific reason to prefer an older version.
in context of whatever software *that* is not a valid reason if you manage 10, 20, 30 or more production servers and things are going down because unexpected regressions nobody will accept "but it is newest release" as excuse and expierience over many years shows repeatly that in doubt you can test over weeks and as soon you go in production and have real workload troubles never imagined may *or* may not start to happen that said froma guy which is normally on-top if it comes to recent software versions, hence the expierience and thanks god most problems don't damage data irreversible
Yeah, well, I don't think that anyone in this world doesn't know/agree :) That said, I recommend 10.0 because my 10.0 production servers didn't hit any bug (as far as I know), and optimize some queries better. Is your experience different from mine? Regards Federico -------------------------------------------- Dom 28/12/14, Reindl Harald <h.reindl@thelounge.net> ha scritto: Oggetto: Re: [Maria-discuss] R: 5.5.x vs 10.x A: maria-discuss@lists.launchpad.net Data: Domenica 28 dicembre 2014, 19:00 Am 28.12.2014 um 18:17 schrieb Federico Razzoli:
10.0 is the newest stable release. So you should use it, unless you have a specific reason to prefer an older version.
in context of whatever software *that* is not a valid reason if you manage 10, 20, 30 or more production servers and things are going down because unexpected regressions nobody will accept "but it is newest release" as excuse and expierience over many years shows repeatly that in doubt you can test over weeks and as soon you go in production and have real workload troubles never imagined may *or* may not start to happen that said froma guy which is normally on-top if it comes to recent software versions, hence the expierience and thanks god most problems don't damage data irreversible -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 28.12.2014 um 19:39 schrieb Federico Razzoli:
Yeah, well, I don't think that anyone in this world doesn't know/agree :)
That said, I recommend 10.0 because my 10.0 production servers didn't hit any bug (as far as I know), and optimize some queries better. Is your experience different from mine?
i am currently on 5.5 and 10.x is planned next year but i have seen a major regression while switch from MySQl 5.5 to MariaDB 5.5 which had the power to damage emails received from dbmail servers with POP3 (IMAP as well, but a POP3 client don#t try to download a message again even if you fix the bug in the meantime) by wrong ordering of message parts well, that makes me careful because 5.5. was a proposed drop-in-replacement
-------------------------------------------- Dom 28/12/14, Reindl Harald <h.reindl@thelounge.net> ha scritto:
Oggetto: Re: [Maria-discuss] R: 5.5.x vs 10.x A: maria-discuss@lists.launchpad.net Data: Domenica 28 dicembre 2014, 19:00
Am 28.12.2014 um 18:17 schrieb Federico Razzoli:
10.0 is the newest stable release. So you should use it, unless you have a specific reason to prefer an older version.
in context of whatever software *that* is not a valid reason
if you manage 10, 20, 30 or more production servers and things are going down because unexpected regressions nobody will accept "but it is newest release" as excuse and expierience over many years shows repeatly that in doubt you can test over weeks and as soon you go in production and have real workload troubles never imagined may *or* may not start to happen
that said froma guy which is normally on-top if it comes to recent software versions, hence the expierience and thanks god most problems don't damage data irreversible
Maybe you should consider testing 10.1 too Em domingo, 28 de dezembro de 2014, Reindl Harald <h.reindl@thelounge.net> escreveu:
Am 28.12.2014 um 19:39 schrieb Federico Razzoli:
Yeah, well, I don't think that anyone in this world doesn't know/agree :)
That said, I recommend 10.0 because my 10.0 production servers didn't hit any bug (as far as I know), and optimize some queries better. Is your experience different from mine?
i am currently on 5.5 and 10.x is planned next year
but i have seen a major regression while switch from MySQl 5.5 to MariaDB 5.5 which had the power to damage emails received from dbmail servers with POP3 (IMAP as well, but a POP3 client don#t try to download a message again even if you fix the bug in the meantime) by wrong ordering of message parts
well, that makes me careful because 5.5. was a proposed drop-in-replacement
--------------------------------------------
Dom 28/12/14, Reindl Harald <h.reindl@thelounge.net> ha scritto:
Oggetto: Re: [Maria-discuss] R: 5.5.x vs 10.x A: maria-discuss@lists.launchpad.net Data: Domenica 28 dicembre 2014, 19:00
Am 28.12.2014 um 18:17 schrieb Federico Razzoli:
10.0 is the newest stable release. So you should use it, unless you have a specific reason to prefer an older version.
in context of whatever software *that* is not a valid reason
if you manage 10, 20, 30 or more production servers and things are going down because unexpected regressions nobody will accept "but it is newest release" as excuse and expierience over many years shows repeatly that in doubt you can test over weeks and as soon you go in production and have real workload troubles never imagined may *or* may not start to happen
that said froma guy which is normally on-top if it comes to recent software versions, hence the expierience and thanks god most problems don't damage data irreversible
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
participants (5)
-
Federico Razzoli -
Reindl Harald -
Roberto Spadim -
Sergei Golubchik -
Tanstaafl