How to deal with deadlocks on Percona Server?

O

Oleg Zaikin2015-01-12 12:25:13

MySQL

Oleg Zaikin, 2015-01-12 12:25:13

There are 3 MySql servers on Percona Server with master-master replication. Faced with the fact that periodically began to pop up deadlocks. Increasing wsrep_retry_autocommit to 10 didn't fix the problem, but it significantly reduced the occurrence of errors. However, I would like to get rid of such situations completely.
Where to look, what to smoke?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

V

Vladimir, 2015-01-12
@rostel

do not balance data change requests between nodes

V

Vlad Zhivotnev, 2015-01-12
@inkvizitor68sl

Well, if you are using master-master, then it is up to you to deal with deadlocks. Rewrite the application so that there are no deadlocks.
Well, or try the galley, but it will work noticeably slower for writing to both nodes.