# Testing Cluster with Mediawiki

**URL:** <https://forums.percona.com/t/testing-cluster-with-mediawiki/6482>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 27, 2018, 7:07am UTC](https://forums.percona.com/t/testing-cluster-with-mediawiki/6482 "2018-07-27T07:07:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Juan\_Jose\_Alonso](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/juan_jose_alonso/32/3153_2.png) [@Juan\_Jose\_Alonso](https://forums.percona.com/u/Juan_Jose_Alonso)\
**Post date:** [July 27, 2018, 7:07am UTC](https://forums.percona.com/t/testing-cluster-with-mediawiki/6482/1 "2018-07-27T07:07:43Z")

</div>

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](https://www.mediawiki.org/wiki/User:Bawolff) I put pxc-strict-mode=PERMISSIVE for the last part of the installation and everything was ok.

[url][https://www.mediawiki.org/wiki/Topic:Uhmprgtvts7q5972[/url]](https://www.mediawiki.org/wiki/Topic:Uhmprgtvts7q5972%5B/url%5D)

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.

Thanks!

Juanjo

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [August 8, 2018, 6:56am UTC](https://forums.percona.com/t/testing-cluster-with-mediawiki/6482/2 "2018-08-08T06:56:14Z")

</div>

Hello Juanjo,

Indeed the explicit table locks like GET\_LOCK, are not supported by Galera replication and in some cases may lead to unexpected issues, like cluster stalls.  
This is explained in Galera upstream documentation:  
[URL][http://galeracluster.com/documentation-webpages/limitations.html#table-locking[/URL]](http://galeracluster.com/documentation-webpages/limitations.html#table-locking%5B/URL%5D)  
and the PXC Strict Mode Percona introduced helps to avoid such unsafe things by either blocking them or logging warnings (in permissive mode). More details: [URL=“[Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html#explicit-table-locking)”][Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html#explicit-table-lockin%5B/URL%5Dg)

I understand there are some places in MediaWiki code that still use GET\_LOCK. In that case, it would be best if such occurrences could be removed or replaced with other solution.  
Please note that such code change would allow not only MediaWiki use with PXC but also with MySQL InnoDB Cluster (Group Replication) - check the similar limitations notes here:  
[URL][https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html[/URL]](https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html%5B/URL%5D)

Till then, to minimize the chance for issues, please use only one PXC node as writer.