Any workload. Any scale.

Any workload. Any scale.

MariaDB Platform is the complete enterprise open source database solution. It has the versatility to support transactional, analytical and hybrid workloads as well as relational, JSON and hybrid data models. And it has the scalability to grow from standalone databases and data warehouses to fully distributed SQL for executing millions of transactions per second and performing interactive, ad hoc analytics on billions of rows.

Why MariaDB?

Break free from the costs, constraints and complexity of proprietary databases and reinvest in what matters most, developing innovative applications and services as fast as possible. Experience the same benefits as customers like Deutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens – industry leaders who trust MariaDB to deliver unmatched operational agility, provide enterprise reliability and drive collaborative innovation.


Components


MariaDB Enterprise Server

MariaDB Enterprise Server is an enhanced, hardened and secured version of MariaDB built to meet the most challenging reliability, stability, security and scalability requirements of business-critical, mission-critical applications.

MariaDB MaxScale

MariaDB MaxScale adds advanced data protection with a database firewall and dynamic data masking, high availability with dynamic query routing and automatic failover and query result caching with Redis integration.

MariaDB ColumnStore

MariaDB ColumnStore adds interactive, ad hoc analytics at scale with columnar storage and massively parallel processing, transforming MariaDB Enterprise Server into a data warehouse or hybrid database.

MariaDB Xpand

MariaDB Xpand adds elasticity and massive scalability on premises or in the cloud with fully distributed data and transaction processing, turning MariaDB Enterprise Server into a distributed SQL database when needed.

MariaDB Enterprise Server

MariaDB Enterprise Server is an enhanced, hardened and secured version of MariaDB Community Server created to provide customers with enterprise reliability, stability and long-term support as well as greater operational efficiency when it comes to managing large database deployments for business- and mission-critical applications.

Enhanced

Improvements to auditing, backups, clustering, federation, replication and storage allow DBAs to fully secure databases and avoid downtime.

Hardened

Further testing and enterprise documentation incorporates fixes and workarounds to bugs and issues found in MariaDB Community Server.

Secured

The default configuration maximizes security and durability to ensure production deployments are safe, and all non-GA plugins are removed.

Enterprise Audit

Collect detailed connection information and create granular audit rules and templates using JSON documents stored in system tables

Enterprise Backup

Take backups on large databases without blocking writes and interrupting applications, or blocking important schema changes.

Enterprise Cluster

Deploy secure multi-master clusters with encrypted transaction buffers and default configurations optimized for production.

MariaDB MaxScale

MariaDB MaxScale is an advanced database proxy for MariaDB Enterprise Server, providing it with enterprise high availability, scalability, security and integration services while at the same time abstracting away the underlying database infrastructure to simplify application development and database administration.

High Availability

Automatic failover with transaction reply ensure applications are not interrupted, or even aware of, an infrastructure failure.

Integration

Radis can be used to cache query results to improve performance while Kafka can be used to publish data changes to external systems.

Security

The database firewall, dynamic data masking and query throttling features protect database from attacks and prevent data breaches.

Scalability

Intelligent query routing and adaptive load balancing simplify application development and improve query performance.

ColumnStore

MariaDB ColumnStore extends MariaDB Enterprise Server with distributed, columnar storage and massively parallel processing (MPP), transforming it into a standalone or distributed data warehouse for interactive, ad hoc analytics on billions of rows without the need to create indexes – and with standard SQL.

Columnar

Data is stored in a columnar format for fast analytics and with up to 90% compression, reducing disk I/O and size of data on disk.

Distributed

Data can be distributed across multiple database instances and queried in parallel to increase query performance and support massive datasets.

Cloud Native

Data can be stored on Amazon S3 compatible object storage, on premises or in the cloud, to benefit from low-cost, unlimited storage.

Xpand

Xpand extends MariaDB Enterprise Server with distributed data and transaction processing, transforming it into a distributed SQL database capable of scaling to millions of transactions per second with a shared-nothing architecture. However, Xpand is not all or nothing. DBAs can choose to use both replicated and distributed tables.

Distributed tables and indexes

Xpand distributes both table data and primary/secondary indexes across all database instances to maximize query parallelization.

Distributed Transactions

Xpand uses distributed transactions with parallel writes, multi-version concurrency control (MVCC) and consensus to enforce strong consistency.

Elastic Scaling on Demand

MariaDB Enterprise Server instances with Xpand can be added or removed on demand to scale out or scale in as workloads change.

MariaDB Capabilities


Scalability

MariaDB Platform scales up with more cores, memory and storage and scales out with more database instances – making it easy to get started with a standalone instance, run on a bigger server, add replicas to scale reads and finally, to scale out reads, writes and storage with hundreds of instances and distributed SQL.

Sharding

Spread tables partitions across multiple database instances to scale out reads, writes and storage transparently to applications

Partitioning

Partitioning large tables by range, list or hash to improve query and index performance, and use multiple disks/different disks per partition

