Backup and Restore
I am having difficulties fully understanding backup and restore within a cluster. I have read several articles and many online posts as well as the reference manual but yet I don’t quite get it. I am certain that the answer is simple and therefore it belongs here, if someone can please take the time to point me on the right direction I will appreciate it.
So, following many directions and how-to's I got a cluster going. 3 physical computers (one mgm, and the 2 others running one instance of ndb and mysqld each). Backup is simple enough and it runs just fine. My problem comes with the restore, or better yet the understanding of the restore. Here is the thing; do I use the ndb_restore to restore the database on one of mysqld instances within the cluster? I ask because if I loose one of the computers running the mysqld, once I bring it back online, will it not just get the data from the master without having to restore it? I get the impression that the restore is for a whole cluster and not for one database within the cluster, have I gotten it all wrong?
Why else will the restore program be executed once for each set of backup files? The reference manual says (“That is, as many times as there were database nodes running when the backup was created”).
Like I said, the statements are simple and in plain english, yet I am confused and I am sure it has to do with some basic knowledge that I lack since I am a newbie to mysql.
Regards,
Ramon
Subject
Views
Written By
Posted
Backup and Restore
1540
March 18, 2006 08:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.