Re: [Maria-discuss] Full Replacement of MySQL (innoDB, mysql Workbench, data, etc)
On Mon, 16 Aug 2010 16:25:00 -0000 Enrique Daniel <enridp@yahoo.com.ar> wrote: Enrique> Hi !! Hello! I'm CC'ing this message to the maria-discuss mailing list in case anyone else wants to comment. I recommend you join the list. It's a good resource. Enrique> I'm really new with MariaDB, I have discovered it yesterday at Enrique> really :S And I have not tested it yet, but it looks really Enrique> promising. Thanks! We've done lots of testing to make sure MariaDB works as seamlessly as possible for those moving from MySQL to MariaDB. As with any upgrade, I would definitely recommend making a backup and testing MariaDB on your end to ensure everything works with your applications and use-cases before putting it into production. Enrique> Anyway, there are a few things that are braking me to make the Enrique> change. I hope somebody can help me: Enrique> Enrique> 1) I'm using mySQL Workbench to design my DB, how can we use Enrique> it with MariaDB? (Aria, XtraDB engine, etc.) I haven't used MySQL Workbench much, but using it with MariaDB should be exactly the same as using it with MySQL. Enrique> 2) My tables ar InnoDB, but I was reading about XtraDB and it Enrique> looks much better, how can I make the change from innoDB to Enrique> XtraDB? if I have a SQL file, is enough changing ENGINE=INNODB Enrique> with ENGINE=XTRADB (or something like that). Enrique> I want to preserve my FK, with cascades, and comments. For compatibility purposes, XtraDB identifies itself to the server as InnoDB, so there's no need to change ENGINE= in any SQL files. Any existing InnoDB tables will start using XtraDB automatically after the upgrade. Enrique> 3) What happens if I have my DB with data and working with Enrique> MySQL and InnoDB right now? can I change to MariaDB (and Enrique> XtraDB) preserving all my scheme, tables, data, relations, Enrique> comments, indexes, etc? Yes. All of our testing indicates you can upgrade from MySQL to MariaDB and all of your schemas, tables, data, relations, comments, indexes, and so on will "just work" like they did with MySQL without you having to change anything. Of course, as with any upgrade, I would recommend testing on a non-production server before putting MariaDB into production. One last note. If you do find anything that doesn't work, please file a bug report: https://bugs.launchpad.net/maria/+filebug Thanks. -- Daniel Bartholomew Monty Program - http://askmonty.org
We've done lots of testing to make sure MariaDB works as seamlessly as possible for those moving from MySQL to MariaDB. As with any upgrade, I would definitely recommend making a backup and testing MariaDB on your end to ensure everything works with your applications and use-cases before putting it into production.
My company is developing an application atop MariaDB at the moment and it's been a seamless process moving from MySQL.
For compatibility purposes, XtraDB identifies itself to the server as InnoDB, so there's no need to change ENGINE= in any SQL files. Any existing InnoDB tables will start using XtraDB automatically after the upgrade.
If you try to specify ENGINE=XtraDB you will see a failure because of what Daniel said... Again, we're developing against "XtraDB" and haven't experienced a problem working under the assumption that it is "InnoDB." Yes. All of our testing indicates you can upgrade from MySQL to MariaDB
and all of your schemas, tables, data, relations, comments, indexes, and so on will "just work" like they did with MySQL without you having to change anything. Of course, as with any upgrade, I would recommend testing on a non-production server before putting MariaDB into production.
Not that this is recommended but some of our developers work against MySQL while others work against MariaDB. We're trying to transition to all MariaDB but I figured I'd say it to assuage possibly anguish others might have with such an approach for major version matching (namely 5.1 ish). Hopefully that's helpful to you Enrique. Buenas suerte!
thank you both for your help! I will make the change soon I guess. I like the new 5.2 version, because it has Sphinx and OQGraph between other things... but it's a beta version, do you know when will be released a stable version? Regards! Enrique PS: sorry for sending my question to all the members instead to the list, was my error, I clicked in the wrong link :(
On Tue, 17 Aug 2010 12:27:21 -0300 Enrique <enridp@yahoo.com.ar> wrote: Enrique> thank you both for your help! Enrique> I will make the change soon I guess. Enrique> I like the new 5.2 version, because it has Sphinx and OQGraph Enrique> between other things... but it's a beta version, do you know Enrique> when will be released a stable version? I think the next release of 5.2 will be a release candidate. The last word I heard from the developers was that there were two or three bugs to fix before the release. So it will probably be at least a week or two before the 5.2 RC is released and then a few more weeks after that before 5.2 stable is released. Of course, any newly discovered bugs could delay them or prompt another beta release before the RC or Stable releases. Enrique> Regards! Enrique> Enrique Enrique> PS: sorry for sending my question to all the members instead Enrique> to the list, was my error, I clicked in the wrong link :( No problem! -- Daniel Bartholomew Monty Program - http://askmonty.org
I think the next release of 5.2 will be a release candidate. The last word I heard from the developers was that there were two or three bugs to fix before the release. So it will probably be at least a week or two before the 5.2 RC is released and then a few more weeks after that before 5.2 stable is released. Of course, any newly discovered bugs could delay them or prompt another beta release before the RC or Stable releases.
I have a last question about the new version (5.2). It said that Sphinx storage engine is included in the source, and here is explained how to install SphinxSE: http://kb.askmonty.org/v/sphinxse But, is installed Sphinx (indexer, searchd, etc) with MariaDB? or we must install Sphinx apart, and after that, install the SphinxSE plugin? Regards! Enrique.
Enrique <enridp@yahoo.com.ar> writes:
Sphinx storage engine is included in the source, and here is explained how to install SphinxSE: http://kb.askmonty.org/v/sphinxse But, is installed Sphinx (indexer, searchd, etc) with MariaDB? or we must install Sphinx apart, and after that, install the SphinxSE plugin?
Sphinx indexer, searchd, etc. must be installed separately, they are not part of MariaDB. - Kristian.
participants (4)
-
Adam M. Dutko -
Daniel Bartholomew -
Enrique -
Kristian Nielsen