Proposal Seeks To Replace MySQL With MariaDB By Default For Ubuntu 25.04

[d3coder]

So you agree then, it's open-source in name only. It's "we have this pesky GPL license we need to adhere to, so here you go", not a development done out in the open. There's no reviews in public, there's no testing and CI in public, there's no way (as far as I know) for this to be vetted by the community via pre-releases, which leads "trust me bro" type releases. It's only a couple a months since that failed miserably

> So you agree then
I don't agree with you. They don't owe you anything in public like CI/CD or show their internal reviews.
> we have this pesky GPL license we need to adhere to, so here you go
They own the code, they can withdraw GPL variant any time they want.

This is the bug report that lead to the withdraw of MySQL 8.0.38. Do you notice how open and transparent they are about it? Seriously, have some higher standards for open-source developments

All security issues are private in all projects.

You are clearly biased. I will not continue any discussion with you.

[CommunityMember]

but I think the bigger issue was that postgresql has most of the mindshare for developers looking for an opensource database.

Mindshare is complex. I think postgreqal is considered more ready for certain large scale enterprise capabilities/requirements, but mysql is considered to be "good enough" for many, and is very easy to setup and manage by those that don't have a long history of playing DBA (with greater power comes the responsibility to know more).

[CommunityMember]

maria/mysql aren't drop in compatible.

They have subtly diverged for quite some time, and the divergence has been increasing. For *many* use cases it does not matter. But many upstream projects simply do not want to spend their time testing/validating with more than one db. That is a perfectly valid choice (until/unless you are paying them to do that work).

[anarki2]

Good. Now replace MariaDB with PostgreSQL

[bradh352]

Given the fact that you have to do a mysqldump from MySQL v8 and then load into MariaDB I would think would make it a show stopper, if you have a few hundred GBs of data (which is not uncommon), it can take hours of complete downtime to do this. If they had never gone to MySQL 8 in the first place, no problem since you can use the same database files from MySQL 5.7 in MariaDB.

Making it the default for new installs would make sense, but existing installs would need to be bound to mysql forevermore until an administrator specifically chooses to do the migration manually.

[JGC_]

Given the fact that you have to do a mysqldump from MySQL v8 and then load into MariaDB I would think would make it a show stopper, if you have a few hundred GBs of data (which is not uncommon), it can take hours of complete downtime to do this. If they had never gone to MySQL 8 in the first place, no problem since you can use the same database files from MySQL 5.7 in MariaDB.

Making it the default for new installs would make sense, but existing installs would need to be bound to mysql forevermore until an administrator specifically chooses to do the migration manually.

Going back from MariaDB to MySQL requires dumping too, as MariaDB changed the on-disk format.

I personally use Percona everywhere. Drop-in compatible with MySQL without the need to dump and restore to perform migrations.

[Espionage724]

https://github.com/TrinityCore/TrinityCore/pull/29960

That's the only project for me where MySQL vs MariaDB matters. In Fedora 40 KDE's case, something had a hard-dependency on MariaDB and I couldn't install MySQL, but can't remember if I had a specific reason for trying to use MySQL (pretty sure I was just entertaining that ticket with trying it but found I couldn't without probably some added tricks)

On FreeBSD 14.1, I ran into MariaDB causing that project to fail (ticket) because MariaDB had fmt as a dependency which caused it to get used instead of that project's fmt. MySQL on FreeBSD didn't have the fmt dep, it installed, and that project compiled fine!

And apparently MariaDB is owned by Bidco now, whatever that might entail

My general feel is that MariaDB is a FOSS alternative to MySQL. With MySQL being free (likely for most people that use it non-commercially ), it makes MariaDB's preference more of a morals-standard (FOSS vs, I guess not FOSS ). If I'm looking for cross-platform compatibility (which I unexpectedly needed with Win/Linux/FreeBSD), MySQL is the safest choice as long as it's available.

Basically, I hope Ubuntu allows for installing MySQL if the user chooses to, without cryptic tricks (like env/ln redirects) as I'd still probably use it if I use Ubuntu. MariaDB inconvenienced me once and failed once; MySQL has been flawless everywhere aside from Fedora not packaging it early-on (20s/early 30s) and introducing me to MariaDB to start with

Edit: I 180'd on this after another issue and some reconsideration and now fully support MariaDB!

[Espionage724]

I would like to see MySQL and/or MariaDB packaged on the Snap store.

While I'm sure that could be practical in some way, that's (imo) beyond gross to ever think of existing let alone using

[uid313]

While I'm sure that could be practical in some way, that's (imo) beyond gross to ever think of existing let alone using

Well then you could run Ubuntu Core on something like a Raspberry Pi, because Ubuntu Core can only install Snap packages, not .deb packages.

[Espionage724]

Well then you could run Ubuntu Core on something like a Raspberry Pi, because Ubuntu Core can only install Snap packages, not .deb packages.

Yeah I'd just install normal Ubuntu (or Server) and set it up for real But I guess that's a cool way that it could be used!