Hello,
I have tried to put Zabbix 5.4.10 DB to Mysql Percona Server DB 5.7 in multi-master mode, but Zabbix database (think Zabbix UI) is making a lot of errors in that mode.
The most common errors are related that on two server there is same parameters that are trying to update. With other applications on those servers I don't have a problem, only Zabbix.
Error is like:
*** Priority TRANSACTION:
TRANSACTION 49103635, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
MySQL thread id 6, OS thread handle 139831451920128, query id 272879 System lock
*** Victim TRANSACTION:
TRANSACTION 49103634, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
, undo log entries 1
MySQL thread id 2481, OS thread handle 139830831871744, query id 272877 10.2.2.20 zabbix updating
UPDATE sessions SET lastaccess='1646052498' WHERE sessionid='33e2c7085f2d2a88b8942abdd70b4786'
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 3277 page no 33 n bits 280 index PRIMARY of table `zabbix`.`sessions` trx id 49103634 lock_mode
X locks rec but not gap
2022-02-28T12:48:19.183737Z 6 [Note] WSREP: --------- CONFLICT DETECTED --------
2022-02-28T12:48:19.183749Z 6 [Note] WSREP: cluster conflict due to high priority abort for threads:
2022-02-28T12:48:19.183759Z 6 [Note] WSREP: Winning thread:
THD: 6, mode: applier, state: executing, conflict: no conflict, seqno: 9571539
SQL: (null)
2022-02-28T12:48:19.183772Z 6 [Note] WSREP: Victim thread:
THD: 2481, mode: local, state: executing, conflict: no conflict, seqno: -1
SQL: UPDATE sessions SET lastaccess='1646052498' WHERE sessionid='33e2c7085f2d2a88b8942abdd70b4786'
Does anyone have experience with Percona in multi-master mode that is working with Zabbix?
I have tried to put Zabbix 5.4.10 DB to Mysql Percona Server DB 5.7 in multi-master mode, but Zabbix database (think Zabbix UI) is making a lot of errors in that mode.
The most common errors are related that on two server there is same parameters that are trying to update. With other applications on those servers I don't have a problem, only Zabbix.
Error is like:
*** Priority TRANSACTION:
TRANSACTION 49103635, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
MySQL thread id 6, OS thread handle 139831451920128, query id 272879 System lock
*** Victim TRANSACTION:
TRANSACTION 49103634, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
, undo log entries 1
MySQL thread id 2481, OS thread handle 139830831871744, query id 272877 10.2.2.20 zabbix updating
UPDATE sessions SET lastaccess='1646052498' WHERE sessionid='33e2c7085f2d2a88b8942abdd70b4786'
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 3277 page no 33 n bits 280 index PRIMARY of table `zabbix`.`sessions` trx id 49103634 lock_mode
X locks rec but not gap
2022-02-28T12:48:19.183737Z 6 [Note] WSREP: --------- CONFLICT DETECTED --------
2022-02-28T12:48:19.183749Z 6 [Note] WSREP: cluster conflict due to high priority abort for threads:
2022-02-28T12:48:19.183759Z 6 [Note] WSREP: Winning thread:
THD: 6, mode: applier, state: executing, conflict: no conflict, seqno: 9571539
SQL: (null)
2022-02-28T12:48:19.183772Z 6 [Note] WSREP: Victim thread:
THD: 2481, mode: local, state: executing, conflict: no conflict, seqno: -1
SQL: UPDATE sessions SET lastaccess='1646052498' WHERE sessionid='33e2c7085f2d2a88b8942abdd70b4786'
Does anyone have experience with Percona in multi-master mode that is working with Zabbix?