MySQL Cluster backup

Dev Shed Forums Sponsor:

February 8th, 2012, 04:26 AM

azazel_bg

Contributing User

Join Date: Jul 2006

Posts: 151

Time spent in forums: 2 Days 12 h 10 m 56 sec
Reputation Power: 39

MySQL Cluster backup

Hello guys,

I recently switch to MySQL Cluster before that I was using clean MySQL.

Now to the point.

Till now I was making my own backups manually. What I was doing was: stop MySQL daemon copy data folder to archive folder and start MySQL daemon.
But that is not the story for MySQL Cluster.

As I understand it if I loose the node folder and table scheme from the node folder, no matter I have the data folder I'm not able to see my databases and the information within.

Let us say that by accident I start the node with --initial and the ndbd folder is cleaned up and ready for fresh start and I already have a backup thru the ndb_mgm created.

How can I recreate the databases and recover the information from them?

Thank for your help in advance.

p.s.: I hope I will find my answers here because from the MySQL forums it turn out that no body cares or they don't have any idea about the backups and they can't give me a decent answer to my questions.

February 10th, 2012, 08:56 AM

Problem Solver

Join Date: Jan 2001

Location: Stockholm, Sweden

Posts: 4,314

Time spent in forums: 3 Weeks 3 Days 12 h 26 m 54 sec
Reputation Power: 448

I think you should be able to use the "ndb_restore -m ..." to restore the meta data for the tables.
And since a copy of the .ctl file (control information and meta data) is saved on each node in the cluster I think you should be pretty safe.

Quote:

Originally Posted by manual

The first time you run the ndb_restore restoration program, you also need to restore the metadata. In other words, you must re-create the database tables—this can be done by running it with the -m option. Note that the cluster should have an empty database when starting to restore a backup. (In other words, you should start ndbd with --initial prior to performing the restore. You should also remove manually any Disk Data files present in the data node's DataDir.)

Ref: ndb_restore

__________________
/Stefan

February 13th, 2012, 01:59 AM