Restore Backup from MySQL Master to Percona Cluster with xtrabackup frm Clustercontrol GUI
i have a Clustercontrol wich is in the 30 Day Trailperiod and i would love to restore a Backup from a single MySQL Server to a new empty Percona Cluster. I use xtrabackup and do a full Backup of the MySQL Server. Then i copy the Backupfolder from the Single MySQL to one Node of my PXC. In the Clustercontroll GUI i choose the PXC Cluster and go to Backup -> Restore Backup and chosse the Server on wich i want to restore, set the backupmethod to xtrabackup, define the Tmp Dir Path (the default /home/user/s9s_tmp is fine for me) and fill the Backup Path with the following: /home/user/backups/BACKUP-20/backup-full-2018-05-14_114609.xbstream.gz
I choose to bootstrap the Cluster from the restored Node and i dont want it to make a copy of the datadir (because its an empty cluster) and choose "Finish"
In the Job Details the Job Fails immediately with the following Logmessages:
Unfortunately, this is a limitation of CC. When restoring external backups it assumes backup is located on the controller node. In your case it's not thus the error. I've created a feature request to make possible to pick a local node as the location of the backup, we'll add this option in one of the upcoming releases. For now, as long as you can do that, the workaround would be to copy the backup to the controller host and try to restore it from there.
@Krzysztof Ksiazek thank you, that really resolved my problem. Maybe the Textfield should show the user a hint that the Backup needs to be on the Clustercontrol Server and not on the node you want to restore on.
Now i have a new Problem with the restore:
It seems as if i need a backupserver wich can connect to the Single MySQL Server as well as to the new cluster. I restored the Backup and at the end of the restore process there is a message in the logs wich says;
[12:03:59]: Preparing backup secrets config file '/etc/mysql/secrets-backup.cnf'.
[12:03:59]: 192.168.11.101: the user in [xtrabackup] has problems to connect: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (28000): Access denied for user 'backupuser'@'localhost' (using password: YES)
Attempting to fix.
[12:03:58]: 192.168.11.101:3306: Server reached expected node state GALERA_NODE_SYNCED, ok!
What do i need to do here?
What is the role of this (192.168.11.101) host? Is it PXC node or standalone? If you want, you can create a ticket with us (http://support.severalnines.com/home). It would be nice to get an error report from you and there are pieces of data which are not suitable for the public site.
Please sign in to leave a comment.