I have two MySQL Clusters (NDB), Prod and Dev. Each cluster contains SQL nodes, Management nodes and Data nodes. Backups are done on one cluster using the article below:
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-using-management-client.html
How do I import the created backup file to separate MySQL Cluster? i.e. refresh dev cluster with prod data.
The backup seems to be tied to the cluster it was created on. Is there a way to do a 'restore' on a separate cluster with the backup file?
Best Answer
It is possible to restore backup on a different cluster. Did that many times myself. Just backup and restore procedures are not so simple in the case of NDB.
I was using the following steps to perform backup and restore. In the first step I generate dump script to make schemes structures backup.
If that looks too simple - keep in mind that you will have to drop and later recreate foreign keys if you have any. :)