Why was MARIADB installed on the latest version and not MYSQL??

6 posts / 0 new
Last post
#1 Fri, 09/12/2014 - 08:11
srmobile

Why was MARIADB installed on the latest version and not MYSQL??

Just curious why MARIADB was implemented by default and not MYSQL?

Seems to me that there should at the very least be an option to choose whether or not I want to have another headache. Moving from one server to another has been anything but straight forward.

That being said, if I remove MARIADB and install MYSQL will that cause any problems with Virtualmin?

OR

Do you have some guidelines on how to move a databse from a MYSQL server over to a MARIADB server? Exporting and importing using mysqldump just doesn't work.

Fri, 09/12/2014 - 13:58
lp86

Starting with Red Hat Enterprise Linux 7, they are using MariaDB instead of MySQL. CentOS 7 is essentially RHEL 7, minus the Red Hat branding.

This has nothing to do with Virtualmin.

I haven't had any problems importing databases from MySQL 5.x to MariaDB.

I am not aware of any MySQL packages available for EL7, and even if you can find some, you won't get the stability and quality that an upstream release provides.

MariaDB is a fork of MySQL that started when Oracle acquired Sun Microsystems (and started ruining everything).

It is supposed to be mostly compatible with MySQL, I haven't had any issues with it so far. I have been impressed with the performance improvements to the InnoDB engine.

What error are you getting when you try to import your database?

Fri, 09/12/2014 - 14:40
srmobile

Didn't realize that MariaDB implementation was with RHEL and not Virtualmin - I thought it was a choice of VM because the install script installed it, but since you've pointed that out it makes perfect sense.

I've worked through all the errors - basically incompatibilities in my.cnf; now I'm trying to figure out why a mysqldump of a database that is 700MB becomes 1.5GB when dumped now 4GB when imported. It's working but slowwww so this is something else I'm going to have to spend time figuring out.

Any thoughts?

I appreciate the informative reply,

Thanks,

SR

Wed, 12/10/2014 - 11:02
PaliGap

One little thing I find confusing is that on a clean install of Virtualmin on CentOS 7, MariaDB is "called" MySQL. I am going to be exporting/importing my Databases soon from MySQL (CentOS 6.5) to MariaDB aka "MySQL" (CentOS 7). Fingers crossed!

Wed, 12/10/2014 - 17:35
tpnsolutions
tpnsolutions's picture

Hi,

Just to clarify something here, MariaDB is the successor developed by the same guy who originally built MySQL. It's completely open source like the original MySQL was, and hence why RHEL/CentOS make use of it in their new version.

The good news is, some backward compatibility is built in, including symbolic links with the mysql naming schema so that you don't break things that don't have immediate direct support for it yet.

MariaDB is essentially the continuation of MySQL with a vast amount of new improvements and a few new engines included.

=== FUN FACT ===

MariaDB and MySQL were named after two of Michael "Monty" Widenius daughters. Monty as he's known in the community was the lead developer of MySQL before it was sold to Sun Microsystems, and is the lead developer of MariaDB.

Best Regards,
Peter Knowles
TPN Solutions

Email: pknowles@tpnsolutions.com
Phone: 604-229-0715 (new)
Skype: tpnsupport
Website: http://www.tpnsolutions.com
Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Tue, 02/09/2016 - 08:41
Olivier Artigue

Hi,

But When we use "Install Scripts" to install PhpMyAdmin, you get an error message: phpMyAdmin requires a MySQL database, phpMyAdmin requires PHP version 5.5 or later

It seems that phpMyAdmin doesn't recognize MariaDB like MySQL ! I checked the MariaDB server is started

regards,

Olivier

Topic locked