LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices

View Poll Results: Would you replace MySQL with MariaDB?
Yes 64 75.29%
No 21 24.71%
Voters: 85. You may not vote on this poll

Reply
 
LinkBack Search this Thread
Old 01-30-2013, 07:05 AM   #1
abesirovic1
LQ Newbie
 
Registered: Sep 2005
Location: Germany
Distribution: Slackware
Posts: 26
Blog Entries: 1

Rep: Reputation: 6
Replace MySQL with MariaDB in Slackware


Hi guys,

I would really like the community's opinion on this topic as I've seen it started in some other distros as well. Initially, I didn't give it much thought but seeing the recent news with the Galera cluster and some of the improvements in MariaDB (like the new storage engines including Cassandra) I'm wondering if it might not be a bad idea to switch to MariaDB.
 
Old 01-30-2013, 08:11 AM   #2
jhw
Member
 
Registered: Apr 2010
Posts: 81

Rep: Reputation: 32
I really like Slackware's conservativenes ... if it ain't broke, don't fix it. But in the case of MySQL, and since I really dislike Oracle and it's development patterns, I must say either change to MariaDB or dump MySQL as a whole.
 
Old 01-30-2013, 09:16 AM   #3
bosth
Member
 
Registered: Apr 2011
Posts: 217

Rep: Reputation: 60
I wonder if it really matters. I don't think there's any software in Slackware that requires a db server (is there?) and anyone who will be putting a Slackware-based system into production will evaluate all the competing open-source options, including MariaDB, PostgreSQL, MongoDB and so on, rather than whatever ships by default.
 
Old 01-30-2013, 09:34 AM   #4
GazL
Senior Member
 
Registered: May 2008
Posts: 3,231

Rep: Reputation: 828Reputation: 828Reputation: 828Reputation: 828Reputation: 828Reputation: 828Reputation: 828
Quote:
Originally Posted by bosth View Post
I wonder if it really matters. I don't think there's any software in Slackware that requires a db server (is there?) and anyone who will be putting a Slackware-based system into production will evaluate all the competing open-source options, including MariaDB, PostgreSQL, MongoDB and so on, rather than whatever ships by default.
That sounds like a good argument not to ship any of them by default. I don't have a need for a db so I don't really care, but keeping Oracle at arms length seems like a good idea.
 
Old 01-30-2013, 09:52 AM   #5
a4z
Member
 
Registered: Feb 2009
Posts: 277

Rep: Reputation: 111Reputation: 111
Quote:
Originally Posted by bosth View Post
I wonder if it really matters. I don't think there's any software in Slackware that requires a db server (is there?) and anyone who will be putting a Slackware-based system into production will evaluate all the competing open-source options, including MariaDB, PostgreSQL, MongoDB and so on, rather than whatever ships by default.
KDE semantic desktop components do use DBs, one of them is mysql
 
Old 01-30-2013, 10:02 AM   #6
bosth
Member
 
Registered: Apr 2011
Posts: 217

Rep: Reputation: 60
Quote:
Originally Posted by a4z View Post
KDE semantic desktop components do use DBs, one of them is mysql
Embedded, not a db server.
 
Old 01-30-2013, 10:22 AM   #7
ponce
Senior Member
 
Registered: Aug 2004
Location: Pisa, Italy
Distribution: Slackware
Posts: 2,315

Rep: Reputation: 816Reputation: 816Reputation: 816Reputation: 816Reputation: 816Reputation: 816Reputation: 816
Quote:
Originally Posted by bosth View Post
Embedded, not a db server.
If I remember well, it links to the static libmysql.a.

referring to this list it seems there are many things in slack that use mysql, as a direct (most notably perl and qt) or recursive dependency.

I can agree on a political choice to substitute it with mariadb, but I think the testing needed to be sure that anything won't break (and I'm not even considering the stuff we have on slackbuilds.org depending on it) is huge and probably painful, not sure at all if worth it.

Plus, slackbuilds.org already provides mariadb so it's simply a matter of uninstall mysql and build/install it: doing it now can also help discover bugs/incompatibilities so, if someone feels that this is needed and would like to help, maybe it's better for her/him to switch locally first.

