I’m trying to implement a backup solution with innobackupex (we would like to create incremental backups). We have a 3 node galera PXC on mysql 5.7
I’m using a publicly available simple backup script - can’t find the URL right now - which utilizes innobackupex to create the backups
It’s a production environment with around 1TB data and lots of schemas in it.
I used lock-ddl-per-table option, because lock-ddl was stopping the whole system, now I get this error after a few hours:
Error: failed to execute query SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 47098: WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction
tried to google, no luck.
any suggestions where should I start?