This page lists limitations of MySQL/Galera replication.
mysql.*) tables are not replicated. However, DDL statements are replicated in statement level, and changes to
mysql.*tables will get replicated that way. So, you can safely issue:
INSERT INTO mysql.user…will not be replicated. In general, non-transactional engines cannot be supported in multi-master replication.
SELECT…LIMIT…may return slightly different sets. Don't use tables without primary key. It is always possible to add an
AUTO_INCREMENTcolumn to a table without breaking your application.
LOCK/UNLOCK TABLEScannot be supported in master-master replication.
log_output = FILE
general_log_file to choose query logging and log file name.
LOAD DATA) may adversely affect node performance. To avoid that
wsrep_max_ws_sizevariables limit transaction rows to 128K and transaction size to 1Gb by default. If necessary user may want to increase those limits. Future versions will add support for transaction fragmentation.