MariaDB Server

The world’s fastest growing open source database

MariaDB Server is a general purpose database engineered with an extensible architecture to support a broad set of use cases via pluggable storage engines – using different storage engines to support different use cases.

MariaDB Server is one of the most popular open source databases in the world. It is available in Debian and Ubuntu, and it is now the default database on Arch Linux, Manjaro, openSUSE, Red Hat Enterprise Linux/CentOS/Fedora and SUSE Linux Enterprise. And as one of the most broadly adopted and widely deployed in the world, MariaDB Server receives contributions from companies like Alibaba, Facebook, and Google — benefiting the entire community.

 

Featured Storage Engines

  • InnoDB for general purpose transactional workloads
  • MyRocks* for better performance and efficiency with flash storage
  • Spider* for scaling out with distributed storage

*MyRocks and Spider are included for technical preview

 

MariaDB Extensible Architecture

 

InnoDB

MariaDB Server 10.2 introduces performance enhancements and improvements to InnoDB, the default storage engine – including improved temporary table performance, optimized buffer pool handling, NUMA interleave, optimized crashed recovery and spatial indexes.

MyRocks

MyRocks, developed by Facebook and introduced in MariaDB Server 10.2, is an SSD optimized storage engine for workloads requiring higher space and write efficiency, improving performance and scalability with better compression, less write amplification, faster replication and faster loading.

JSON

MariaDB Server 10.2 introduces a comprehensive set of 24 functions for reading and writing of JSON documents. In addition, the JSON_VALID function can be used with a check constraint for validation while functions like JSON_VALUE can be used with dynamic columns to index specific fields.

Dynamic Columns

With dynamic columns, it is possible for different rows to store different data in the same column – ideal when the attributes vary between objects. For example, in a product catalog where it would be easier to store different types of products in the same table rather than in separate tables.

Replication

MariaDB Server includes built-in asynchronous master/slave and multi-source replication using the binary log and global transaction identifiers as well as synchronous multi-master replication for high availability, read scaling and disaster recovery.

Encryption

MariaDB Server includes built-in encryption for data at rest and data in motion, ensuring end-to-end encryption, and supports the AWS Key Management Service via the encryption plugin API. In addition, with MariaDB Server 10.2, TLS connections can be enforced.

Rollback

In addition to backup/restore tools, MariaDB Server 10.2 introduces point-in-time rollback using the binary log. This enables administrators to restore data to a specific point in time by rolling back recent transactions rather than restoring data from a backup, a longer process.

Query Optimizer

MariaDB Server has optimizations for subqueries and derived tables as well as table elimination, block-based join algorithms (e.g. batch key access), partition pruning and index condition pushdown, with MariaDB Server 10.2 adding condition pushdown for non-mergeable views and derived tables.

SQL

MariaDB Server 10.2 improves SQL completeness with the addition of common table expressions and window functions while at the same time removes existing limitations by supporting subqueries within views and multiple temporary tables within a single query.

Schema

MariaDB Server 10.2 improves schema compatibility with the addition of check constraints, default values for BLOB/TEXT columns, increased DECIMAL precision to 38 places and support for multiple triggers of the same type per table.

 

 

 

 

Interested in MariaDB Server? Visit Resources to learn more.

Learn more about our latest release.