We are using an online application built on Liferay framework with Ubunt mysql as the database. We use multi-thread calls for the application and it used to work fine with stand alone server(dev) and 2 node cluster for UAT and Prod. We have upgraded the db version to Percona now and we are struggling with multiple issue such as pxc_strict_mode set as Enforcing causing deadlocks and mandatory to add primary key in all the tables. We have addressed these two issues, however we are facing the WSREP: cluster conflict due to certification failure for threads. We are going crazy on how to get this resolved.
Kindly request any of the experts to help us in this regard.