MariaDB (MySQL): open-source SQL Database
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License.
MariaDB intended to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands. However, new features diverge more (ex: XtraDB replaces InnoDB).
MariaDB server can be integrated with Galera Cluster that extends it with the feature of acting as a synchronous multi-master cluster.
Written in: C, C++
Download MariaDB: Source Code and Binaries
License: OpenSource GPL License (Version 2.0)
Project Website: mariadb.org
Documentation: mariadb.com/kb
Project Goals
- MariaDB runs on a number of operating systems and supports a wide variety of programming languages.
- It includes new storage engines like Aria, ColumnStore, and MyRocks.
Project Features
- MariaDB includes a wide selection of storage engines, including high-performance storage engines, for working with other RDBMS data sources.
- It uses a standard and popular querying language.
Project Design and Security
- MariaDB also offers many operations and commands unavailable in MySQL.
- It eliminates / replaces features impacting performance negatively from MySQL.
Sample Configuration
## Sample Configuration for MariaDB @ /etc/my.cnf
[client-server]
#socket=/var/run/mysql/mysql.sock
#port=3306
# This will be passed to all MariaDB clients
[client]
#password=my_password
# The MariaDB server
[mysqld]
# To listen to all IPv4 network addresses, use "bind-address = 0.0.0.0"
bind-address=127.0.0.1
# Directory where you want to put your data
#data=/var/mysql
# This is the prefix name to be used for all log, error and replication files
#log-basename=mysqld
# Logging
#general-log
#slow_query_log
## END
