MariaDB Enterprise is the leading production-grade open source database, with a feature set far above and beyond what is available from MySQL Enterprise or EnterpriseDB Postgres Platform. As the successor to MySQL, MariaDB Enterprise continues to innovate with features such as distributed SQL and columnar storage while EnterpriseDB continues to lack critical functionality such as multi-master clustering and transparent data encryption.
The table below highlights a handful of the differences between MariaDB Enterprise and its open source competitors.
EnterpriseDB | MySQL | MariaDB | |
---|---|---|---|
Distributed SQL | No | No | Yes |
Columnar storage | No | No | Yes |
Temporal tables | No | No | Yes |
Oracle Database compatibility | Yes | No | Yes |
Non-blocking backups | Yes | No | Yes |
Point-in-time rollback | No | No | Yes |
Multi-master clustering | No | Yes | Yes |
Transaction replay | No | No | Yes |
Transparent data encryption | No | Yes | Yes |
Dynamic data masking | No | No | Yes |
Parallel query | Yes | No | Yes |
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.
Oracle | Microsoft | IBM | MariaDB | |
---|---|---|---|---|
Distributed SQL | No | No | No | Yes |
Columnar storage (on-disk) | No | Yes | Yes | Yes |
Temporal tables | Yes | Partial | Yes | Yes |
Oracle Database compatibility | - | No | Yes | Yes |
Point-in-time rollback | Yes | No | No | Yes |
Multi-master clustering (shared storage) | Yes | No | Yes | No |
Multi-master clustering (shared nothing) | No | No | No | No |
Connection migration | No | No | No | Yes |
Transaction replay | Yes | No | No | Yes |
Database firewall | Yes | No | No | Yes |
Column compression | No | No | No | Yes |