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 <k...@linuxdigital.net> wrote: > 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 have been increasing. > However as far as I know this should not occur since we are running one > database at a time and usually these occur when modifying the same data. > Does anyone else run a similar setup or have any tips on how we can solve > this? > > Thanks for any help you can provide! > -- Daan
