MySQL and mariadb

MySQL Database

MySQL database is a relational database management system developed by the Swedish MySQL AB company. MySQL is an associated database management system that keeps data in separate tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility.

(1) MySQL supports a large database. A large database with thousands records can be processed;

(2) MySQL uses the standard SQL data language form;

(3) MySQL can be allowed on multiple systems and supports multiple languages. These programming languages include C, C + +, Python, Java, Perl, PHP, Eiffel, Ruby, and Tcl.

(4) MySQL has a good support for PHP, PHP is currently the most popular web development language;

(5) MySQL support large database, support 50 million records of Data Warehouse,32-bit system table file maximum support 4gb,64 bit system support the largest table file is 8TB;

(6) The use of the GPL (a free software license, licensed to the public to enjoy: the freedom to run, reproduce the software, the freedom to distribute the software, the freedom to obtain the software source code, improve the software and the improvement of its own version of the release to the social dissemination of freedom).

The history of MySQL database

(1) In 1979, a programmer named Monty Widenius worked for a small company in TCX, and a reporting tool was designed in basic to enable it to run on a 4MHz clock and 16KB memory computer. At the time, it was a very low-level, report-only storage engine called Unireg.

(2) In 1990, the TCX Company's customers began asking for SQL support for their APIs. Monty directly with the mSQL code to integrate it into its own storage engine. It is disappointing that the effect is not very satisfying and is determined to rewrite a SQL support for itself.

(3) In 1996, MySQL 1.0 was released, it was only for a small set of people, equivalent to internal release. By October 1996, MySQL 3.11.1 was released (MySQL does not have a 2.x version), and only the binary version under Solaris was initially available. One months later, the Linux version appeared. Over the next two years, MySQL was ported to various platforms in turn.

(4) 1999-2000 years,MySQL AB company was established in Sweden. Monty hired several people to work with Sleepycat to develop the Berkeley DB engine, and since BDB supports transactional processing, MySQL has since started supporting transactions.

(5) 2000,mysql not only publishes its own source code, but also formally enters the open source world with the GPL (GNU general public License) license agreement. In April, MySQL tidied up the old storage engine ISAM and named it MyISAM.

(6) In 2001, the integrated Heikki Tuuri storage engine InnoDB, which not only handles transactions, but also supports row-level locks. The engine was later proven to be the most successful MySQL transaction storage engine. The official combination of MySQL and InnoDB version is 4.0

(7) In December 2003, MySQL version 5.0 was released, providing features such as views, stored procedures, and so on.

(8) in January 2008, MySQL AB was acquired by Sun for $1 billion and the MySQL database entered the Sun era. In the Sun era, Sun has done a lot of promotion, optimization, bug fixing and so on.

(9) in November 2008, MySQL 5.1 was released, which provides partitioning, event management, and row-based replication and disk-based NDB cluster systems, while fixing a number of bugs.

(10) in April 2009,Oracle acquired Sun Company for $7.4 billion, since the MySQL database entered the Oracle era, and its third-party storage engine, InnoDB, was acquired by Oracle Company as early as 2005.

(11) in December 2010, MySQL 5.5 was released, and its main new features include semi-synchronous replication and support for signal/resignal exception handling, and most importantly, the INNODB storage engine has finally become the current MySQL default storage engine. MySQL 5.5 is not a simple version update after two years, but it strengthens all aspects of MySQL in enterprise-class features. Oracle also promises that MySQL 5.5 and future versions will remain open source products licensed under the GPL.

MARIADB Database

After MySQL was acquired, faced with the risk of being closed source, so MySQL father Widenius left Sun, 2009 re-development code all open source free relational database, launched the MARIADB.

In view of all applications, MariaDB is a code-level replacement for MySQL, and the corresponding version can be replaced directly (such as MySQL 5.1, MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are also compatible. MySQL 5.5 will be compatible with), which maintains a high degree of compatibility with MySQL:

• Data and table definition files (. frm) are compatible at the code level;
• The APIs, protocols, and structures of all clients are the same;
• All file names, binaries, paths, ports, sockets, etc... are all the same;
• All MySQL and other languages (PHP, Perl, Python, Java,. NET, MyODBC, Rub, MySQL C ... ) connection file without any changes, can work in mariadb;
• mysql-clientThe program can also work on the MARIADB server.

But MARIADB is definitely not a simple alternative to MySQL, with more options, extensions, storage engines, and bug fixes than MySQL.

According to research, currently Oracel has been closed to MySQL, open source CentOS7 has not supported MySQL, and replaced by the mariadb. If the user needs to install MySQL on the CentOS7 need to first uninstall MARIADB, otherwise it will cause installation conflict.

MySQL and mariadb