Home>

mariadb is a branch of mysql source code,Separated after realizing what Oracle would do with the mysql license (mysql was acquired by sun and oracle). In addition to being a "downward replacement" for mysql, mariadb includes some new features that make it better than mysql.

What are the essential differences between these two databases?I see that the mariadb folder bin is still mysql * .exe, except that mysql will be closed source by oracle, and mariadb is open source. Are there any essential differences between the two?

Difference one:

mariadb is not just a replacement for mysql,Its main purpose is to innovate and improve mysql technology.

Difference two:

After leaving the sun, Mr. widenius, the father of mysql, felt that it was very unreliable to rely on sun/oracle to develop mysql.So I decided to open another branch,The name of this branch is called mariadb.

mariadb is compatible with mysql in most aspects,For developers,Hardly felt any difference.Currently mariadb is the fastest growing mysql branch version,The release speed of the new version has exceeded the official mysql version of oracle.

mariadb is a mysql branch version using the aria storage engine,Is a free and open source database server developed by the company founded by the original mysql author michael widenius.

More code for this project is adapted from mysql 6.0. For example, the "pool of threads" function provides solutions to multiple data connection problems.mariadb 5.1.41 rc can be downloaded here,32-bit and 64-bit compiled linux versions, including source code packages.MariaDB is released based on gpl 2.0.

So for most mysql users,There should be no difficulty in moving from the current mainstream mysql to mariadb

Difference three:

The lamp architecture became very popular,This is inseparable from mysql's free and easy to use,But after Oracle acquired Sun, many companies began to worry about the open source prospects of MySQL.And the recent further closed-source initiatives of Oracle are even more disturbing.Many Internet companies have begun to look for alternatives to mysql.

It must be mentioned that Apple's vision, announced the migration to postgresql at the beginning of Oracle's acquisition of sun. But postgresql was originally designed to be different from mysql, and is not a suitable solution for most Internet companies using mysql.In addition to Apple, Google, Facebook, and Twitter also make extensive use of MySQL, and have released their own MySQL branch/patch sets, which are used by many companies.At the same time, mysql branches such as mariadb and percona have gradually entered the public's perspective.

According to wikipedia, mariadb is a community-driven version of the MySQL branch that uses the xtradb storage engine.Developed by michael widenius, the founder of mysql,Open source following gpl v2.0 protocol.Because of the involvement of the mysql founder,mariadb is highly regarded,Drupal, mediawiki, phpmyadmin, wordpress and many other applications have announced support for mariadb.

Migrating from mysql to mariadb wikipedia strives to be open

The lamp architecture became very popular,This is inseparable from mysql's free and easy to use,But after Oracle acquired Sun, many companies began to worry about the open source prospects of MySQL.And the recent further closed-source initiatives of Oracle are even more disturbing.Many Internet companies have begun to look for alternatives to mysql.

It must be mentioned that Apple's vision, announced the migration to postgresql at the beginning of Oracle's acquisition of sun. But postgresql was originally designed to be different from mysql, and is not a suitable solution for most Internet companies using mysql.In addition to Apple, Google, Facebook, and Twitter also make extensive use of MySQL, and have released their own MySQL branch/patch sets, which are used by many companies.At the same time, mysql branches such as mariadb and percona have gradually entered the public's perspective.

According to wikipedia, mariadb is a community-driven version of the MySQL branch that uses the xtradb storage engine.Developed by michael widenius, the founder of mysql,Open source following gpl v2.0 protocol.Because of the involvement of the mysql founder,mariadb is highly regarded,Drupal, mediawiki, phpmyadmin, wordpress and many other applications have announced support for mariadb.

Recently, wikipedia developer asher feldman announced that he has migrated a slave database of the English wiki from mysql5.1 + facebook patch set to mariadb 5.5.28. Through comprehensive testing,MariaDB's query efficiency has been improved by 3%-15%, with an average improvement of 8%, and no exceptions have occurred;In qp units, throughput increased by 2%-10%. Due to lack of data support,Can't draw any conclusions yet,However, from the test results alone, it is still very positive.

Asher also stated that the use of indexes in joins and query optimization,Especially with regard to subqueries,mariadb has many improvements,Unfortunately, it has not been involved yet.A full upgrade may take 1-2 months. Finally he emphasized,Performance is not the main reason why wikipedia adopts mariadb,What they value is the open source nature of mariadb,Only in this way can the community be truly open;In addition, mariadb's good support for mysql export is also very important,The performance improvement is just a side effect of migration.

  • Previous Oracle knowledge finishing notes
  • Next Analysis of Service instance passing data to Activity in real time in Android