MariaDB 10.11.0 preview release now available

We are pleased to announce the preview release of the MariaDB 10.11 series, MariaDB 10.11.0.

Candidate features for MariaDB 10.11

Preview releases are designed to get features into the hands of users more quickly, and should not be used for production. Not all features in a preview release may make the Generally Available (GA) release. Features under consideration for 10.11 include:

Authentication

  1. GRANT … TO PUBLIC (MDEV-5215)
  2. Separate SUPER and READ ONLY ADMIN privileges (MDEV-29596)

Optimizer

  1. Semi-join optimization for single-table update/delete statements (MDEV-7487)
  2. Allow pushdown of queries involving UNIONs in outer select to foreign engines (MDEV-25080)
  3. Make ANALYZE FORMAT=JSON show time spent in the query optimizer (MDEV-28926)

Information Schema

  1. Performance Issues reading the Information Schema Parameters table (MDEV-29104)
  2. Full table scan in the Information Schema Parameters and Information Schema Routines table (MDEV-20609)

System versioning

  1. System versioning setting, system_versioning_insert_history, to allow history modification (MDEV-16546)
  2. mariadb-dump: dump and restore historical data (MDEV-16029)

Windows

  1. Windows – passwordless login for mariadb root user, for OS admin users (MDEV-26715)

Miscellaneous

  1. Rename slow queries variables (MDEV-7567)
  2. Variable replicate_rewrite_db cannot be found in “show global variables” (MDEV-15530)
  3. innodb_write_io_threads and innodb_read_io_threads are now dynamic, and their values can be changed without restarting the server (MDEV-11026)

The features that pass testing will then be merged into MariaDB Server 10.11.1.

MariaDB 10.9.3, 10.8.5, 10.7.6 and 10.6.10 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.3, MariaDB 10.8.5 and MariaDB 10.7.6, the latest Generally Available releases in their respective short-term support series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.10 the latest stable release in the 10.6 long-term support series (maintained for five years).

These releases fix critical regressions found in the previous releases. See the release notes and changelogs for details.


Download MariaDB 10.9.3

Release Notes Changelog What is MariaDB 10.9?

MariaDB 10.10.1 RC and 10.9.2 GA now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.10.1, the first release candidate in the MariaDB 10.10 series, and MariaDB 10.9.2 the first generally available release in the MariaDB 10.9 series. These are both short-term support series, maintained for one year after GA.

See the release notes and changelogs for details.


Download MariaDB 10.10.1

Release Notes Changelog What is MariaDB 10.10?


Download MariaDB 10.9.2

Release Notes Changelog What is MariaDB 10.9?

MariaDB 10.8.4, 10.7.5, 10.6.9, 10.5.17, 10.4.26 and 10.3.36 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.4 and MariaDB 10.7.5, the latest Generally Available releases in their respective short-term support series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.9, MariaDB 10.5.17, MariaDB 10.4.26, MariaDB 10.3.36 the latest stable releases in their respective long-term support series (maintained for five years).

See the release notes and changelogs for details. Note that repo mirrors may take some time to sync.


Download MariaDB 10.8.4

Release Notes Changelog What is MariaDB 10.8?

MariaDB 10.10 preview releases now available

We are pleased to announce the fourth MariaDB series release under the new release model, MariaDB 10.10.0.

Maturing MariaDB more quickly

One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time.

Candidate features for MariaDB 10.10

There are four separate preview releases, containing the following features under consideration for release in 10.10.1:

Replication

  1. Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it (MDEV-19801)
  2. Deprecate MASTER_USE_GTID=Current_Pos to favor new MASTER_DEMOTE_TO_SLAVE option (MDEV-20122)

Optimizer

  1. Improve optimization of joins with many tables, including eq_ref tables (MDEV-28852)
  2. * Table elimination does not work across derived tables (MDEV-26278)

UCA14 Collation

  1. Add UCA-14.0.0 collations (MDEV-27009)
  2. Improve contraction performance in UCA collations (MDEV-27265)
  3. Improve UCA collation performance for utf8mb3 and utf8mb4 (MDEV-27266)

DDL

  1. ALTER ONLINE TABLE (MDEV-16329)
  2. Atomic CREATE OR REPLACE TABLE (MDEV-25292)

Galera

  1. Implement a method to add IPs to allowlist for Galera Cluster node addresses that can make SST/IST requests (MDEV-27246)

Miscellaneous

  1. Change default of explicit_defaults_for_timestamp to ON (MDEV-28632)
  2. –ssl option set as default for mariadb CLI (MDEV-27105)
  3. Add RANDOM_BYTES function (MDEV-25704)
  4. The INET4 data type (MDEV-23287)
  5. Re-design the upper level of handling UPDATE and DELETE statements (MDEV-28883)
  6. Deprecate the DES_ENCRYPT/DECRYPT functions (MDEV-27104)

On the download page for 10.10.0, you will see sources in Linux (x86-64 bintar) and source formats only.

MariaDB 10.9.1, 10.8.3, 10.7.4, 10.6.8, 10.5.16, 10.4.25, 10.3.35 and 10.2.44 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.1, the first Release Candidate (RC) in the MariaDB 10.9 series, MariaDB 10.8.3, the first Generally Available (GA) release in the MariaDB 10.8 series, MariaDB 10.7.4, the second Generally Available release in the MariaDB 10.7 series (all maintained for one year from their first GA release dates), as well as MariaDB 10.6.8, MariaDB 10.5.16, MariaDB 10.4.25, MariaDB 10.3.35 and MariaDB 10.2.44, the latest stable releases in their respective series. …

MariaDB 10.9 preview releases now available

We are pleased to announce the third MariaDB series release under the new release model, MariaDB 10.9.0.

Maturing MariaDB more quickly

One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time.

Candidate features for MariaDB 10.9

There are four separate preview releases, containing the following features under consideration for release in 10.9.1:

SHOW ANALYZE FORMAT=JSON

  1. Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
  2. Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN (MDEV-10000)

JSON Range Notation

  1. Implement range notation for JSONPath (MDEV-27911)
  2. Support JSONPath negative index (MDEV-22224)
  3. JSON_OVERLAPS function (MDEV-27677)

Async redo log write

  1. Asynchronous redo log write (MDEV-26603)

Miscellaneous

  1. Implement the –do-domain-ids, –ignore-domain-ids, and –ignore-server-ids options for mysqlbinlog (MDEV-20119)
  2. information_schema.tables.table_type now shows TEMPORARY
    for local temporary tables.

MariaDB 10.8.2 RC and MariaDB 10.7.3, 10.6.7, 10.5.15, 10.4.24, 10.3.34 and 10.2.43 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.2, a release candidate in the MariaDB 10.8 series, MariaDB 10.7.3, a Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.7, MariaDB 10.5.15, MariaDB 10.4.24, MariaDB 10.3.34 and MariaDB 10.2.43, the latest stable releases in their respective series.

These primarily fix a problem in last week’s releases when manually running mariadb-upgrade. See MDEV-27789, and the release notes and changelogs for details. …