MySQL to Galera Cluster Migration, Deadlock, Back to basics
This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into app values (1); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Little background: We needed to work on migrating the standard MySQL replication to a Galera (Percona Xtradb Cluster). Previous configuration being one Master with two slaves detailed as follows: server-1: MySQL community 5.6 serving as Master server-2: MySQL community 5.6 serving as Slave server-3: MySQL community 5.6 serving as Slave We wanted to migrate...