You are here

MariaDB Enterprise Server vs. MariaDB Community Server

MariaDB Enterprise Platform

The MariaDB Enterprise Platform is available on-premises and on the MariaDB SkySQL DBaaS (Cloud database platform). MariaDB Enterprise Platform consists of:

  • MariaDB Enterprise Server (MariaDB database server)
  • MariaDB Xpand (distributed database, scaling writes, former ClustrixDB)
  • MariaDB Enterprise ColumnStore (former InfiniDB used for data warehouse (DWH), BI, Reporting)
  • MariaDB MaxScale (Load Balancer)
  • MariaDB Connectors
    • MariaDB Connector/C++
    • MariaDB Connector/R2DBC (Reactive Relational Database Connectivity, Java?)
    • MariaDB Connector/ODBC
    • MariaDB Connector/Python
    • MariaDB Connector/Node.js
  • MariaDB integration connectors
    • Kafka
    • Spark
    • Pentaho Kettle
    • Power BI
  • MariaDB tools
    • IDERA SQL Diagnostic Manager
    • SQLyog Ultimate
  • MariaDB Support

MariaDB Enterprise Server Features

MariaDB Enterprise Server comes with more features than MariaDB Community Server:

  • Enterprise Cluster
  • Enterprise Audit
  • Enterprise Federation
  • Xpand Storage Engine
  • Hashicorp Vault
  • InnoDB enhancements
  • Replication enhancements
  • MariaDB Enterprise Backup
    • Non-blocking backup (also in MariaDB 10.6 CE)
  • Enterprise backports
  • Some Bug Fixes are postponed in CS (no hard proof yet)?

MariaDB Enterprise InnoDB Features

  • Dynamically Resizing the InnoDB Redo Log ( Link )
  • Dynamically Changing the Number of InnoDB Purge Threads ( Link )
  • Dynamically Changing the Number of InnoDB I/O Threads ( Link )
  • Limitation of 128 secondary indexes (vs. 64 in Community Server) for Enterprise InnoDB ( Link )

MariaDB Enterprise Replication Features

  • Replication-Aware Shutdowns: shutdown_wait_for_slaves ( Link )

MariaDB Enterprise Galera Features

  • none?

MariaDB Server Fest 2021, Q&A session

Monty Widenius – MariaDB Foundation: The curious case of the disappearing commercial database

Oli Sennhauser - 14:19
What is your opinion of MariaDB EE binaries which are already slightly different to CE binaries...?

Kaj Arnö - 14:20
We in the MariaDB Foundation put our energy into MariaDB Server – sometimes called Community Server by the Corporation

Michael Widenius - 14:20
For the latest release EE and CE are basically the same. As long as you are running the latest or second latest MariaDB CS server, then there is no notable differences.
One main difference is that the ES server is released a few weeks after the community server to do additional testing (both internally and from the community), which makes the ES releases a bit more stable

Oli Sennhauser - 14:22
You are calling this: "no notable differences":
Dynamically Resizing the InnoDB Redo Log ( Link )
Dynamically Changing the Number of InnoDB Purge Threads ( Link )
Dynamically Changing the Number of InnoDB I/O Threads ( Link )
Limitation of 128 secondary indexes (vs. 64 in Community Server) for Enterprise InnoDB ( Link )
Replication-Aware Shutdowns: shutdown_wait_for_slaves ( Link )
Non blocking backup

Oli Sennhauser - 14:22
This list not complete for sure yet...

Michael Widenius - 14:22
The non blocking backup is also in 10.6

Marko Mäkelä - 14:22
The corporation calls its available-to-customers-only open-source product Enterprise Server. For InnoDB, I think that the main ES-only feature is allowing redo log resizing without restart. For higher-level components there is more room for differentiation; I have not checked how much we actually differ. The purge threads can be changed in 10.7 (MDEV-26520).

Michael Widenius - 14:22
Most of the other things are small, not critical changes.

Marko Mäkelä - 14:24
The 128 secondary indexes is only a build option. You can build from source.
The I/O threads, maybe @Vladislav Vaintroub can comment on that one. Why would one want to use a smaller number?

Michael Widenius - 14:24
For older ES releases, there are backports of features from newer releases to older releases to allow customers to get access to new features without having to upgrade to a new main release. I think this is the most valuable aspect of ES

Michael Widenius - 14:29
Olivier, note that if you know anyone that us using the ES binary, you can get a copy of it and the source if you just ask. It is GPL after all...

Literature