Hi, i have a cluster with 3 nodes i stop mysql on all, and start with the restore:
rm -rf /mnt/mysql-data/mysql/*
xtrabackup --decompress --remove-original --target-dir=.
xtrabackup --prepare --target-dir=.
xtrabackup --copy-back --target-dir=.
Everything runs fine at this point, but when i try to start bootstrapper i got an error, and the node where i restore the data doesnt UP.
Did you fix permissions? After you --copy-back, you need to chown -R mysql:mysql /mnt/mysql-data/mysql
Yes i do it after the copyback.
What is the error you are getting ?
systemctl start mysql@bootstrap.service
Job for mysql@bootstrap.service failed because a fatal signal was delivered to the control process.
See “systemctl status mysql@bootstrap.service” and “journalctl -xeu mysql@bootstrap.service” for details.
For now i solved the problem of node start but when i try to access to mysql not working, give me an error 1045.
you must be giving the wrong password, please use the root password from which node the backup was taken, before restore thanks
I have verify user and password but still with the error. I have no clue what could be the problem.
Check the error logs of mysql. It’s possible that your restore didn’t work and MySQL decided to init the datadir which would explain why your password doesn’t work.