MariaDB

by

MariaDB is a Database Management System derived from MySQL with a GPL (General Public License). It is developed by Michael (Monty) Widenius (founder of MySQL ), the MariaDB foundation, and the free software developer community . [1] It introduces two new storage engines , one called Aria – which replaces MyISAM with advantages – and another called XtraDB – to replace InnoDB. It has a high compatibility with MySQL since it has the same commands, interfaces, APIs and libraries, its objective being to be able to change one server for another directly. [2] This DBMS arises from the purchase of Sun Microsystems – a company that had previously purchased MySQL AB [3] – by Oracle. MariaDB is a direct fork of MySQL that ensures the existence of a GPL licensed version of this product. Monty decided to create this variant because he was convinced that Oracle’s only interest in MySQL was to reduce the competition that MySQL posed to the world’s largest vendor of relational databases, which is Oracle. [4]

Summary

[ hide ]

  • 1 Third party software
  • 2 Versions
  • 3 Differences with MySQL
  • 4 Reference
  • 5 External links

Third party software

There are quite a few proprietary and free third-party packages designed for MySQL that are also available to integrate with MariaDB. Some examples are:

  • DBEdit– a free administration application for MariaDB and other databases.
  • Navicat– a series of proprietary database management applications for Windows , Mac OS X and Linux .
  • SQLyog– proprietary MariaDB compliant MySQL database management application for Windows and Linux .
  • HeidiSQL– a free and open source client for MySQL, 100% compatible with MariaDB, included with MariaDB’s MSI package for Windows since version 5.2.7. [5] [6]
  • phpMyAdmin– a free administration web application for MySQL compatible with MariaDB.

Versions

The development version of MariaDB is 10.0. [7] It is built on version 5.5, with some features of MySQL 5.6 and other new features not found in any other previous version.

Differences with MySQL

File: LAMP software bundle.svg

The LAMP comprises MariaDB® (here with Squid )

In practice MariaDB directly replaces the same version of MySQL (MySQL 5.1 -> MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are compatible. MySQL 5.5 -> MariaDB 5.5). The differences are in these points. [8]

Storage Mechanisms
In addition to the standard MyISAM, Blackhole, CSV, Memory and Archive storage mechanisms , the following are also included in the source and binary version of MariaDB:

  • Aria (fall resistant MyISAM alternative)
  • XtraDB (direct replacement for InnoDB)
  • PBXT (in MariaDB 5.1, 5.2 and 5.3. Disabled in 5.5)
  • FederatedX (direct replacement for Federated)
  • OQGRAPH – new in 5.2
  • SphinxSE – new in 5.2
  • Removed by Oracle from MySQL 5.1.55 but included in MariaDB code up to version 5.5.
  • Cassandra, in MariaDB 10.0 (other non-sql mechanisms will be included in MariaDB)
  • Sequence, released with MariaDB 10.0.3

Easy to use

  • It provides index and table statistics, by adding new tables in INFORMATION_SCHEMA and new options to the FLUSH and SHOW commands to identify the cause of the DBMS load.
  • The ALTER TABLE and LOAD DATA INFILE commands are no longer opaque and report progress.
  • The precision for data type TIME, DATETIME, and TIMESTAMP extended to the microsecond.
  • Introduced NoSQL-style features such as HandlerSocket that provides direct access to InnoDB tables bypassing the SQL layer.
  • Dynamic columns, which provide the user with virtual columns in the tables.
  • Subqueries work correctly.

Benefits

  • The MariaDB optimizer – which is at the core of any DBMS – works clearly faster with complex loads.
  • Substantial improvements have been made in replication, for example the “group commit for the binary log” that speeds replication up to twice.
  • Elimination of tables. Accessing tables through views accelerates access.

Testing

  • More test games in the distribution.
  • Patches for tests.
  • Different combinations of configuration and operating system for the tests.
  • Elimination of unnecessary tests, such as “do not test the X feature if I have not included it in my executable”.

Fewer errors and alerts

  • Testing games have reduced errors without introducing new ones.
  • Build alerts are related, and developers have tried to narrow them down.

 

 

by Abdullah Sam
I’m a teacher, researcher and writer. I write about study subjects to improve the learning of college and university students. I write top Quality study notes Mostly, Tech, Games, Education, And Solutions/Tips and Tricks. I am a person who helps students to acquire knowledge, competence or virtue.

Leave a Comment