Release Notes for MariaDB Xpand 6.0.4

Topics on this page:

Overview

MariaDB Xpand is a distributed SQL database.

MariaDB Xpand 6.0.4 was released on 2022-05-17.

Added support for simple password validation, including minimum length and optional enforcement of character variety, such as requiring digits and special characters within a password. This feature is equivalent to the simple_password_check plugin for MariaDB Server. (XPT-123)
Added support for password expiration. This feature is equivalent to user password expiry in MariaDB Server. (XPT-124)

Replication master crashes with OOM error when working on an especially large transaction.

A slave that is out of quorum could be erroneously reported as stopped. Commands issued to that slave could be either silently skipped or fail with the wrong error.
- Starting with this release, REPLICATION_RC_SLAVE_NID_DOWN is reported instead of the wrong error or silently doing nothing.
Unable to revoke OSAUTH privilege from users who have been granted SUPER privilege. (XPT-128)
- Starting with this release, OSAUTH can be revoked so users with SUPER privilege can be required to use a password to log in.
Replication metrics such as mariadb_xpand_replication_slave_enabled and mariadb_xpand_replication_slave_running are not returned when replication is stopped or deleted. (MDBM-3740)
- Prior to this release, it is sometimes impossible to distinguish the current state of replication via a statd request.
- Starting with this release, the metrics are included and values reflect the current state of replication.

When installing on a host without any routes in the default routing table, a stack trace may be generated.

System Variable	Default	Description
`default_password_lifetime`	0	Specify how long a password is valid before requiring the user to change the password. Off `0` by default
`disconnect_on_expired_password`	true	Xpand will not permit connecting if the password is expired
`simple_password_check`	false	Enable/disable `simple_password_check` password requirements validation
`simple_password_check_digits`	1	Specify the minimum required number of digits in a password being validated with `simple_password_check`
`simple_password_check_letters_same_case`	1	Specify the minimum required number of letters of the same letter case in a password being validated with `simple_password_check`. This limit is applied separately to upper-case and lower-case letters.
`simple_password_check_minimal_length`	8	Specify the minimum required number of characters (length) in a password being validated with `simple_password_check`
`simple_password_check_other_characters`	1	Specify the minimum required number of other characters (special characters, not letters or digits) in a password being validated with `simple_password_check`
`strict_password_validation`	true	Disallows passwords from being set with hashes when `simple_password_check` is enabled