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.