Release Notes for MariaDB Xpand 6.0.4

Overview

MariaDB Xpand is a distributed SQL database that is part of MariaDB Enterprise.

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

Notable Changes

  • 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)

Issues Fixed

Can Result in Hang or Crash

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

Can Result in Unexpected Behavior

  • 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.

  • 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.

Install and Upgrade

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

Interface Changes

Added System Variables

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

Upgrade Instructions