MariaDB vs. MySQL

Peter

Member
[url=https://en.wikipedia.org/wiki/MariaDB]Wikipedia[/url] said:
Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009

It's similar to the situation when LibreOffice was created as a response to Oracle buying Sun Microsystems which gave them control over the OpenOffice project.
 

Genesis

Administrator
Staff member
Further to @Peter 's explanation, I heard that Oracle bought mySQL and it's now free software belonging to Oracle vs open source where every one contributes to the development of the software. The original developers - who were concerned about the sale of mySQL to Oracle in 2009 - created MariaDB as a fork of mySQL as open source database software under the GNU General Public License.

Since MariaDB has been created by the original developers of mySQL, they have succeeded in surpassing mySQL as a database that is more in demand. When MariaDB and mySQL are compared, MariaDB appears to be 24% faster than mySQL. Here is a comparison of MariaDB vs mySQL:
https://www.guru99.com/mariadb-vs-mysql.html#11
 

hgiova

New member
My non-expert opinion based on very recent research has led me to understand it this way.
It all started with MySQL, but was ultimately bought by a competitor product. There were concerns about development and the company "promised" to continue it. However, the original guys behind MySQL eventually quit and started their own; MariaDB.
This last one has improvements and in "general" surpasses the capabilities of the former. However, the "rub" comes in third party support. MySQL has been around longer and thus you will find "easier" (as in more frequently) examples, code, etc than those for MariaDB.
So, from my perspective, if you have control/choice, I would go for MariaDB if you are intending to develop most of the code. If you are going to copy-paste, continue using "ready-made solutions" (LAMP/WAMP, etc), then you will find the journey less frustrating sticking with MySQL.
 

Peter

Member
hgiova said:
This last one has improvements and in "general" surpasses the capabilities of the former. However, the "rub" comes in third party support. MySQL has been around longer and thus you will find "easier" (as in more frequently) examples, code, etc than those for MariaDB.

Most MySQL examples that concerns syntax would still work in MariaDB.
 

Puccini

New member
Can i export a mysql-db with all its tables, views, stored procedureces and import it back to a mariaDB?
Are there any down-sides?
Some syntax, commands, triggers, that cant be handled by MariaDB?
 

Genesis

Administrator
Staff member
I'm used to using cpanel for exporting and importing dbases. With phpmyadmin. For linux I would guess one first has to set up a phpmyadmin with linux and then do pretty much the same. I've created databases in linux and have been able to modify databases again through phpmyadmin.