Switch to MariaDB?? When planned?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Switch to MariaDB?? When planned?

Postby windyweather » 06. May 2013 04:37

When is the switch planned to MariaDB?

https://mariadb.org/

Thanks
ww
windyweather
 
Posts: 3
Joined: 06. May 2013 04:30
XAMPP Version: 5.6.3
Operating System: windows

Re: Switch to MariaDB?? When planned?

Postby Altrea » 06. May 2013 05:45

Why should XAMPP switch?
MySQLs market share is by far higher then MariaDBs.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6610
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Why switch?

Postby windyweather » 06. May 2013 16:07

For the same reason that many distros have switched to LibreOffice.
Show solidarity with your Open Source Brethren.

https://kb.askmonty.org/en/about-mariadb/

https://blog.mariadb.org/slackware-and-arch-linux-switch-to-mariadb-as-a-default/

http://www.pontikis.net/blog/is-it-time-to-remove-mysql-in-favor-of-mariadb-in-production-servers

A possible reason to switch to MariaDB could be the Licensing terms. It is known that MySQL AB acquired by Sun Microsystems on early 2008 for $1bn. Sun acquired by Oracle on April 2009. MySQL Enterprise is a commercial product, but MySQL community edition is still available under the GPL license. However, nobody can be certain for the future licensing policy.


There has been no discussion here about the issue?
I figured I was late to the party.

- ww
windyweather
 
Posts: 3
Joined: 06. May 2013 04:30
XAMPP Version: 5.6.3
Operating System: windows

Re: Why switch?

Postby Altrea » 06. May 2013 22:07

And what is the sense of a local development environment that can't fit the online live servers, because the majority of them don't use MariaDB?
XAMPP is no trend setting webserver stack that have to show solidarity. It should help you to delevop your sites local and can use them online later on.
If you want to try MariaDB out or switch yourself, you can surely install MariaDB and use it with the other XAMPP components like Apache and PHP.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6610
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Drop in replacement??

Postby windyweather » 06. May 2013 22:37

In reading further than the headlines I find that MariaDB is a dropin replacement for MySQL.
There are no barriers to adoption.

Of course the developers had to do that.

It's sort of like going green.
No barrier to entry and it helps the planet. [That is the Open Source EcoSystem, of which we are a part.]

Hey... No fight.. Just asking.
You might ask your clientele tho, just as a suggestion.
Many of them might like to "Go Green", for no cost of adoption.

- ww
windyweather
 
Posts: 3
Joined: 06. May 2013 04:30
XAMPP Version: 5.6.3
Operating System: windows

Re: Drop in replacement??

Postby Altrea » 07. May 2013 00:04

windyweather wrote:In reading further than the headlines I find that MariaDB is a dropin replacement for MySQL.
There are no barriers to adoption.

You should read further. There are just small barriers in the one way, converting MySQL Databases to MariaDB Databases.
But that doesn't count for the opposite way.
Simple example: MariaDB comes with new storage engines and features MySQL doesn't support yet.
https://kb.askmonty.org/en/mariadb-vers ... atibility/

windyweather wrote:It's sort of like going green.
No barrier to entry and it helps the planet. [That is the Open Source EcoSystem, of which we are a part.]

I don't think so.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6610
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Switch to MariaDB?? When planned?

Postby Lucas Malor » 29. May 2013 09:27

The fact MariaDB support new features doesn't mean it's not compatible with MySQL. If you want to use that new feature it will be not compatible, but if you simply switch from MySQL + InnoDB to MariaDB + XtraDB there's practically no problems. A detailed list of minimal incompatibilities can be found on the MariaDB documentation site, that is very well structured (It's good also as MySQL reference): https://kb.askmonty.org/en/mariadb-versus-mysql-compatibility/ (no url tags??? :shock: )

My personal opinion is that free MySQL is at risk. If you take a look to the Wikipedia page about Sun acquisition by Oracle ( http://en.wikipedia.org/wiki/Sun_acquisition_by_Oracle ), you can see that Oracle has already closed or converted to commercial many old Sun free projects, as OpenOffice (donated to Apache), OpenSolaris and Grid Engine, and have done some alarming moves with Java, suing Google and unsupporting an Apache project. If there are many improvements in MySQL 5.6, expecially about performance, we must thanks MariaDB devs, since those improvements was firstly introduced in MariaDB 5.5. If MariaDB didn't forked MySQL, probably we have a free MySQL with minimal support and no significant improvements, and all new features included in commercial versions only.

IMHO if we want to continue to have a free, well-supported database we must look at MariaDB. I'm not saying to completely switch from MySQL to MariaDB as suggested by windyweather (even if I'd do it), but I think it will be very useful to suggest users to try MariaDB and offer a walkthrough to how to do it in the download and install page.
Lucas Malor
 
Posts: 7
Joined: 09. May 2013 16:48
XAMPP Version: 5.6.3
Operating System: Lubuntu 13.04 32bit

Re: Switch to MariaDB?? When planned?

Postby joebyrne » 10. June 2013 22:20

