MariaDB TX vs. proprietary databases

Oracle Database, Microsoft SQL Server and IBM Db2

MariaDB TX 3.0, 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.

How MariaDB TX meets 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.

Advanced security

MariaDB TX supports both data-in-motion encryption (e.g., connections and replication) and data-at-rest encryption (i.e., transparent data encryption), data protection via roles and dynamic data masking (full or partial) and database protection from denial-of-service attacks. In addition, it includes a database firewall capable of blocking queries based on syntax, role, frequency and/or time.

Scalable, high-performance analytics

MariaDB TX can replicate data to MariaDB AX via a change-data-capture (CDC) stream to support scalable, high-performance analytics on near real-time data. MariaDB AX uses distributed, columnar storage and massively parallel processing (MPP) to support ad hoc, on-demand analytics on billions of rows without the need for indexes.

Standard SQL

MariaDB TX supports JSON documents, geospatial data, sequences and virtual columns – and is the first enterprise open source database with out-of-the-box support for temporal tables and queries via system-versioned tables and standard SQL syntax. In addition, MariaDB TX supports window functions, common table expressions, user-defined functions (scalar and aggregate) and set operators (UNION, INTERSECT and EXCEPT).

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.

  Oracle Microsoft IBM MariaDB
Replication Active Data Guard* Availability Groups SQL Replication Yes
Clustering RAC* - pureScale MariaDB Cluster
Backup and restore RMAN Yes Yes MariaDB Backup
Rollback Flashback - - MariaDB Flashback
Distributed partitions Sharding* - DPF Spider
Compression Advanced Compression* Yes Yes Yes
Encryption Advanced Security* Yes Yes Yes
Database firewall Database Firewall* - - Yes
Dynamic data masking Advanced Security* Yes Yes Yes
Columnar Database In-Memory* Yes BLU Acceleration MariaDB AX
Temporal Flashback Query Temporal Tables Time Travel Query Yes
Stored procedures PL/SQL Transact-SQL SQL PL SQL/PSM
Oracle compatibility   - Yes Yes

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

Download the enterprise database comparison white paper below to see a full comparison based on 50+ features.

Enterprise database comparison

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 and disaster recovery
  • Performance, scalability and efficiency
  • Security
  • Analytics
  • Schema
  • SQL

White paper

Recorded webinar

MariaDB vs. Oracle, MS and IBM

This webinar recording compares MariaDB TX with Oracle Database, Microsoft SQL Server and IBM Db2 for Linux, Unix and Windows (LUW) in terms of high availability, disaster recovery, performance, scalability, security, analytics, schema and SQL.

Watch now to learn:

  • About the latest enterprise features in MariaDB TX 3.0
  • How MariaDB compares with Oracle, Microsoft and IBM
  • If MariaDB TX meets enterprise requirements
MariaDB vs. proprietary databases webinar thumbnail

Available on demand