Release Notes for MariaDB Enterprise Server 10.4.6-1

New Features

• MariaDB Enterprise Backup with support of non-blocking Backups

• Backup Stages for non-blocking Backups

• MariaDB Enterprise Audit Plugin

  • Per user filters using system tables

  • Audit of AUDIT plugin configuration changes

• Maximum number of secondary indexes increased to 128 per table

• Tracing facility for the Optimizer

• Slow master shutdown option

• Data-at-Rest Encryption for MariaDB Enterprise Cluster transaction logs

• Instant schema changes for a variety of ALTER TABLE statements with InnoDB

• Password expiration

• Account locking via SQL

• Account blocking based on number of failed connects

• MariaDB Enterprise Cluster based on Galera 4

  • Streaming replication (huge transactions) for MariaDB Cluster

  • Support of group commit in the binary log

  • New causal reads functions

  • Donor selection based on Incremental State Transfer status

  • Persistent cluster/group information

• Application-time period temporal tables (FOR PORTION OF)

• System-versioned Application-time period tables (Bitemporal)

• Key rotation for InnoDB REDO log encryption

• Encryption for spatial indexes with InnoDB

• FLUSH SSL to reload SSL certificates

• Crash-safe system tables based on Aria storage engine

New Default Settings

A new Enterprise config file is provided that sets optimized defaults:

• Server does not load plugins of maturity Beta or lower

• Authentication plugin ed25519 is loaded by default

• Account root is using unix_socket by default on Linux systems

• Accounts for root can only connect from local host

• Accounts of type anonymous-user removed

• Database "test" has no default grants

• simple_password_check plugin is activated by default with settings:

  • simple_password_check_minimal_length = 8

  • simple_password_check_digits = 1

  • simple_password_check_letters_same_case = 1

  • simple_password_check_other_characters = 1

• Audit plugin is loaded by default, but is not activated

• DISKS plugin is loaded by default on Linux systems

• Engine independent table statistics enabled by default

• Histograms collected by default

• optimize_join_buffer_size=on by default

• JSON validation by default for JSON type fields

Notable Changes

• SET PASSWORD is now plugin-agnostic

• DISKS plugin, used by MariaDB MaxScale, is now of maturity stable

• Access to data provided by DISKS plugin via the information schema requires FILE privilege

• Unsupported Community plugins are not loaded by default

• Embedded Server removed

• HeidiSQL is not included in Windows installations

• MariaDB Server is now statically linked with the bundled wolfSSL library in MSI and ZIP packages on Windows, as well as in .deb packages provided by Debian's and Ubuntu's default repositories

• MariaDB Named Commands

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.4.6-1 is provided for:

• CentOS 7

• CentOS 6

• Debian 9

• Debian 8

• Red Hat Enterprise Linux 7

• Red Hat Enterprise Linux 6

• Ubuntu 18.04

• Ubuntu 16.04

• Microsoft Windows

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "MariaDB Corporation Engineering Policies".

Installation Instructions

• MariaDB Enterprise Server 10.4

• Enterprise Cluster Topology with MariaDB Enterprise Server 10.4

• Primary/Replica Topology with MariaDB Enterprise Server 10.4

• Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.4

• Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.4

Upgrade Instructions

• Upgrade to MariaDB Enterprise Server 10.4

• Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4