MariaDB

MariaDB
source
Name	MariaDB
Developer	Monty Program and MariaDB Corporation Ab
Initial release	2009
Latest release version	10.11.2
Latest release date	2022
Operating system	Cross-platform
Platform	Linux, Windows, macOS
Language	C (programming language), C++, Perl
Genre	Relational database management system
License	GNU General Public License

MariaDB is a relational database management system developed by Monty Program and MariaDB Corporation Ab, founded by Michael Widenius, the original author of MySQL. It is designed to be a drop-in replacement for MySQL, with many MySQL users migrating to MariaDB due to its improved performance, security, and features. MariaDB is widely used by companies such as Google, Facebook, and Wikipedia, and is supported by Linux distributions like Ubuntu, Debian, and Fedora. Red Hat and SUSE also provide support for MariaDB in their respective enterprise Linux offerings.

Introduction

MariaDB is a fork of the popular MySQL database management system, created by Michael Widenius and David Axmark in response to concerns over Oracle Corporation's acquisition of MySQL in 2010. MariaDB aims to maintain compatibility with MySQL, while also introducing new features and improvements, such as better support for SQL and NoSQL databases, and enhanced security and performance. MariaDB is used by a wide range of organizations, including Twitter, Yahoo!, and Alibaba Group, and is supported by IBM, HP, and Dell. Canonical Ltd. and Red Hat also provide commercial support for MariaDB.

History

The development of MariaDB began in 2009, when Michael Widenius and David Axmark founded Monty Program to create a fork of MySQL. The first version of MariaDB was released in 2009, and was based on the MySQL 5.1 codebase. Since then, MariaDB has undergone significant development, with new features and improvements being added regularly. MariaDB has also been adopted by a number of high-profile organizations, including Wikipedia, Google, and Facebook. Oracle Corporation's acquisition of MySQL in 2010 led to concerns over the future of the MySQL project, and many users began to migrate to MariaDB as a result. European Union's European Commission and United States Department of Justice also reviewed the acquisition.

Features

MariaDB offers a wide range of features, including support for SQL and NoSQL databases, ACID compliance, and transactional support. MariaDB also includes a number of advanced features, such as Galera Cluster for high availability and MaxScale for database proxying. MariaDB is also compatible with a wide range of programming languages, including Java, Python, and PHP. MariaDB's SQL support includes subqueries, views, and stored procedures, and it also supports full-text search and GIS functions. Amazon Web Services and Microsoft Azure also provide support for MariaDB in their respective cloud computing platforms.

Architecture

The architecture of MariaDB is based on a client-server model, with the database server running on a central machine and client applications connecting to it over a network. MariaDB uses a relational database management system architecture, with data stored in tables and indexes used to improve query performance. MariaDB also supports replication and clustering, allowing it to be used in high-availability and distributed database environments. MariaDB's architecture is designed to be highly scalable and flexible, with support for a wide range of hardware and software configurations. Intel and AMD also provide optimized support for MariaDB in their respective CPU architectures.

Licensing

MariaDB is released under the GNU General Public License (GPL), which allows it to be used and distributed freely. MariaDB is also available under a commercial license, which provides additional support and features for enterprise users. MariaDB Corporation Ab offers a range of commercial support options, including subscription-based support and consulting services. Red Hat and SUSE also provide commercial support for MariaDB in their respective enterprise Linux offerings. Free Software Foundation and Open Source Initiative also recognize MariaDB as a free and open-source software project.

Applications

MariaDB is used in a wide range of applications, including web applications, mobile apps, and enterprise software systems. MariaDB is particularly well-suited to applications that require high performance, scalability, and reliability, such as e-commerce platforms, social media sites, and online gaming systems. MariaDB is also used by a number of high-profile organizations, including Google, Facebook, and Wikipedia, and is supported by Linux distributions like Ubuntu, Debian, and Fedora. Amazon Web Services and Microsoft Azure also provide support for MariaDB in their respective cloud computing platforms. IBM and HP also provide commercial support for MariaDB in their respective enterprise software offerings. Category:Relational database management systems