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.