Restore innobackupex hot backup over the cluster

Hi all,

I recently started to use percona server and played around with innobackupex in order to do hotbackups. I even followed the restore process through the copy of the idb and exp files and the table space import and worked perfectly.

I’ve followed same procedure on a percona cluster with three nodes I setup, at that point the restore went ok on the node where its been done, but on the other two cluster nodes I had problems with some tables.

But I’ll start explaining that when doing the “ALTER TABLE table DISCARD TABLESPACE;” because some foreign keys I do next before and after:

  • Before:
    SET foreign_key_checks = 0;

  • After:
    SET foreign_key_checks = 1;

And worked perfectly on the node where run so.

Now for some tables on the other nodes, when selecting I get that error:

ERROR 1030 (HY000): Got error -1 from storage engine

Something that does not happen on the node where I restored.

  • Maybe has to do with the fact that the exp file only exist in one node?

  • Should I use another strategy for doing hot backups and restore on the Percona Cluster?

I asked here basically because even when the “problem” has to do with innobackupex it only take place on my cluster nodes.

Thank you.