MariaDB

MariaDB Server is a world-wide popular database server, which is created by the original developers of MySQL. It is highly compatible with applications developed for MySQL. New features from MySQL are likely to be also added into MariaDB. In most cases, users can directly switch from MySQL to MariaDB without extra work.

History

MariaDB was forked from MySQL after Sun's acquisition by Oracle. The project is lead by Michael Widenius, who was also a founder of MySQL AB which was later acquired by Sun. The DBMS was named after Michael Widenius' younger daughter Maria, just like MySQL, which was named after his first daughter "My".

Storage Architecture

Disk-oriented In-Memory

MariaDB supports different storage architectures with different storage engines.

Foreign Keys

Supported

MariaDB requires foreign keys to be checked that some integrity rules are enforced.

Query Compilation

Not Supported

Checkpoints

Consistent Fuzzy

XtraDB, a fork of InnoDB, is the default storage engine of MariaDB 10.1, while InnoDB is the default storage engine of MariaDB 10.2. InnoDB supports: Sharp checkpointing: all dirty pages of committed transactions are being flushed, while dirty pages for uncommitted transactions are not being flushed. Fuzzy checkpointing: the dirty pages that will be flushed in sharp checkpointing will be gradually flushed.

Logging

Logical Logging Physical Logging

Physical logging is called binary logging in MariaDB, while logical logging is called general query logging.

Indexes

B+Tree Hash Table R-Tree

Different Storage engines support different indexes: Aria: B-tree, R-tree MyISAM B-tree, R-tree InnoDB: B-tree Memory/Heap: Hash, B-tree *NDB: B-tree, Hash

MariaDB Logo
Website

http://mariadb.org/

Source Code

https://github.com/MariaDB/server

Country of Origin

US

Start Year

2009

Project Type

Open Source

Written in

Bash, C, C++, Perl

Supported languages

C, C#, C++, Java, Perl, PHP, Ruby, SQL

Derived From

MySQL

Operating Systems

Linux, Windows

Licenses

GPL v2

Wikipedia

https://en.wikipedia.org/wiki/MariaDB