SQL Deadlocks using Galera Active/Backup/Backup

2021-10-02 Thread Loth
Hi Users, I am seeing some deadlocks in my sql error log; "[ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction" My environment is a 3-node Galera cluster behind HAProxy, with two as "backup" and one active. Usually this performs fine, but recently these deadlocks ha

Re: SQL Deadlocks using Galera Active/Backup/Backup

2021-10-04 Thread Daan Hoogland
Loth, I think you are better off asking this question on a mysql forum, somewhere. It doesn't seem anybody worked with a 3-node cluster, here. On Sun, Oct 3, 2021 at 7:29 AM Loth wrote: > Hi Users, > > I am seeing some deadlocks in my sql error log; > "[ERROR] mysqld: Deadlock found when trying

Re: SQL Deadlocks using Galera Active/Backup/Backup

2021-10-04 Thread Wei ZHOU
Hi Loth, I know some setup with 3-nodes mariadb cluster and nginx (not haproxy) which work fine. Could you please share more information, for example mariadb status, error logs in cloudstack management ? -Wei On Sun, 3 Oct 2021 at 07:29, Loth wrote: > Hi Users, > > I am seeing some deadlocks