I have two nodes running both with master-master XtraDB Cluster 5.5 with HAProxy as a frontend. Everything was running fine for a couple of days but I noticed some issues with the data, which turns out the issue was because the tables were MyISM instead of InnoDB.
A couple of days later, I noticed that I’m missing some entries in one of the tables. As a workaround, I pointed our web app to just one of the DB’s instead of the HAProxy server until I could get the tables converted to InnoDB. Is it possible that rows are deleted in this case?
And just to prefix this all, i’m still learning the inner workings of Percona. Thanks for any help.