[#37195] - MariaDB and Galera cluster 10.5
- Closed
- 4 Mar 2022
- Medium
- Build: 3.10.6
- # 37195
Starting from MariaDB version 10.5 and higher, within the Galera database cluster, Joomla 3.10.6 does not work correctly with the entry in the database. At any attempts to make changes from the site, an error message appears (see screenshot) and the DB node drops out of the cluster.
at 10.5, 10.6 it works only as single node mode.
at 10.4 works both single and cluster.
was no any logs at Galera, so nothing to attach.
| Labels |
Removed:
?
|
||
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
|
||
oh, we totaly miss this moment. Got it, thank you.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2022-03-04 08:55:10 |
| Closed_By | ⇒ | HLeithner |
The problem shouldn't be MariaDB, my servers using percona-server without problems.
But the cluster setup needs special attention which is hard to support if since we don't have a test system. So as long as nobody came up and help us on this topic we can't support database clusters.
I'm closing this for the moment. if you like to help you can reopen the issue at anytime.
PS: sooner or later we need a mariadb specific database driver but I would expect that wouldn't solve the cluster problem.
PS: sooner or later we need a mariadb specific database driver but I would expect that wouldn't solve the cluster problem.
I'm totally agree as @alikon wrote here #34847 (comment) and here #36183 (comment)
From MariaDB 10.5 (and 10.6) the fork between it and MySQL began to be more and more relevant...
MariaDB is not officially supported and only MySQL is https://downloads.joomla.org/technical-requirements
In the early days of the fork there was not much difference, as time goes on the two products will diverge more and more.
At the moment this is not a Joomla issue, because it doesn't fall under the remit of "supported server software"...
3 years ago @mbabker stated on twitter "Theoretically, as long as any MySQL "drop in replacement" remains compatible with MySQL features & C libraries that PHP uses (MariaDB or Percona as 2 big examples, and yes I did have a deployment on Percona for a bit), any of them can be used as a backend for Joomla without issue"
3 years is a long time.