Why MySQL and Not MariaDB on Ubuntu 20.04 - Virtualmin

Plesk and cPanel choose CentOS because they take their business seriously and don’t waste time with inferior linux distributions. Just look at this forum, who has more issues? What are the distros that have more issues more frequently?

When you’re in the business of selling hosting and services, you go for stability and reliability. you go for distributions that have a proper development and release cycle (CentOS 7: 2014-2022 // Ubuntu, one major release every two years) :man_facepalming:

Even though that statement alone, like it currently is, is a bid flawed. It also depends on the user and how the system itself is used/configured.
But overall, its somewhat correct at some point.

1 Like

This discussion doesn’t make sense at all. If you are going to install SugarCRM you are required to use MySQL. If you need support and they find out, you are using MariaDB, you are not getting any support, as long as you don’t use MySQL.

Just ask within the installation script, whether MySQL or MariaDB should be installed, and every one can get what they need.

But this might be too easy, right? :slight_smile:
Best
j_m

That’s a pretty special case, and as far as I can tell from a quick google search, SugarCRM works on MariaDB…I’ll take your word for it that they won’t support it on MariaDB, but that’s a problem for the SugarCRM folks. They’ve got a lot more money and developer resources than we do, so maybe tell them to support MariaDB instead of expecting us to steer our development based on their (weird) choices? :wink:

We’re four devs. We already have too many variables. We won’t stop supporting MySQL (see our commit history for the huge amount of work that goes into supporting the latest and greatest versions of both MariaDB and MySQL) in Webmin and Virtualmin, but we need the default installation to be flawless, and that is nearly impossible even with only one database being the “default”.

I don’t have strong opinions, but nobody freaked out about the MariaDB switch on CentOS a few years back. But, maybe SugarCRM is one reason we still have people insisting on installing the upstream MySQL packages without reading up on the implications of that change first. And, we can’t make development decisions based on what some other project, that’s not even among our most popular installers (it might be in the top 10, but definitely not the top 5, though we don’t collect that install data anymore), and actually does work with MariaDB…so, it only matters to people who pay for SugarCRM support.

I just looked at SugarCRM pricing. They’re definitely making more money than we are. I’ll tell you what, if you’ll pay us $52/month per user with a ten user minimum, we’ll support both MySQL and MariaDB in the installer! :wink:

5 Likes

@DrCarsonBeckett is that name from Atlantis? haha only noticed now, huge SG fan.
Anyway, yes, a bit flawed for sake of over-simplifying! :slight_smile:

@just_me and @Joe SugarCRM AND SuiteCRM both work without issues with MariaDB afaik haven’t found incompatibilities.

In anyway to make an installer script, would never look at Sugar but SuiteCRM, which is pretty much the same but open-source derived from SugarCRM 6.5-CE. Out of the box is almost useless, it requires much work (or money) to put up to speed anyway. But money spent on development will still come off cheaper than paying Sugar’s licence.

Yes, it is! Lovely too see another fan here. :slight_smile:
I know what you wanted to say with that. But I think, since its a good one, it should be a bit corrected to properly spread the message which you wanted to say.

hehe thanks for your words.
I actually didn’t elaborate much because I’ve already ranted against Ubuntu on another thread that was also related to database issues and I don’t like to pose as hater but if I go around talking trash about it I’ll seem like one or a troll hehe.

But anyway there are several reasons to prefer CentOS over Debian or Ubuntu:

1st - package manager:
apt seems like yum 15 years ago when there was only Red Hat Linux before RHEL. Its a package manager that stopped somewhere in time, but has a bunch of followers saying its the best thing there is. Please come back when apt returns the history of events, and allows to rollback with a single command, for example. A proper package manager is worth millions.

2nd - support:
Well, CentOS isn’t paid and doesn’t really have paid support, right?
Right.
But Enterprise Customers have mixed environments with RHEL and CentOS. These customers pay hundreds and thousands into development, into fixing bugs, and to ensure their infrastructure runs flawlessly. Red Hat has this pressure from paying customers to quickly fix things. And they do.

Also, there is the point on long-term support and long-term service.
CentOS has a major release that lasts many years. This versions undergo some changes, but not major changes that would cause big impact on the systems running that version.
Ubuntus and the likes have fast cycles and major releases too often, and stability aside, I honestly don’t see any point in making major releases with major system changes every two years.

Anyway this is just a superficial approach there was some other topic where I think I elaborated more and better. I’m just dying for my friday to end!

I know, and it is not my decision to work with SugarCRM. It’s a client i provide hosting service for, so no, i am not paying those licenses :.)

Nevertheless its brilliant, what you achieved over the years, i am around quite long and your (and Eric’s) support helps a lot…

Thank you very much.

Best
j_m

PS: I will reinstate cloudmin license in September again ;.)

No “official” database and a default database are two different things.

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.