Restore innobackupex hot backup over the cluster

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.