MariaDB 10.x

MariaDB 10.x
Name	MariaDB 10.x
Developer	MariaDB Foundation
Released	2013
Latest release	varies by minor version
Programming language	C, C++
Operating system	Cross-platform
Genre	Relational database management system
License	GNU General Public License

MariaDB 10.x is a major branch of the open-source relational database engine developed and maintained by the MariaDB Foundation and community contributors. It extended core capabilities inherited from MySQL and introduced features aimed at enterprise deployments, cloud providers, and web-scale applications while maintaining compatibility with tools and connectors created for Oracle Corporation's original project. The series influenced adoption across vendors such as Red Hat, SUSE, IBM, Google, and Amazon Web Services and underpinned services used by organizations including Wikipedia, WordPress, GitHub, Mozilla, and Dropbox.

Overview

MariaDB 10.x consolidated contributions from forks and upstream projects associated with MySQL developers like Michael "Monty" Widenius's initiatives and collaborators from SkySQL and the MariaDB Foundation. It positioned itself as an alternative to Oracle Corporation's distribution and attracted ecosystem projects from Percona, Monty Program AB, Codership, and Alibaba Group. The branch emphasized modular storage engines, pluggable architecture, and an open governance model influenced by foundations such as the Linux Foundation and Apache Software Foundation.

New features and enhancements

The 10.x line introduced multiple capabilities integrating technologies and standards familiar to projects like PostgreSQL, SQLite, and MongoDB ecosystems. It added or improved storage engines and plugins from contributors such as Aria (MariaDB), XtraDB by Percona, TokuDB from Tokutek, and clustering technologies inspired by Galera Cluster from Codership. Features included native support for temporal types similar to ISO 8601 handling used in Microsoft SQL Server and Oracle Database, enhanced JSON functions paralleling ECMAScript standards used by Node.js and V8, and window functions aligning with SQL:2003 implementations in IBM Db2 and PostgreSQL.

Other enhancements mirrored capabilities present in Oracle Corporation's offerings and cloud databases like Amazon Aurora and Google Cloud Spanner, such as thread pooling, optimizer improvements influenced by academic work from institutions like MIT, Stanford University, and University of California, Berkeley, and replication features comparable to Streaming replication in PostgreSQL and Oracle GoldenGate.

Compatibility and migration

MariaDB 10.x maintained protocol and API compatibility with client libraries used by PHP, Python, Java, Ruby, and Perl ecosystems, ensuring interoperability with projects like Drupal, Magento, Joomla!, Laravel, and Django. Migration paths referenced tooling and practices from mysqldump, Percona XtraBackup, and advisory material reminiscent of migration experiences between MySQL and PostgreSQL in enterprises such as Facebook and Twitter. Vendors including Canonical, Debian Project, and Alpine Linux packaged MariaDB 10.x to replace MySQL in server stacks used by NGINX, Apache HTTP Server, and Lighttpd deployments.

Performance and scalability

Optimizations in 10.x targeted workloads similar to those managed by Oracle Database and Microsoft SQL Server in large enterprises like CERN, NASA, and Netflix. Incorporation of engines such as InnoDB, tuned through contributions from Oracle and Percona, and alternative engines like Aria and ColumnStore enabled analytic workloads comparable to Apache Hadoop and Apache Spark integrations. Parallel query execution, improved I/O handling benefiting deployments on NVMe storage by vendors like Intel and Samsung, and scale-out clustering via Galera Cluster supported high-availability architectures employed by Bank of America-class systems and cloud operators such as DigitalOcean and Microsoft Azure.

Security and administration

MariaDB 10.x introduced administrative and security-related features influenced by standards and projects such as OAuth, TLS, and X.509 certificate handling used across Google Cloud Platform and Amazon Web Services. Authentication plugins allowed integration with identity providers including LDAP, Active Directory by Microsoft, and single sign-on systems used by Atlassian and Okta. Audit plugins and role-based access control paralleled compliance tooling found in PCI DSS and HIPAA-subjected deployments at organizations like Pfizer and Johnson & Johnson. Backup and recovery strategies leveraged community tools from Percona and ecosystem projects like Barman and Ansible for orchestration adopted by Red Hat and SUSE customers.

Release history and versioning

The 10.x branch followed a versioning cadence similar to open-source projects overseen by foundations like Apache Software Foundation and the Linux Kernel release process, with minor and patch releases addressing security fixes, performance regressions, and feature backports. Key milestones involved collaboration with contributors from Percona, Alibaba Cloud, and Tencent and coordination with distribution maintainers at Debian Project, Ubuntu, Fedora Project, and CentOS Project. Version histories and changelogs were influenced by upstream decisions made by MySQL maintainers at Oracle Corporation and community governance models like those of LibreOffice and KDE.

Adoption and ecosystem

Adoption of MariaDB 10.x spanned technology companies and institutions such as Wikipedia, WordPress, Mozilla, Dropbox, GitHub, Red Hat, SUSE, IBM, Google, Amazon Web Services, Microsoft Azure, DigitalOcean, Alibaba Cloud, and Tencent Cloud. The ecosystem included connectors and client libraries maintained by projects like PHP-FPM, JDBC, Psycopg-style adapters in Python communities, ORMs such as Hibernate, Doctrine (PHP), ActiveRecord, and management tools like phpMyAdmin, Adminer, MySQL Workbench, and monitoring systems used by Prometheus and Grafana. Community events and conferences featuring MariaDB 10.x included gatherings similar to FOSDEM, Open Source Summit, Percona Live, and vendor summits by Red Hat and SUSE.

Category:Relational database management systems