Apache Friends Support Forum

When is the switch planned to MariaDB?

https://mariadb.org/

Thanks
ww

Why should XAMPP switch?
MySQLs market share is by far higher then MariaDBs.

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

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.

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

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

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.

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

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.

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.

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.

you can switch to http://wpn-xm.org/

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.

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


.