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
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 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.
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.
|Replication||Active Data Guard*||Availability Groups||SQL Replication||Yes|
|Backup and restore||RMAN||Yes||Yes||MariaDB Backup|
|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|
*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
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
Available on demandWATCH NOW