MariaDB 10.11 Archives - Page 2 of 2

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.1, the first release candidate in the MariaDB 10.11 series, and MariaDB 10.10.2 the first generally available release in the short-term MariaDB 10.10 series.

See the release notes and changelogs for details.

Download MariaDB 10.11.1

Release Notes Changelog What is MariaDB 10.11?

Download MariaDB 10.10.2

Release Notes Changelog What is MariaDB 10.10?

MariaDB APT and YUM Repository Configuration Generator

Contributors to MariaDB 10.11.1

Addison G
Aleksey Midenkov (MariaDB Corporation)
Alexander Barkov (MariaDB Corporation)
Alexey Botchkov (MariaDB Corporation)
Andrei Elkin (MariaDB Corporation)
Andrew Hutchings (MariaDB Foundation)
Anel Husakovic (MariaDB Foundation)
Angelique Sklavounos (MariaDB Corporation)
anson1014
Brad Smith
Brandon Nesterenko (MariaDB Corporation)
Daniel Bartholomew (MariaDB Corporation)
Daniel Black (MariaDB Foundation)
Daniele Sciascia (Codership)
Dmitry Shulga (MariaDB Corporation)
Elena Stepanova (MariaDB Corporation)
Haidong Ji (Amazon)
Hartmut Holzgraefe (MariaDB Corporation)
Ian Gilfillan (MariaDB Foundation)
Igor Babaev (MariaDB Corporation)
Jan Lindström (MariaDB Corporation)
Julius Goryavsky (MariaDB Corporation)
kurt
Lawrin Novitsky (MariaDB Corporation)
Lena Startseva (MariaDB Corporation)
Luis Eduardo Oliveira Lizardo
Marko Mäkelä (MariaDB Corporation)
Michael Qin (Amazon)
Michael Widenius (MariaDB Corporation and MariaDB Foundation)
Mikhail Chalov
Nayuta Yanagisawa
Nikita Malyavin (MariaDB Corporation)
NTH19
Oleg Smirnov
Oleksandr Byelkin (MariaDB Corporation)
Otto Kekäläinen
Paragoumba
qggcs
rmfalves
Rucha Deodhar (MariaDB Corporation)
sawasa
Sergei Golubchik (MariaDB Corporation)
Sergei Petrunia (MariaDB Corporation)
Thirunarayanan Balathandayuthapani (MariaDB Corporation)
tmokmss
Tuukka Pasanen
Vicențiu Ciorbaru (MariaDB Foundation)
Vladislav Vaintroub (MariaDB Corporation)
Vlad Lesin
Zhibo Zhang
50 Contributors

Contributors to MariaDB 10.10.2

Addison G
Aleksey Midenkov (MariaDB Corporation)
Alexander Barkov (MariaDB Corporation)
Alexey Botchkov (MariaDB Corporation)
Andrei Elkin (MariaDB Corporation)
Andrew Hutchings (MariaDB Foundation)
Anel Husakovic (MariaDB Foundation)
Angelique Sklavounos (MariaDB Corporation)
anson1014
Brad Smith
Brandon Nesterenko (MariaDB Corporation)
Daniel Bartholomew (MariaDB Corporation)
Daniel Black (MariaDB Foundation)
Daniele Sciascia (Codership)
Dmitry Shulga (MariaDB Corporation)
Elena Stepanova (MariaDB Corporation)
Haidong Ji (Amazon)
Ian Gilfillan (MariaDB Foundation)
Igor Babaev (MariaDB Corporation)
Jan Lindström (MariaDB Corporation)
Julius Goryavsky (MariaDB Corporation)
kurt
Lawrin Novitsky (MariaDB Corporation)
Lena Startseva (MariaDB Corporation)
Marko Mäkelä (MariaDB Corporation)
Michael Widenius (MariaDB Corporation and MariaDB Foundation)
Mikhail Chalov
Nayuta Yanagisawa
Nikita Malyavin (MariaDB Corporation)
Oleg Smirnov
Oleksandr Byelkin (MariaDB Corporation)
Otto Kekäläinen
qggcs
Rucha Deodhar (MariaDB Corporation)
Sergei Golubchik (MariaDB Corporation)
Sergei Petrunia (MariaDB Corporation)
Thirunarayanan Balathandayuthapani (MariaDB Corporation)
tmokmss
Tuukka Pasanen
Vicențiu Ciorbaru (MariaDB Foundation)
Vladislav Vaintroub (MariaDB Corporation)
Vlad Lesin
Zhibo Zhang
43 Contributors

Thanks, and enjoy MariaDB! …

Continue reading “MariaDB 10.11.1 RC and 10.10.2 GA now available”

MariaDB 10.11.0, our latest preview release, features quite a number of improvements. The one we’ll talk about here is replicate-rewrite-db. This option has become a system variable from 10.11.0 based on MDEV-15530. Before this version it was just an option used by the mariadbd and mariadb-binlog binaries. There have been no behaviour changes with the option; it has simply become a dynamic variable.

How to try out this feature

The fastest way is to take MariaDB 10.11 for a spin in docker / podman (consult the blog mariadb-replication-using-containers) with the following commands:

To start a primary 10.11.0 MariaDB container, clone the directory, navigate to the cloned directory and run the following command:

docker run -d –rm –name mariadb-primary \
-v $PWD/config-files/primarycnf:/etc/mysql/conf.d:z \
-v $PWD/primaryinit:/docker-entrypoint-initdb.d:z \
-v $PWD/log-files-primary:/var/lib/mysql \
-e MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=True \
quay.io/mariadb-foundation/mariadb-devel:10.11

To start the replica/secondary run the command to start the mariadbd process as well as specify the replicate-rewrite-db option on the command line:

docker run -d –rm –name mariadb-secondary-1 \
-v $PWD/config-files/secondary-1:/etc/mysql/conf.d:z \
-v $PWD/secondaryinit:/docker-entrypoint-initdb.d:z \
-v $PWD/log-files-secondary-1:/var/lib/mysql \
-e MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=True \
quay.io/mariadb-foundation/mariadb-devel:10.11 –replicate-rewrite-db=’db1->db2′

Besides specifying the option as a command line argument, you can use a configuration file.

…

Continue reading “replicate_rewrite_db as a system variable in MariaDB”

MariaDB 10.11.0, our latest preview release, features quite a number of improvements. The one we’ll talk about today is GRANT … TO PUBLIC.

Background

MariaDB has quite a complex privilege system. Most of it is based on the SQL Standard spec; however we do have some specific MariaDB extensions. GRANT … TO PUBLIC (MDEV-5215) is a standard feature that is now available as a preview in MariaDB 10.11.0. It is related to ROLES and DEFAULT ROLE, but it covers a different use case.

ROLES are effectively “privilege packages” that you can enable and disable as a user.

…

Continue reading “GRANT TO PUBLIC in MariaDB”

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

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

Optimizer

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

Information Schema

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

System versioning

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

Windows

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

Miscellaneous

Rename slow queries variables (MDEV-7567)
Variable replicate_rewrite_db cannot be found in “show global variables” (MDEV-15530)
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.

…

Continue reading “MariaDB 10.11.0 preview release now available”