Issues with MYSQL to percona migration with innobackupex

MySQL & MariaDB Other MySQL® Questions
1

I have been bangin my head against the wall on how to get from one MySQL server to my new percona cluster. I have done multiple methods, but the data gets corrupted.

I used percona xtrabackup to create a backup of our MySQL slave
used the innobackupex --decompress
Applied the logs
copied the data and overwrote my existing percona (Yes I am in bootstrap mode with other nodes stopped
percona starts, but most databases are corrupted. I tried this by pausing the slave and taking the backup as well as doing it live. The apply logs says everything is fine, but if I try to do any selects, no love for both system and user databases.

Any help would be appreciated.

Thank you

2

Please send us the following:

  • full command used to create the backup
  • logs during the create and prepare phases (if you still have them)
  • error log from the first node

After copying the files to the datadir did you change file ownership for the datadir to mysql? Can you start up node1 as regular mysql (not bootstrapped) and run a few select queries?