Corrupted database after sync


I’ve installed a 3-nodes cluster to host a WordPress database: srv1, srv2 and srv3.

Everything was working fine with a new WP installation but when I imported a large database (200 MB) to srv1, my WP installation stopped working on srv2 and srv3.

WP returns an error saying that the database is corrupt, I tried to repair it but it didn’t solve the issue.

When I import the same database to srv2, it works on that node and I get the same issue in srv1 and srv3.

I think the sync alters data or corrupt tables. Is there a way to check what happens exactly and make sure the same data is synced between the 3 nodes?

Thank you.

First of all, it is always best to copy/paste exact error messages, that really helps in investigation!
Do the srv* names mean cluster nodes names, or database schema names?
Before you imported the data, did you make sure all tables to import are InnoDB?