MariaDB

MariaDB
source
Name	MariaDB
Developer	MariaDB Foundation
Latest release	10.x / 11.x
Programming language	C, C++
Operating system	Linux, Windows, macOS, Solaris, BSD
Genre	Relational database management system
License	GPL, LGPL, proprietary (some forks)

MariaDB is an open-source relational database management system forked from MySQL and developed to provide enhanced features, performance, and openness. Originating amid corporate transitions affecting Sun Microsystems and Oracle Corporation, it has become a central component in many LAMP-stack deployments and cloud infrastructures managed by organizations including Red Hat, Amazon Web Services, Microsoft Azure, and Google Cloud Platform. MariaDB is maintained by a mix of corporate contributors and the MariaDB Foundation community, and it competes with other systems such as PostgreSQL, SQLite, and proprietary offerings from Oracle Database.

History

MariaDB began as a fork following concerns after the acquisition of MySQL AB by Sun Microsystems and subsequently by Oracle Corporation, prompting key developers like Michael "Monty" Widenius to create a community-driven alternative. Early governance involved the Monty Program Ab and contributors from projects such as Percona and Google. Over time, corporate partnerships with vendors like Red Hat, SUSE, Debian, and Canonical helped distribute MariaDB binaries in major distributions. Significant milestones include integration into enterprise solutions from HP Enterprise and adoption by cloud providers such as Amazon Web Services, influencing migrations from MySQL Cluster and driving compatibility initiatives with projects like Drizzle and Galera Cluster.

Architecture and Features

The architecture builds on the client-server model popularized by MySQL and supports storage engines managed via a pluggable API used by contributors from Percona and Codership. It implements a query optimizer influenced by research from Stanford University and techniques used in Oracle Database and IBM Db2. Core features include replication frameworks comparable to PostgreSQL logical replication, support for stored procedures and triggers as in Microsoft SQL Server, and connectors analogous to those developed for JDBC and ODBC by vendors such as Progress Software and DataDirect. High-availability patterns are commonly implemented with clustering solutions from Codership (Galera), replication setups used by Facebook, and orchestration via tools like Kubernetes and Docker.

SQL Compatibility and Storage Engines

SQL dialect compatibility emphasizes wire-protocol parity with MySQL clients and drivers provided by ecosystems like PHP (PHP-FPM), Python (DB-API), Perl (DBI), Ruby on Rails, and Node.js (npm modules). Storage engines include the transaction-safe InnoDB-derived engines used by Oracle Corporation and community alternatives such as Aria (extended from MyISAM concepts), MyRocks developed with insights from Facebook, and the distributed ColumnStore project inspired by Apache Cassandra and Apache HBase. Indexing and full-text search capabilities are interoperable with technologies like Elasticsearch and Sphinx Search for hybrid architectures.

Performance and Scalability

Performance engineering draws on work from Facebook, Twitter, and Booking.com for large-scale OLTP workloads and from Netflix and Spotify for analytics patterns. Optimizations include thread pooling similar to approaches in Oracle Database and row/column storage hybrids used by SAP HANA. Scalability strategies integrate replication, sharding patterns comparable to Cassandra and MongoDB, and distributed query planning akin to Presto and Apache Drill. Benchmarking efforts often reference standards from TPC and community reports by vendors such as Percona and Crunchy Data.

Security and Authentication

Security features align with practices used in OpenSSL and GnuPG ecosystems, implementing TLS/SSL for client-server encryption like deployments at Let's Encrypt-managed services. Authentication supports PAM modules as in Linux PAM distributions, LDAP integrations used by Microsoft Active Directory and OpenLDAP, and plugin frameworks comparable to PostgreSQL's authentication methods. Role-based access control resembles models in Oracle Database and Microsoft SQL Server, while auditing and compliance features parallel tools from Splunk and ELK Stack deployments for regulatory environments like PCI DSS and GDPR-compliant systems.

Development, Governance, and Licensing

Development is coordinated by the MariaDB Foundation with input from corporate contributors including MariaDB Corporation Ab, Amazon Web Services, Google, Alibaba, Red Hat, Percona, and SUSE. The project uses version control and continuous integration workflows inspired by GitHub and GitLab practices and follows a mixed licensing model with core components under GNU General Public License terms and selected extensions offered under commercial licenses similar to strategies used by EnterpriseDB and MongoDB. Governance parallels models from Apache Software Foundation and Linux Foundation in balancing community and corporate interests.

Adoption and Use Cases

MariaDB is used across sectors including web platforms like Wikipedia-adjacent projects, e-commerce systems run by Alibaba Group and eBay, financial services leveraging Bloomberg-style data feeds, telecommunications infrastructures at companies like Verizon, and scientific data management in institutions such as CERN and NASA. Typical use cases span OLTP backends for WordPress and Drupal, analytics workloads paired with Pentaho and Talend, geospatial applications integrating PostGIS-like functions, and embedded scenarios in appliances by vendors like Cisco and Dell EMC.

Category:Relational database management systems Category:Free database management systems Category:Open-source software