User: Password:
Subscribe / Log in / New account

Distributions ponder MariaDB switch

Distributions ponder MariaDB switch

Posted Jan 31, 2013 12:48 UTC (Thu) by khim (subscriber, #9252)
In reply to: Distributions ponder MariaDB switch by johannbg
Parent article: Distributions ponder MariaDB switch

One thing that people seem to forget with regards to MariaDB is that switching over to it might break paid application support since MariaDB is not listed in the relevant application supported platform like for example.

No they don't forget about it:

Going through the thread I currently see two reasons to keep packaging mysql after switching to mariadb:

Firstly, some admins may be bound to mysql because of the certification or similar reason, but it probably won't be a technical reason. It'd be nice if admins work with providers in such cases and push them to add mariadb into set of "supported" options. I believe there won't be technical barrier to do so, so everyone could benefit from that.

Second, if mariadb differs more in the future and stops to be "drop-in" replacement, then we'll need an alternative for applications, where mariadb won't be suitable enough. Nevertheless, this is not a current issue right now.

In both cases we'll probably need some time to evaluate how the things with mariadb goes, so I'd suggest to wait, observe, test and after some time to re-open the discussion and make a decision about dropping mysql.

This is sensible approach: if MariaDB is a default in most Linux distributions and it's not a disaster (WRT security, stability, etc) then "paid support" will eventually will be offered for it and if MySQL is available as [non-default] alternative then everything will be fine till it happens.

(Log in to post comments)

Distributions ponder MariaDB switch

Posted Jan 31, 2013 13:01 UTC (Thu) by johannbg (guest, #65743) [Link]

We offer a plethora of databases in the distribution so mariadb is going to be a default for what again?

If there is going to be any default database then it has to be an db the keeps messes like this sunacle one out of users face and equally if not better supported out there namely postgresql.

Distributions ponder MariaDB switch

Posted Jan 31, 2013 14:33 UTC (Thu) by philipstorry (subscriber, #45926) [Link]

I imagine by "default DB" what they mean is the default that a package recommends and is configured for.

So in a situation where Drupal, Django and Wordpress can all use either MySQL/MariaDB/PostgreSQL/($AlternativeDB), the package itself will recommend MySQL, and the config files will probably reference MySQL (if such a reference is required).

You're welcome to pick an alternative, but there might be a bit more work involved...

Having tried to set up a couple websites using a CMS - admittedly on Debian/Ubuntu - I have to say that MySQL is pretty much the only default.

I would really, really, really like the default to be PostgreSQL. Both for ideological reasons and for pragmatic reasons. But the simple fact is that the developers of many systems might say that non-MySQL DBs are supported, but they onlyt seem to test with MySQL.
So unless you want to be the tester, you pretty much just pick MySQL and go with it.

My brief experience with alternate DBs for what will probably be the most popular usage case therefore leaves me unconvinced that this is a decision that Fedora should be taking.
This decision should be being made upstream with the projects themselves. Let them take the decision on what's their recommended DB, and let them do the testing for the users. Anything else is just asking for trouble.

Distributions ponder MariaDB switch

Posted Jan 31, 2013 17:16 UTC (Thu) by drag (guest, #31333) [Link]

Very few people have any interest in exploring any sort of database that isn't installed when they do 'yum install <thiswebapp>'

Distributions ponder MariaDB switch

Posted Feb 1, 2013 8:14 UTC (Fri) by zlynx (subscriber, #2285) [Link]

They should care about the database, because they are going to end up needing to use the thing. They might lock themselves out of important tables and need to start it up in admin override mode. They might need to configure it to allow remote access from certain IP ranges. They might need to do a backup recovery, or do backups at all.

No matter how much they like being a Ruby on Rails developer, the system owner is going to need to deal with the database on a basic level of system admin and should pick one he or she likes.

Distributions ponder MariaDB switch

Posted Feb 1, 2013 19:33 UTC (Fri) by k8to (subscriber, #15413) [Link]

I think the point is not "they should not care". It is instead "they do not care".

We all ought to do lots of things that we actually do not.

Distributions ponder MariaDB switch

Posted Feb 2, 2013 22:43 UTC (Sat) by el_presidente (guest, #87621) [Link]

If you have to choose between two databases that seem to be exactly the same, it's probably a good idea to trust the default.

Copyright © 2018, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds