# Percona XtraDB and Magento cron job failures

**URL:** <https://forums.percona.com/t/percona-xtradb-and-magento-cron-job-failures/17787>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [September 30, 2022, 1:38pm UTC](https://forums.percona.com/t/percona-xtradb-and-magento-cron-job-failures/17787 "2022-09-30T13:38:21Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![rj-db](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rj-db/32/7945_2.png) [@rj-db](https://forums.percona.com/u/rj-db)\
**Post date:** [October 3, 2022, 8:52am UTC](https://forums.percona.com/t/percona-xtradb-and-magento-cron-job-failures/17787/6 "2022-10-03T08:52:43Z")

</div>

Thx [matthewb](https://forums.percona.com/u/matthewb) for your reply.

So are you suggesting that Magento can only run reliably against a single node MySQL DB? I have had it running for the last 5 years against a Percona XtraDB cluster and not had these cron issues I am reporting here.

I will try that setting you suggest, just in case it helps though so thanks for that suggestion.

Did you see my other post at:

> [@Percona XtraDB and wsrep\_convert\_lock\_to\_trx](https://forums.percona.com/t/percona-xtradb-and-wsrep-convert-lock-to-trx/17782):
>
> Hi, I have a question relating to a 3 node Percona XtraDB cluster for a Magento online store. The percona cluster is running on 3 Ubuntu nodes (5.4.0-126-generic #142-Ubuntu) and the version of percona is the latest from the repos. (percona-xtradb-cluster 1:8.0.29-21-1.focal). In order to get Magento to work I have always had to have the cluster set to a PERMISSIVE state (SET GLOBAL pxc\_strict\_mode=PERMISSIVE;) mainly because Magento issues GET\_LOCK and RELEASE\_LOCK on certain t…

where I ask about [wsrep\_convert\_lock\_to\_trx](https://forums.percona.com/t/percona-xtradb-and-wsrep-convert-lock-to-trx/17782) - it would be really useful to get your view on that.

Thanks for your responses though, some ideas / insight into this issue is of course very welcome!

---

_[View the full topic](https://forums.percona.com/t/percona-xtradb-and-magento-cron-job-failures/17787)._
