Release Notes for MariaDB Xpand 6.0.4


MariaDB Xpand is a distributed SQL database.

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 a hang or crash

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

Can result in unexpected behavior

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

Interface Changes

Added System Variables

System Variable





Specify how long a password is valid before requiring the user to change the password. Off 0 by default



Xpand will not permit connecting if the password is expired



Enable/disable simple_password_check password requirements validation



Specify the minimum required number of digits in a password being validated with simple_password_check



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.



Specify the minimum required number of characters (length) in a password being validated with simple_password_check



Specify the minimum required number of other characters (special characters, not letters or digits) in a password being validated with simple_password_check



Disallows passwords from being set with hashes when simple_password_check is enabled

Installation Instructions

Upgrade Instructions