MariaDB Galera Cluster (master-master) does sync Tables but no data I'm currently experiencing some sync-issues on my MariaDB Galera Cluster which is a master-master scenario. I've got everything set up properly and the cluster is syncing the DDL changes flawless. 

The output of the DB-Parameters seems right because every relevant variable is correct (both nodes are: ready, have the same sync-state and no errors are detected). 

I made the check by creating a table and checking if it's syncing to the other node - after that i did it backwards. Everything works except the syncing of the data from the first node to the second. 

Is there a way to initiate tis sync-process manually? Might there be a log-file which i oversaw?

Best Regards 
k
Galera doesn't support but the InnoDB ENGINE (and XtraDB, which is essentially the same). While there is experimental support for MyISAM, by activating wsrep_replicate_myisam, that is not guarantee to work, as it is not transactional.

The DDL that you executed worked because they do not use the ROW format, but STATEMENT-based replication.

While we could hack and maybe make it work, it would work poorly. I highly recommend you to change the tables to InnoDB: ALTER TABLE your_table ENGINE=InnoDB, FORCE; After that, any change will be synced automatically as desired.

References:


MariaDB Galera Cluster limitations: https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/
Aria is not supported: https://groups.google.com/forum/#!msg/codership-team/-VTXuYVnbN0/d-v4NVTQDNwJ