Restore Backup from MySQL Master to Percona Cluster with xtrabackup frm Clustercontrol GUI

Comments

7 comments

  • Avatar
    Johan

    Hi Dirk,

    It sounds like a bug. I will try and reproduce. 

    What cmon version are you using? 

    You can do:

    cmon --version


    Best regards

    johan

  • Avatar
    Dirk Hildebrand

    ~$ cmon --version
    cmon, version 1.6.0.2514

    Enabled features: mongodb, mongo-scram-sha1, postgresql, websocket, rpc, libssh, mysql, prometheus

  • Avatar
    Krzysztof Ksiazek

    Hi,

    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.

  • Avatar
    Dirk Hildebrand

    @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?

     

    Regards

     

    Dirk

  • Avatar
    Krzysztof Ksiazek

    Hi,

    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.

    Thanks,

    Krzysztof

  • Avatar
    Dirk Hildebrand

    The Node 192.168.11.101 is a PXC Node

  • Avatar
    Krzysztof Ksiazek

    Hi,

    Can you please check if credentials in /etc/mysql/secrets-backup.cnf are working correctly? Can you connect to MySQL using them? If not, please try to fix this by creating user/changing password/whatever is needed.

    Thanks,

    Krzysztof

Please sign in to leave a comment.

Powered by Zendesk