upscope - 13:58 19.01.13 wrote:
On Saturday, January 19, 2013 12:27:31 PM Michal Hrusecky wrote:
Hi everybody,
as some of you might know, we have two MySQL implementations in openSUSE:
* mysql-community-server - MySQL Community Server as provided by Oracle * mariadb - MariaDB from Monty Program
We were offering both for a long time, letting users choose and we are still doing that and I don't see that changing in a near future. But one of these variants has to be default and I sent a request to change this default to MariaDB for openSUSE 12.3.
What does it mean? ==================
Actually, not much. As written on MariaDB web page[1], MariaDB is a binary drop in replacement for MySQL. So from almost all points of view it behaves completely the same. If you will switch, you probably wouldn't even notice. And as we are still providing Oracles MySQL (don't worry, that one will NOT go away, I know some of you really need it), you can decide to stick with it. Switching on server part can be done easily[2], so you can switch there and back as much as you want.
So what will actually change? We do provide only one devel package, so everything will be compiled against MariaDB and embedded library will be using MariaDB. But as protocol is still the same, all programs will be able to talk to both MySQL and MariaDB no matter against what they were compiled. And if you wouldn't choose and wouldn't care, you'll end up with MariaDB. If you are using Oracles MySQL and you will update to 12.3, you'll still be using Oracles MySQL after the update.
So overall, even though there is a change, you shouldn't notice much difference ;-)
Why to switch? ==============
MariaDB is getting a lot of attention[3] and frankly I'm using it since 11.4 on my own server so it is even more tested by me. They periodically merge with Oracles MySQL and add some of their own or Perconas or somebody else goodies[4] on top of that. Originally I was sticking to Oracles MySQL as a default to keep it conservative and stable, but over the years MariaDB proved to be stable and lately they were even faster in fixing some security issues (although they might be the guys who found them, so comparison might not be fair).
I'm not saying that I'm unhappy with Oracles MySQL, I know that there is plenty of people doing great job at Oracle pushing MySQL forward, but I believe that new default will bring some more goodies to our users without any unpleasant side-effects. And as we believe in choice, you can still choose Oracles MySQL over MariaDB. It's up to you. And as I said before, what is default MySQL actually doesn't mean much in openSUSE ;-)
[1] https://kb.askmonty.org/en/mariadb-versus-mysql-compatibility/ [2] http://en.opensuse.org/SDB:Switching_between_MySQL_variants [3] http://www.zdnet.com/wikipedia-moving-from-mysql-to-mariadb-7000008912/ [4] https://kb.askmonty.org/en/mariadb-versus-mysql-features/
just read thru some of your information on the change and I must say I'm not totally against them. My question have more to do with management and of the database under MariaDB. I current use:
libmysqlclient18-5.5.28-1.4.1.x86_64 mysql-community-server-client-5.5.28-1.4.1.x86_64 mysql-community-server-5.5.28-1.4.1.x86_64
My main question is: Will the following applications still work with the change: phpMyAdmin
This one works for sure - tested ;-)
LibreOffice Amarok Digikam KMyMoney
These I don't not use myself, but they should work as expected.
all of these have databases on my localhost version of MySQL.In addition I maintain several Data bases for my Lions Club functions. I have used phpMyAdmin to maintain them. I have also just started test of LibreOffice Base on MySQL.
Is there a good howto for migrating this? I presently have a disk with openSUSE 12.1, another with 12.2 and a third will be 12.3 very soon. This is amultiboot system. 12.2 is my production at this time.
Well, as I wrote before, you can still use mysql-community-server-5.5.x and the only thing that will change is the library you C programs are linked against. Drop-in replacement means that even if you decide to switch to MariaDB, migration should be just as easy as replacing one package with another[2] (actually, there is a little trick and that is the configuration file that you should pay extra attention to). But as with any update (even between same flavor versions), having a backup is recommended and you should test stuff before putting it into production... [2] http://en.opensuse.org/SDB:Switching_between_MySQL_variants -- Michal HRUSECKY SUSE LINUX, s.r.o openSUSE Team Lihovarska 1060/12 PGP 0xFED656F6 19000 Praha 9 mhrusecky[at]suse.cz Czech Republic http://michal.hrusecky.net http://www.suse.cz -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org