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

Improve this question
2
  • Are your tables MyISAM/Aria or InnoDB?
    – jynus
    Apr 6, 2015 at 20:18
  • I'm using Aria for every table.
    – async
    Apr 6, 2015 at 20:27

1 Answer 1

Reset to default
1

Galera only supports 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 guaranteed 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:

Improve this answer
1
  • 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, 2015 at 11:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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