Database Scalability

MariaDB Enterprise 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 or add replicas to scale reads.

Compression

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

Partitioning

Partition 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.

Sharding

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

new-gradient

Database High Availability

MariaDB Enterprise Platform includes two options to meet enterprise high availability requirements: replication with automatic failover and clustering using synchronous replication.

Automatic failover

MariaDB MaxScale provides MariaDB Enterprise 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.

Clustering

MariaDB Enterprise Cluster provides MariaDB Enterprise Platform with synchronous 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 clustering, MariaDB Enterprise Platform is the only database solution with advanced features comparable to Oracle Application Continuity. With MariaDB Enterprise Platform, infrastructure and database failures are hidden from applications, resulting in zero-interruption failover.

Connection migration

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

Session restore

MariaDB 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

MariaDB 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.

new-gradient

Database Disaster Recovery

MariaDB Enterprise Platform includes a number of tools and features for implementing comprehensive disaster recovery plans, including non-blocking backups and point-in-time restore to online point-in-time rollback. In addition, delayed replicas (e.g., 1 hour, 12 hours or 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 full or incremental backups, 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.

new-gradient

Security

MariaDB Enterprise 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 and dynamic data masking/obfuscation to protect customer data and prevent data breaches.

Encryption

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

Dynamic data masking

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

new-gradient

Legacy Database Compatibility

MariaDB Enterprise Platform offers an ideal environment for running SQL applications, boasting support for PL/SQL, as well as some compatibility with SQL Server and Sybase SQL. This extensive compatibility significantly simplifies the porting of existing applications, requiring minimal code and schema modifications.

Data types and sequences

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

Oracle stored procedures (PL/SQL)

MariaDB Enterprise Platform is the only enterprise database solution with a 100% open source implementation of Oracle PL/SQL. It supports standard Oracle database packages and procedures including cursors, loops, variables, exceptions and functions such as CAST, LENGTH and SUBSTR.

new-gradient

JSON Database

MariaDB Enterprise 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. You can even return a JSON document as a standard SQL row.

divider-navy