The Ultimate Guide to High Availability with MariaDB

Changes & Improvements in MariaDB 10.3

You are viewing an old version of this article. View the current version here.

The most recent release of MariaDB 10.3 is:
MariaDB 10.3.39 Stable (GA) Download Now

Contents

  1. Implemented Features
    1. Syntax / General Features
    2. Compatibility
    3. Compression
    4. Encryption
    5. Optimizer
    6. Storage engines
      1. Spider engine
      2. Partition engine
    7. Logging
    8. Global-transaction ID
    9. Data type API
    10. Idle transactions
    11. System Variables
  2. Security Vulnerabilities Fixed in MariaDB 10.3
  3. Comparison with MySQL
  4. List of All MariaDB 10.3 Releases
  5. See Also

MariaDB 10.3 is the current major development version.

Do not use alpha releases in production!

The following lists the major new features in MariaDB 10.3:

Implemented Features

Syntax / General Features

Compatibility

Compression

Encryption

  • Temporary files created by merge sort and row log are encrypted if innodb_encrypt_log is set to 1, regardless of whether the table encrypted or not (MDEV-12634).

Optimizer

Storage engines

Spider engine

Spider storage engine has been updated to 3.3.13. The partitioning storage engine has been updated to support all the new Spider features like:

  • Direct join support. This allows Spider to do JOINS and GROUP BY internally
  • Direct update and delete
  • Direct aggregates
  • slave_transaction_retry_errors and slave-transaction-retry-interval allows ones more control for handling delays or conflicts when applying binary logs

Most of the features was done as part of MDEV-7698.

Partition engine

  • Full text support
  • Multi-range-read (Gives better performance when having to multiple ranges)
  • Support for condition pushdown

Logging

Global-transaction ID

  • New system variable gtid_pos_auto_engines for improving performance if a server is using multiple different storage engines in different transactions (MDEV-12179)

Data type API

10.3 continues refactoring for the data type API started in 10.2, which will make it possible to have user data type plugins. This work is still in progress (see MDEV-4912 for the current status and subtasks). Most of the task in this category do not change the server behavior. Some tasks do have a visible effect.

Idle transactions

Connections with idle transactions can be automatically killed after a specified time period by means of the idle_transaction_timeout, idle_readonly_transaction_timeout and idle_write_transaction_timeout system variables.

System Variables

For a list of all new variables, see System Variables Added in MariaDB 10.3 and Status Variables Added in MariaDB 10.3.

Comparison with MySQL

List of All MariaDB 10.3 Releases

DateReleaseStatusRelease NotesChangelog
9 Oct 2017MariaDB 10.3.2AlphaRelease NotesChangelog
29 Aug 2017MariaDB 10.3.1AlphaRelease NotesChangelog
16 Apr 2017MariaDB 10.3.0AlphaRelease NotesChangelog

See Also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.