MySQL = MariaDB?

9

For some days I've been teaching the teacher saying:

  

Oracle bought MySQL and just renamed it to MariaDB .

As I am not easy to believe in the things spoken, I went to research on the subject and for the little that I read, I understood that there was no such substitution and that MySQL and MariaDB are not the same.

After all, does% w /% w /% w / w% be the same as% w /%? If not, what is the difference between them?

    
asked by anonymous 21.02.2018 / 13:28

2 answers

10

Your teacher is wrong, MariaDB is compatible on many things with MySql , but it is not renamed, it is another bank anyway, it may even be considered a fork of mysql, since it was created by the same mysql developer.

In other words, they are separate projects, so much so that they both get updates, improvements and fixes independently of each other.

Most simple bank structures created for Mysql will be able to work in MariaDB and vice versa (with one or more adjustments sometimes needed). The MariaDB if I am not mistaken has support for innoDB and myIsam, same engines used in mysql, but also has an engine named XtraDB (note that although it is not default in Mysql it is possible to use it in it too, but this is another story).

MySql now belongs to company Oracle and is still continues to be developed and evolved a lot since it became a product of it, and mariaDB is maintained by MariaDB Corporation Ab and MariaDB Foundation ).

The following link contains the incompatibilities between the two (from MariaDB versions 5.1 and MySQL 5.1):

Incompatibility in versions MariaDB 10.2 and MySQL 5.7 (I believe they are the most recent):

A brief summary of the story of why MariaDB was born

Mysql was created by Michael "Monty" Widenius and David Axmark , has acquired the Mysql AB company,

Michael initially worked for them, but was dissatisfied, I do not know if it was with the result of the project or with the company itself, and so left the Sun .

Sun that was founded in 1982 was then absorbed by Oracle between 2009 and 2010, leaving so it did exist and the products that belonged to it, such as Java and Mysql , belonged to Oracle .

In 2009 even Monty (Michael) created a fork of Mysql giving this system the name of his daughter, Mary, and thus was born the MariaDB.

In mid-2012 Monty (Michael) along with David created the company MariaDB Foundation

Completing

Mysql and MariaDB can be compatible in almost everything, but they have several incompatibilities currently.

  • Mysql is maintained and continues to evolve through the "hands" of Oracle .
  • MariaDB is maintained and continues to evolve through the "hands" of MariaDB Corporation Ab and MariaDB Foundation.

Both are currently being developed by different companies without any connection and I believe we can consider both systems competing.

    
21.02.2018 / 13:39
5

In 2008, the MySql project was incorporated by Sun Microsystems. In 2009, Oracle bought Sun - and incorporated MySql into its product roll. There was no change in the product name. ( Font ).

The founder of the project, dissatisfied with the situation, held a MySql fork thus creating MariaDB. ( Font )

Because MariaDB is a fork of MySql, both (still) share much of the source code. Apparently, the MariaDB project has been struggling to stay highly compatible with the new versions of MySql (to entice MySQL users to migrate from MySQL). This compatibility includes Sql syntax, file system, and communication protocols. That is, in practice you can even use a MySQL client to communicate with MariaDB, observing the appropriate version pairings. ( Font )

    
21.02.2018 / 13:47