http://slackbuilds.org/repository/14.0/system/mariadb/

Last edited by ponce; 01-30-2013 at 11:10 AM. Reason: typos
 
4 members found this post helpful.
Old 01-31-2013, 03:08 AM   #8
ppr:kut
Member
 
Registered: Aug 2006
Location: Netherlands
Distribution: Slackware
Posts: 353

Rep: Reputation: 89
MariaDB is and will stay for the forseeable future a drop-in replacement for MySQL. That means that there should be no incompatibilities with MySQL whatsoever. Everything that works with MySQL should work without issues with MariaDB. If that's not the case it is a bug in MariaDB and usually very quickly resolved by them, but it doesn't come up very often. So testing compatibility after a switch is really a non-issue.
I'm running MariaDB on my system for two years now and never had a single compatibility issue with any application.

If the reasons for switching to MariaDB are be purely political, it will probably never happen. Just because Oracle has a bad reputation and acted a bit unresposible lately does on its own not warrant a switch away from MySQL. IF there is a switch to MariaDB it would be out of technical reasons, and there are quite some. Most of them are listed here so I don't go over them again: https://kb.askmonty.org/en/mariadb-vs-mysql-features/

An regarding KDE, amarok links with libmysqld (static for MySQL, shared for MariaDB), akonadi uses mysqld, but there are also lots of other applications that use MySQL in Slackware.
 
1 members found this post helpful.
Old 01-31-2013, 03:36 AM   #9
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 462

Rep: Reputation: Disabled
If it's not broke...
 
Old 01-31-2013, 03:53 AM   #10
astrogeek
Senior Member
 
Registered: Oct 2008
Distribution: Slackware: 12.1, 13.0, 13.1, 13.37, 14.0, 64-14, -current
Posts: 1,511

Rep: Reputation: 509Reputation: 509Reputation: 509Reputation: 509Reputation: 509Reputation: 509
I am a heavy MySQL user and run multiple versions on the same box (not concurrently) for maintaining compatability with some slowly changing remote systems. (I still run 3.23.58 regularly).

But I almost never use the MySQL that ships with Slackware simply because I prefer to manage my own builds and usually need to rebuild with other options anyway. So, as a previous post stated, those who actually use it, often have their own requirements and would be largely unaffected - true in my own case.

I have recently been playing with MariaDB but have not replaced any of my production MySQL instances - yet. But my play is directed at eventually doing just that, at least for those that do not require backward compatability, simply to put more distance between Oracle and myself.

But even though MariaDB is a drop-in runtime replacement for MySQL, I wonder if it would not be quite a lot of work for Pat to begin building other things against MariaDB in the long run. For example, MariaDB drops in and runs with the PHP mysql options - but if Slackware shipped with MariaDB then it would also need to shift everything that builds against MySQL to build against MariaDB... I am not actually sure the drop-in aspect would extend that far without unforseen problems.

But I suppose I would be happy either way, and would prefer MariaDB in the long run if Oracle begins to play games with licensing of MySQL.
 
Old 01-31-2013, 04:10 AM   #11
ppr:kut
Member
 
Registered: Aug 2006
Location: Netherlands
Distribution: Slackware
Posts: 353

Rep: Reputation: 89
Quote:
But even though MariaDB is a drop-in runtime replacement for MySQL, I wonder if it would not be quite a lot of work for Pat to begin building other things against MariaDB in the long run. For example, MariaDB drops in and runs with the PHP mysql options - but if Slackware shipped with MariaDB then it would also need to shift everything that builds against MySQL to build against MariaDB... I am not actually sure the drop-in aspect would extend that far without unforseen problems.
I'm not sure what problems you imagine, but I'm not aware of any issues. You wouldn't be able to switch easily from MariaDB back to MySQL once you start using MariaDB specific features, but that's clear from the start.
 
Old 01-31-2013, 04:23 AM   #12
astrogeek
Senior Member
 
Registered: Oct 2008
Distribution: Slackware: 12.1, 13.0, 13.1, 13.37, 14.0, 64-14, -current
Posts: 1,511

