Galera Cluster limitations
Galera Cluster has limitations that prevent it from working correctly.
Tip
Do not go live in production if you haven't checked that your application is in compliance with the limitations listed.
The following are the limitations:
Galera Cluster only fully supports InnoDB tables. TokuDB is planned but not yet available and MyISAM is partially supported.
Galera Cluster uses primary keys on all your tables (mandatory) to avoid different query execution orders between all your nodes. If you do not do it on your own, Galera will create one. The delete operation is not supported on the tables without primary keys.
Locking/unlocking tables and lock functions are not supported. They will be ignored if you try to use them.
Galera Cluster disables query cache.
XA transactions (global transactions) are not supported.
Query logs can't be directed to a table, but can be directed to a file instead.
Other less common limitations exist (please refer to the full list if you want to get them...
