> We started testing Galera + Magento 10 days ago. Our setup is: 2 galera
> nodes and 2 garbd nodes. One of the galera nodes has virtual IP assigned to
> it via pacemaker. This is our cluster IP. Magento webservers communicate
> with cluster IP. This way one node is de facto primary and second galera
> node is secondary. We do not need to talk with both nodes at same time.
> Projected traffic to our website is small. Main purpose for Galera is to
> allow for easy failover.

> I found some issues recently:
> - I could not run 'USE magento' on one of the nodes. googled for it and
> someone suggested rebooting such node. Reboot seems to fix the issue. node
> is now properly connected to cluster.
> - there are differences in data on both nodes. some tables contain more
> rows on one node than on another. and there is even one table which is
> missing on one of the nodes!

> Difference in data look scary. Is this typical? What is recommended way of
> troubleshooting this issue? Is Magento not fully compatible with Galera?

> We do have some tables without primary keys. If DELETE operations were
> performed on those tables this could explain differences in data in those
> tables. However this does not explain why one table is missing.

> I am quite puzzled and looking for an advice.

> Thanks in advance!