I’ve succesfully installed Mediawiki 1.31 in Ubuntu 16.04 using a 3 machine percona mysql cluster (5.7.22).
The cluster seems to be working ok, but when installation wizard is about to finish, this error appears.
No se pudo insertar la página principal: A database query error has occurred. Did you forget to run your application’s database schema updater after upgrading? Query: SELECT GET_LOCK(‘695f25141b5213ec078ceed7dbde8264bc651753’, 30) AS lockstatus Function: ApiStashEdit::checkCache Error: 1105 Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING (10.0.2.80)
I’ve reported this on Mediawiki site and following recommendations of Bawolff I put pxc-strict-mode=PERMISSIVE for the last part of the installation and everything was ok.
I would like to know if someone here has had some experience on installing Mediawiki using this cluster. Can anybody say if Mediawiki installation is compatible with Percona xtradb cluster?
Maybe there are other situations (extension installation which modifies database, upgrading,…) when get lock or other Percona limitation is needed.