MariaDB 10.6.5 released

[JSEHV]

Hopefully this can be implemented into Nethserver 7.9
We really need a more up-to-date version of MariaDB.

Notable changes in MariaDB 10.6.5

InnoDB

• Linux after kernel version 5.10 has a io-uring regression causing a write to storage to be lost, or not acknowledged. As such innodb_use_native_aio will default to 0 (off) until 5.16. If innodb_use_native_aio is enabled in your configuration, a warning will be logged, however it will continue with the io-uring enabled, potentially resulting in a hang, or an assertion later. The long term support kernel 5.14.14 we haven’t observed failures, and 5.15.0-rc7 failures have been observed, though less frequently. If you have innodb_use_native_aio explicitly enabled, and are using watch out for a lack of InnoDB updates followed by a 10 minute timeout. See MDEV-26674for details.
• ALTER TABLE…IMPORT TABLESPACE fixes (MDEV-18543, MDEV-20931, MDEV-26131, MDEV-26621)
• innodb_undo_log_truncate fixes (MDEV-26445, MDEV-26450, MDEV-26672, MDEV-26864)
• Page I/O performance fixes (MDEV-25215, MDEV-26547, MDEV-26626, MDEV-26819)
• Replication timeouts with XA PREPARE (MDEV-26682)
• Improved DDL and data dictionary (MDEV-25919)
• Performance fixes (MDEV-26356, MDEV-26467, MDEV-26826)

Replication

• Memory hogging on slave by ROW event applier is eliminated (MDEV-26712)
• mysql --binary-mode now properly handles \\0 in data (MDEV-25444)
• Fixes race condition between SHOW BINARY LOGS and RESET MASTER (MDEV-20215)

Packaging & Misc

• Session tracking flag in OK_PACKET (MDEV-26868)
• Some views force server (and mysqldump) to generate invalid SQL for their definitions (MDEV-26299)

Full Changelog

MariaDB 10.6.5 Changelog

[pike (Michael Kicks)]

Hi @JSEHV, are you aware of a soon implementation on RHEL/CentOS 7 from RedHat?

[Andy_Wismer (André Wismer)]

Hi

With the latest implementation of NC in NethServer, 10.5 is being used, not the very old included version of Centos7…

MariaDB 10.6.5 will come, eg if NC needs it…

See /opt/rh/ for this…

My 2 cents
Andy

[JSEHV]

Great, 10.5 is already a good step forward, 10.6.5 will make it eventually.

But can I use that version 10.5 with the build in webserver (eg. Wordpress of other database enabled websites)? As far as I know at the moment for the webserver part I have to really on the old one.

It would be very nice if we are able to select the MariaDB version in the same way as we are now able to select the PHP version.

[Andy_Wismer (André Wismer)]

MariaDB 10.5 can be used for any thing else you want.
Even a second PHPmyAdmin is possible, I just can’t remeber the link here to implement it.

You just need to make sure backups et Al are covered!

There are Docs here in the Forum about mariadb 10.5 just search…

NextCloud uses it, and does it’s backup in the usual place:
/var/lib/nethserver/backup/rh-mariadb105/

Set your backups to land there, and they’ll be taken care off with NethServers built in backup.

My 2 cents
Andy

[stephdl (Stéphane de Labrusse)]

Mariadb105 is the only answer we could do IIRC, not sure we will have more recent version but ns8 could answer to that need…start a container with the version you need.

Actually docker can do it with ns7 but you are on your own.