2

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

  • Are your tables MyISAM/Aria or InnoDB? – jynus Apr 6 '15 at 20:18
  • I'm using Aria for every table. – async Apr 6 '15 at 20:27
1

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:

  • 1
    Thank you for this very helpful answer. I converted the tables to InnoDB (a script for generating the command for each table can be found on SO) and exported the whole database. Then I dropped everything and restored the database to transfer every INSERT command to the second node. Now i have a running galera Cluster, thank you very much! k – async Apr 7 '15 at 11:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.