MariaDB MariaDB 10.4.3 now available

eva2000 · Feb 26, 2019

Release date: 25 Feb 2019

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.3 is a Release Candidate release.

Do not use non-stable (non-GA) releases in production!

For an overview of MariaDB 10.4 see the What is MariaDB 10.4? page.
Click to expand...

Notable Changes
Notable changes of this release include:

MDEV-12484: The unix_socket authentication plugin is now default on Unix-like systems, which is a major change to authentication in MariaDB

MDEV-7597: User password expiry

MDEV-6111: Implementation of the optimizer trace, one can enable the optimizer trace by enabling the system variable optimizer_trace

MDEV-18551: The default for eq_range_index_dive_limit is now 200 (previously 0)

MDEV-17903: The optimizer switch flag optimize_join_buffer_size now defaults to on

New optimizer switch flags rowid_filter and condition_pushdown_from_having

MDEV-18439: core_file on Windows now defaults to ON

MDEV-18608: Histograms are now collected by default.

MDEV-13916: The JSON_VALID function is automatically used as a CHECK constraint for the JSON data type alias in order to ensure that a valid json document is inserted

MDEV-18564: wsrep_load_data_splitting is deprecated and now set to OFF by default

analyze_sample_percentage system variable

InnoDB ALTER TABLE fixes: MDEV-18222, MDEV-18256, MDEV-18016, MDEV-18295, MDEV-16849, MDEV-18219

Mariabackup fixes: MDEV-18194, MDEV-18415, MDEV-18611

New InnoDB features:

MDEV-12026: Implement innodb_checksum_algorithm=full_crc32

MDEV-15563: More Instant VARCHAR extension

MDEV-15564: Instant collation or charset changes for non-indexed columns

MDEV-16188: Use in-memory PK filters built from range index scans

Changelog
For a complete list of changes made in MariaDB 10.4.3, with links to detailed information on each push, see the changelog.

Contributors
For a full list of contributors to MariaDB 10.4.3, see the MariaDB Foundation release announcement.
Click to expand...

The post MariaDB 10.4.3 now available appeared first on MariaDB.org.

Continue reading...

eva2000 · Mar 19, 2019

Started prepping for MariaDB 10.4 support Beta Branch - prep for MariaDB 10.4 support in 123.09beta01

Code (Text):

mysqladmin ver                 
mysqladmin  Ver 9.1 Distrib 10.4.3-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.4.3-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 min 14 sec

Threads: 4  Questions: 2  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.027

eva2000 · Mar 19, 2019

Looks like MariaDB 10.4.3 has some new changes to password authentication too - The unix_socket authentication plugin is installed by default from MariaDB 10.4.3 Authentication Plugin - Unix Socket

The unix_socket authentication plugin allows the user to use operating system credentials when connecting to MariaDB via the local Unix socket file. This Unix socket file is defined by the socket system variable.

The authentication plugin works by calling the getsockopt system call with the SO_PEERCRED socket option, which allows it to retrieve the uid of the process that is connected to the socket. It is then able to get the user name associated with that uid. Once it has the user name, it will authenticate the connecting user as the MariaDB account that has the same user name.

Disabling the Plugin
The unix_socket authentication plugin is installed by default from MariaDB 10.4.3, as well as in new installs of Ubuntu 15.10 and later, and Debian. It can be disabled from MariaDB 10.4.3 by starting the server with the --disable-unix-socket option.
Click to expand...

Log in / Register

Forums

Join the community today

MariaDB MariaDB 10.4.3 now available

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Join the community today

MariaDB MariaDB 10.4.3 now available

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

.