Upgrade MariaDB to 10.6 or higher

[darenwelsh]

Per the Full-Text Index Overview (mariadb.com), we need to upgrade versions of MariaDB to make use of full text search. This is useful for Cargo (see Cargo docs) to be able to use the Searchtext data type and to be able to search _fullText in pageData.

Support of MariaDB 5.5 ends April 2020. Per the same link, 10.0 is no longer supported. 10.4 is the current stable release, supported until June 2024.

References for migration from 5.5 to 10.4:

• https://mariadb.com/kb/en/upgrading-from-mariadb-55-to-mariadb-100/
• https://www.mysterydata.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/

[freephile]

With a fresh install of 34.x on Debian 10 (buster) I get MariaDB 10.3.22, seemingly without any problems or migration needed. I'll check into what it would take to bump the version to 10.4 (for CentOS and Debian)

[jamesmontalvo3]

From @revansx on duplicate issue #1295:

CENTOS7/RHEL7 only offers MariaDB 5.5 by default whereas MariaDB itself is at v10.6.

MariaDB.com has instructions [1] on how to upgrade the CENTOS7/RHEL7 repos to use the latest version of MariaDB and says that there are significant performance improvements. Does anyone know of any reason why we would keep meza at mariadb 5.5 if 10.6 is possible?

[1] https://mariadb.com/resources/blog/installing-mariadb-10-on-centos-7-rhel-7/