Rep: Reputation: 509Reputation: 509Reputation: 509Reputation: 509Reputation: 509Reputation: 509
Quote:
Originally Posted by ppr:kut View Post
I'm not sure what problems you imagine, but I'm not aware of any issues. You wouldn't be able to switch easily from MariaDB back to MySQL once you start using MariaDB specific features, but that's clear from the start.
You are right, I am imagining them because I do not have anything specific in mind.

But it is easy for me to imagine that dropping MariaDB into a system already built with MySQL could be a fundamentally different proposition than building everything else against MariaDB from the ground up.

Maybe not...
 
Old 01-31-2013, 09:21 AM   #13
bosth
Member
 
Registered: Apr 2011
Posts: 217

Rep: Reputation: 60
Quote:
Originally Posted by ponce View Post
referring to this list it seems there are many things in slack that use mysql, as a direct (most notably perl and qt) or recursive dependency.
Interesting! But I guess in most cases - like perl and qt - MySQL is linked in because it is there not because it is actually needed. I'd forgotten about akonadi, but from having built new releases myself on a number of occasions, Amarok's only dependency is a static lib. In any case, neither require a full-blown db server.

But I have no irons in this fire. I use neither MySQL nor MariaDB...
 
Old 01-31-2013, 09:40 AM   #14
ppr:kut
Member
 
Registered: Aug 2006
Location: Netherlands
Distribution: Slackware
Posts: 353

Rep: Reputation: 89
Quote:
You are right, I am imagining them because I do not have anything specific in mind.

But it is easy for me to imagine that dropping MariaDB into a system already built with MySQL could be a fundamentally different proposition than building everything else against MariaDB from the ground up.

Maybe not...
There could of course be an issue, but for the MariaDB developers compatibility with MySQL is very important. I know from experience that they are quick with providing fixes for things like that, so in case we would find an issue it would not be one for long.

From personal experience of building a lot of things against MariaDB instead of MySQL (also rebuilt packages provided by Slackware) I can tell you I haven't encountered such a thing yet. That of course doesn't mean there is none, but it's enough of a reassurance for me to not be worried about it.
 
Old 02-04-2013, 08:58 PM   #15
astrogeek
Senior Member
 
Registered: Oct 2008
Distribution: Slackware: 12.1, 13.0, 13.1, 13.37, 14.0, 64-14, -current
Posts: 1,511

Rep: Reputation: 509Reputation: 509Reputation: 509Reputation: 509Reputation: 509Reputation: 509
Quote:
Originally Posted by ppr:kut View Post
From personal experience of building a lot of things against MariaDB instead of MySQL (also rebuilt packages provided by Slackware) I can tell you I haven't encountered such a thing yet. That of course doesn't mean there is none, but it's enough of a reassurance for me to not be worried about it.
That statement has been very much on my mind the last few days, I am going to need the personal experience that comes from using MariaDB daily, sooner or later. My playtime with it is not going to get me there.

I am a latecomer to 64 bit hardware, but I have a recent 64 bit machine that I just installed Slackware 14 on and am slowly building it out to eventually replace my current personal workhorse. So today I decided to remove MySQL and installed MariaDB 5.5.29 instead. Now I will get the experience that builds the confidence.

I will add that while prepping for the switch I read a lot of articles and "Ask Monty" pages. Doing that enlightened me a bit on just how bad Oracle has been for MySQL, and I have now swung fully to the "MariaDB is the future" camp.

Last edited by astrogeek; 02-04-2013 at 08:59 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Fedora Linux considering switching out MySQL for MariaDB LXer Syndicated Linux News 0 01-23-2013 06:00 AM
LXer: Fedora Looks To Replace MySQL With MariaDB LXer Syndicated Linux News 0 01-22-2013 09:51 AM
LXer: Wikipedia moving from MySQL to MariaDB LXer Syndicated Linux News 0 12-17-2012 10:42 PM
LXer: MariaDB fixes zero day vulnerability in MySQL LXer Syndicated Linux News 0 12-04-2012 02:30 AM
[SOLVED] Slackware: Replace MySQL with MariaDB on fresh installation. astanton Slackware 4 03-03-2012 02:37 AM


All times are GMT -5. The time now is 11:00 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration