I run a Magento CE store with 3 DB servers (galera cluster). When upgrading Magento from 2.3.4 to Magento 2.4.6, also upgraded MariaDB from 10.4 to 10.6, and PHP from 7.4 to 8.1, to match Magento System Requirements.
Latest version in MariaDB repo was 10.6.13. Magento did not like the latest MariaDB and threw exception "This version of MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)'"
Whats going on? How do I fix this?