MariaDB vs. Oracle

MariaDB vs. Oracle

open source economics, enterprise ready

Want the enterprise reliability, availability and scalability of Oracle without the expensive proprietary platform?  If you’re torn between the need to preserve application code that uses Oracle stored procedures (pl/sql) and demands to leverage open source to reduce cost, now you can have both.  MariaDB is one of the largest open source communities in the world. MariaDB Enterprise Server delivers enterprise-grade operations, Oracle compatibility for stored procedures, and tools to support low-risk, rapid migration for Oracle RAC and Exadata to commodity hardware or for any Oracle database to SkySQL on AWS or Google Cloud.

Read Now

Separator

retaining the best of oracle with MariaDB

MariaDB delivers the same enterprise grade features as Oracle.

Oracle Database Compatibility

MariaDB is the only open source database compatible with Oracle Database data types, sequences, PL/SQL stored procedures and more, making it possible to “lift and shift” without having to modify database schemas and rewrite store procedures.

Learn More

High Availability and Scalability

Maintain continuous availability and hide failures from applications using multi-write clusters and zero-interruption failover features such as transaction replay. Vertical scale-out through parallel query, read replication and multi-master clustering.

Learn More
blue

6 ways to do more with MariaDB

MariaDB and MySQL are both general-purpose databases. However, only MariaDB Corporation adheres to the open source mission yet provides a consistent set of advanced features and functionality across all major cloud platforms and on-premises.

Distributed SQL

MariaDB can be deployed as a distributed SQL database, scaling out to achieve millions of transactions/second on commodity hardware while ensuring high availability and enforcing strong consistency for mission-critical applications requiring elasticity and full scalability.

Learn More

Columnar Storage Format

MariaDB supports both row and columnar storage. It can be deployed as a data warehouse for interactive, ad hoc analytics or as a hybrid transactional/analytical processing, storing current data in row storage and historical data in columnar.

Learn More

Pluggable Storage Engines

Pluggable storage engines including InnoDB, Spider, Aria, ColumnStore and many others provide a range of possibilities for scaling, high availability and columnar analytics.

Learn More

MySQL Database Compatibility

MariaDB is a fork of MySQL and is 100% compatible with MySQL 5.7 and earlier versions with minor migration requirements for MySQL 8.0.

Learn More

Federation

MariaDB and MySQL can access tables in other MariaDB/MySQL databases, but only MariaDB can federate heterogeneous databases, including Oracle Database, Microsoft SQL Server and IBM Db2, to consolidate data access and/or simplify database migration.

Learn More

Shared Innovation

MariaDB is a vibrant and growing open source community numbering in the millions. It consists of active contributors with GNU and GPL licensing, encouraging code base enhancements and sharing of innovation with the community.

MariaDB vs. Oracle, Microsoft and IBM

MariaDB Enterprise supports the same core enterprise features as Oracle Database, Microsoft SQL Server and IBM Db2, and in some cases, even more (e.g., elastic scale out with distributed SQL). Further, while Oracle Database, IBM Db2 and MariaDB Enterprise all support multi-master clustering, only MariaDB Enterprise implements a shared-nothing architecture.

The table below highlights a handful of the differences between MariaDB Enterprise and its proprietary competitors.

MariaDB Enterprise ServerOracle Enterprise EditionMicrosoft SQL Server EnterpriseIBM DB2
ReplicationYesActive Data Guard*Availability GroupsSQL Replication
ClusteringMultiple clustering optionsRAC*Yes*pureScale
Multi-cloud Single-architecturesYesNoNoNo
Backup and restoreMariaDB BCMRMANYesYes
Built-in SQL IDEYesYesYesNo
Distributed partitions with legacy RDBMS connectorsMultiple optionsOracle Partitioning*NoDPF
CompressionMultiple optionsAdvanced Compression*YesYes
EncryptionYesAdvanced Security*YesYes
Database firewallYesDatabase Firewall*Uses Windows FirewallNo
ColumnarMariaDB ColumnStoreDatabase In-Memory*YesBlu Acceleration
TemporalYesFlashback Query*Temporal TablesTime Travel Query
Stored proceduresSQL, PSM, PL-SQL, CPL, SQL, JavaT-SQLDB2-SQL, SQL PL
Oracle compatibilityYesYesNoYes

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

MariaDB vs. Oracle Resources

White Paper
White Paper
Migration Guide: Oracle to MariaDB
White Paper
Migration Guide: Oracle to MariaDB
Learn More
White Paper
White Paper
Total Cost of Ownership: Database Software and Support
White Paper
Total Cost of Ownership: Database Software and Support
Learn More
White Paper
White Paper
Guide to Open Source Database Selection: MySQL vs. MariaDB
White Paper
Guide to Open Source Database Selection: MySQL vs. MariaDB
Learn More