Differences in MariaDB Enterprise Server 10.6

MariaDB Enterprise Server is a premium version of MariaDB Community Server that focuses on stability, robustness, and predictability. For more information about MariaDB Enterprise Server in general please look here.

In addition to different release cycle, QA, and etc..., there are also feature differences. MariaDB Enterprise Server has different default settings to be more secure from the start and also only includes features that are fully supported and maintained.

In addition to this there are Enterprise Features and some backported features. The following are features that are in MariaDB Enterprise Server 10.6 but not in MariaDB Community Server 10.6:

Enterprise Features:

• MariaDB Backup

• MariaDB Enterprise Audit

• Index limit increased to 128 indexes

• Slow master shutdown as default

• MariaDB Enterprise Cluster (powered by Galera)

  • Enhanced Enterprise Data-at-Rest Encryption

  • XA Support

  • Non-Blocking operation for DDLs

  • TLS certificate expiration monitoring

  • SSL/TLS enabled by default

• Hashicorp Vault Plugin

• Dynamic resize of InnoDB redo log

• Dynamic change of InnoDB purge threads

• Sybase SQL mode for extended aliases

Backported Features:

• mariadb-dump option --as-of to dump data as of a given time for system versioned tables

• JSON functions

  • JSON_NORMALIZE

  • JSON_EQUALS

  • JSON_OVERLAPS

  • JSON_SCHEMA_VALID

  • JSON_ARRAY_INTERSECT

  • JSON_OBJECT_TO ARRAY

  • JSON_OBJECT_FILTER_KEYS

  • JSON_KEY_VALUE

• Password Reuse Prevention Plugin

• Datatype Plugin UUID

• CONVERT_PARTITION / CONVERT_TABLE

• Option for SQL thread to limit maximum execution time per query

• Allow innodb_undo_tablespaces to be changed after database creation

• Make the optimizer handle UCASE(varchar_col)=...

• Easier way to retrieve all users that have privileges on a specific table

• Make s3_debug dynamic

• Add timezone information to DATE_FORMAT

• Autoshrink option for innodb_data_file_path system variable

• New, Detailed Replication Lag Representation

• New Information Schema Table For Password Related Data

• GTID binlog events now include the thread ID