Not the answer you need?
Register and ask your own question!

Corrupted database after sync

Nabil BabacheNabil Babache EntrantInactive User Role Beginner
Hello,

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.

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    Hi,
    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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.