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

Issues with MYSQL to percona migration with innobackupex

atfrysatfrys EntrantInactive User Role Beginner
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

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    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?
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.