MariaDB TX vs. proprietary databases

Oracle Database, Microsoft SQL Server and IBM Db2

MariaDB TX, with features previously only available in proprietary databases (e.g., temporal tables and queries), is the first enterprise open source database capable of challenging proprietary databases.

White paper

Enterprise database comparison guide

This enterprise database comparison between Oracle Database Enterprise Edition 18c, Microsoft SQL Server 2017 Enterprise and IBM Db2 Advanced Enterprise Server Edition 11.1 for Linux, Unix and Windows (LUW) and MariaDB TX 3.0 is based on 50+ features defined across six categories of modern enterprise requirements.

High availability

MariaDB TX supports both master/slave replication with automatic failover and multi-master clustering, within a single data center or across multiple data centers, to maintain high availability in the event of a database, server or data center failure. In addition, disaster recovery is supported via delayed replication, point-in-time rollback and backup/restore.

High performance, scalability and efficiency

MariaDB TX supports both local and distributed partitions (i.e., sharding) to improve query performance; table, row or column compression to reduce disk I/O; and query result caching to reduce the load on the database. In addition, MariaDB TX includes a space- and write-optimized storage engine to improve the write performance and reduce the disk I/O of write-intensive workloads.

MariaDB vs. Oracle, Microsoft and IBM

MariaDB TX 3.0 supports the same core enterprise features as Oracle Database 18c Enterprise Edition, Microsoft SQL Server 2017 Enterprise and IBM Db2 for Linux, Unix and Windows 11.1 Advanced Enterprise Server Edition, and in some cases, supports more. Oracle Database and IBM Db2 support multi-master clustering, but Oracle RAC and IBM pureScale are not supported on public clouds (e.g., Microsoft Azure) because they rely on shared storage. However, MariaDB TX multi-master clustering is based on synchronous group replication, so it can be used on any public cloud. Further, MariaDB TX is engineered to run well on commodity hardware, cloud instances and containers.

MariaDB

Oracle

Microsoft

IBM

Replication

Yes

Active Data Guard*

Availability Groups

SQL Replication

Clustering

MariaDB Cluster

RAC*

–

pureScale

Backup and restore

MariaDB Backup

RMAN

Yes

Yes

Rollback

MariaDB Flashback

Flasback

–

–

Distributed partitions

Spider

Sharding*

–

DPF

Compression

Yes

Advanced Compression*

Yes

Yes

Encryption

Yes

Advanced Security*

Yes

Yes

Database firewall

Yes

Database Firewall*

–

–

Dynamic data masking

Yes

Advanced Security*

Yes

Yes

Columnar

MariaDB AX

Database In-Memory*

Yes

Blu Acceleration

Temporal

Yes

Flashback Query*

Temporal Tables

Time Travel Query

Stored procedures

SQL/PSM

PL/SQL

SQL PL

SQL/PSM

Oracle compatibility

Yes

–

–

Yes

*Not included in an Oracle Database Enterprise Edition license; must be purchased separately.