Not planned? Really? I figured this was a no-brainer. I've dumped MySQL on my 3 web hosting servers and replaced them with MariaDB without incident. No a single line of code needed to be changed anyplace on 200+ hosts.

I don't trust Oracle any farther than I could throw them so the sooner I was able to get MySQL off my servers, the better. I just 'assumed' XAMMP would have been an early adopter. Its no longer early. You might want to poll your users here. I think you might be very surprised to find out how many people have switched, or would prefer to switch, to MariaDB instead.
joebyrne
 
Posts: 1
Joined: 10. June 2013 22:12
XAMPP Version: 5.5.19
Operating System: Windows 2008

Re: Switch to MariaDB?? When planned?

Postby Altrea » 10. June 2013 22:29

joebyrne wrote:You might want to poll your users here.

http://www.apachefriends.org/files/surv ... 12-raw.pdf

Do you want an additional database to be part of XAMPP?
[...]
MariaDB
24,56% positive
57,92% neutral
17,52% negative


Just for comparison:
PostgreSQL: 53,91% positive
Oracle: 35,64%
MongoDB: 33,49%
Interbase/Firebird: 30,41%
MariaDB: 24,56% <-----
CouchDB: 23,72%
DB2: 17,90%
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6610
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Switch to MariaDB?? When planned?

Postby Lucas Malor » 11. June 2013 07:37

That survey means nothing. The majority of people that answered to that survey probably didn't ever know the existence of MariaDB, since it's relatively young and it is supported by a small company. Despite this, MariaDB has an increasing market.

That said, I don't care about popularity, since people are lazy and conservative. If we asked to people if we have to use vaccines, we still have tuberculosis now.
Lucas Malor
 
Posts: 7
Joined: 09. May 2013 16:48
XAMPP Version: 5.6.3
Operating System: Lubuntu 13.04 32bit

Re: Switch to MariaDB?? When planned?

Postby Altrea » 11. June 2013 10:02

probably, but if you take a look into the other answers i would guess that the majority of them are knowing new technologies and architectures.
And if more than 50% of them want to see PostgreSQL in XAMPP, why not change to PostgreSQL instead of MariaDB (which more than 75% don't care or don't want)?

Everybody who want to use a different database than MySQL with the other XAMPP components, feel free to install one of them. But for the majority i would think that MySQL is fine.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6610
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Switch to MariaDB?? When planned?

Postby Lucas Malor » 11. June 2013 22:00

I do not wish for a switch, I wish for a support for a simple way to switch if someone decide to do it. XAMPP is not easy to personalize. On Linux it's much better to install softwares separately, since it's more simple to update them or change them if you want to do. But this is a wider problem.
Lucas Malor
 
Posts: 7
Joined: 09. May 2013 16:48
XAMPP Version: 5.6.3
Operating System: Lubuntu 13.04 32bit

Re: Switch to MariaDB?? When planned?

Postby vdmo » 14. September 2013 06:03

you can switch to http://wpn-xm.org/
vdmo
 
Posts: 1
Joined: 14. September 2013 05:59
XAMPP Version: 1.8.3-2
Operating System: windows 7

Re: Switch to MariaDB?? When planned?

Postby Nobbie » 14. September 2013 15:13

Lucas Malor wrote:XAMPP is not easy to personalize.


Of course not - nobody forces you to use Xampp. Feel free to install anyting you want. Xampp is Xampp is Xampp. And not "i would like to have this and that".

Lucas Malor wrote:On Linux it's much better to install softwares separately, since it's more simple to update them or change them if you want to do. But this is a wider problem.


So what? Use Linux. Feel free to use Linux instead of Windows.
Nobbie
 
Posts: 6653
Joined: 09. March 2008 13:04

Re: Switch to MariaDB?? When planned?

Postby Jos_38 » 17. September 2013 07:35

Migration made easy, Windows

download latest stable MariaDB for Your system
go into "services"
if running as service "mysql"
stop the service "mysql"

start cmd as administrator
cd to your mysql installation subdir mysql\bin in Your xampp dir
run : mysqld --remove mysql

if result is "success" (check with services)

start installation (into MariaDB subdir of Your xampp installation) at the last screen Maria ask for a name of service - if You use my version of xampp (1.8.3) - that would be mysql (small letters) and not as Maria suggest MySQL - I do not know weather or not this is significant to Windows, probably not, but better safe than sorry - change to "mysql" small letters - leave the rest...

and MariaDB starts up as a service

Copy Your data dir from mysql -> MariaDB merging without overwriting

and connect to Your webpage - if You did as I did, without any problem, in all less than 15 minutes...


And to the rather arrogant answers from admin : if Google think MariaDB is worth a change - I would think even Xampp should consider...
http://readwrite.com/2013/09/14/google-waves-goodbye-to-mysql-in-favor-of-mariadb#awesm=~ohFWOBXj2U8PGV


.
Jos_38
 
Posts: 1
Joined: 17. September 2013 07:15
XAMPP Version: 5.5.19
Operating System: Windows7

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 38 guests