Parallel query

Use multiple threads to execute aggregates, sorts, joins and more on multiple partitions at the same time scale up linearly with cores.

Read Replicas

Add read replicas using asynchronous and semi-sync replication, or use MaxScale as replication server for hundreds.

Compression

Reduce the size of data on disks by 33-66% using InnoDB or MyRocks table compression, or compress only specific columns.

Distributed SQL

MariaDB Platform supports distributed SQL with the Xpand storage engine, easily transforming a replicated or clustered database into a fully distributed database capable of scaling out to execute millions of transactions per second without sacrificing latency or standard SQL (e.g., joins). Alternatively, use both replicated and distributed tables by using Xpand for tables with lots of data and/or queries, and InnoDB or MyRocks for tables with much less.

High Availability

MariaDB Platform includes two options to meet enterprise high availability requirements: replication with automatic failover, and multi-master clustering using synchronous replication and a shared-nothing architecture.

Automatic Failover

MariaDB MaxScale provides MariaDB Platform with automatic failover, promoting an up-to-date replica if the primary becomes unreachable or unresponsive, and rerouting application queries to the new primary.

Multi-Master Clustering

MariaDB Enterprise Cluster provides MariaDB Platform with synchronous, multi-master clustering for mission-critical applications requiring continuous availability and strong consistency through infrastructure failures.

Zero-Interruption Failover

While most databases can meet standard high availability requirements with automatic failover and/or multi-master clustering, MariaDB Platform is the only database with advanced features comparable to Oracle Application Continuity. Together, they hide infrastructure and database failures from applications, resulting in zero-interruption failover.

Connection Migration

MaxScale migrates backend database connections after performing an automatic failover, applications don't have to create new connections because of a failover.

Session Restore

MaxScale restores database sessions on a newly promoted primary after it has performed an automatic failover, applications don't have to restore sessions because of a failover.

Transaction Replay

MaxScale replays in-flight transactions after performing an automatic failover so they can continue, applications don't have to retry transactions because of a failover

Disaster recovery

MariaDB Platform includes a number of tools and features for implementing comprehensive disaster recovery plans, including non-blocking backups and point-in-time restore with MariaDB Enterprise Backup to online point-in-time rollback with MariaDB Flashback. In addition, delayed replicas (e.g., 1 hour, 12 hour and 1 day) can be used as part of an advanced strategy to prevent accidental or malicious data loss/corruption from reaching backups.

Enterprise Backup

Perform online, non-blocking backups (full or incremental), create cumulative backups and use them to restore databases to a specific point in time with MariaDB Enterprise Backup.

Flashback

Undo the most recent transactions to recover from malicious or accidental data loss/corruption faster, and without incurring downtime, by using MariaDB Flashback to “rewind the database.”

Delayed replicas

With delayed replication, replicas can be staggered behind the primary in order to prevent data loss/corruption from reaching backups and recover data without needing a restore.

Security

MariaDB Platform goes above and beyond standard security features such as roles and auditing, with advanced data protection and security layers such as complete, end-to-end encryption, a powerful database firewall to stop intruders and malicious attacks and dynamic data masking/obfuscation to protect customer data and prevent data breaches.

Encryption

Encrypt all data motion with secure connections(TLS), and at rest, including logs, with transparent data encryption (TDE).

Dynamic data masking

Prevent sensitive and personally identifiable information from being exposed by masking query results before they are returned.

Database firewall

Protect data from malicious attackers by blocking queries based on their type, syntax, columns, time of day, user and more.

Oracle Database Compatibility

MariaDB Platform is the only database solution with a 100% open source implementation of Oracle PL/SQL, making it easy for enterprises to migrate from Oracle Database without having to rewrite stored procedures, modify schemas and change application code. MariaDB customers have imported hundreds of thousands of lines of PL/SQL.

Data Types and Sequences

MariaDB Platform supports standard Oracle Database data types such as VARCHAR2, NUMBER, DATE, RAW, BLOB and CLOB as well as sequences using Oracle Database syntax (e.g., NEXTVAL and CURRVAL).

Stored procedures (PL/SQL)

MariaDB Platform supports standard Oracle Database packages and procedures written in PL/SQL, including cursors, loops, variables, exceptions and functions such as CAST, LENGTH and SUBSTR.

JSON

MariaDB Platform supports hybrid relational/JSON data models, allowing developers to extend relational data models with JSON documents and query them with standard SQL for faster development, or to query relational data as JSON documents, while at the same time ensuring DBAs can continue to enforce data integrity and correctness.

Schema flexibility

Add JSON columns to extend existing tables to provide developers with greater flexibility – speed up app development by allowing the data model to evolve on demand rather than requiring schema changes up front.

Standard SQL

Query and index JSON documents with standard SQL using a comprehensive set of JSON functions to read/write JSON documents, fields, array and objects – or return relational data as JSON documents.

Interested in learning more? Contact one of our Database-leading experts.