MDEV-33750: Sync configuratons from Debian Salsa

[illuusio]

• [x] The Jira issue number for this PR is: MDEV-33750

Description

Sync configurations and changes from Debian Salsa. This is mostly same as PR #2778 as it stalled and closed but these commits can be ironed to be valuable addition.

Release Notes

These commits does not affect release notes.

How can this PR be tested?

There is Salsa-CI run 655744 which will have some failing tests.

This could be test manually in Debian Sid with debian/autobake-debs.sh

and then manually installed.

Basing the PR against the correct MariaDB version

• [ ] This is a new feature and the PR is based against the latest MariaDB development branch.
• [x] This is a bug fix and the PR is based against the earliest maintained branch in which the bug can be reproduced.

PR quality check

• [x] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
• [x] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.

[fauust]

@illuusio, @grooverdan why is the CI not running for this PR? Since this PR impact starting and probably upgrading MariaDB on Debian/Ubuntu, you should make sure that install and upgrade (minor and major) tests pass on BB.

[ottok]

:+1: Unsurprisingly this PR looks good to me since it is upstreaming changes done in Debian in e.g.

• https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/a3b6f3d7f4b88074c76fe67d909977e74d8ba7a5
• https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/b935704063506b1581b297a80cdfe00deda65640
• https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/f2fe8d8300642c373ce325f19d1100d79adeed45
• https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/92c1748770506c9364fe67b8a3fbc1221d71653b
• https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/9787b43c9601a3e1e497d22140de13122277d5c3

Hope to see it merged soon!