MySQL Forums
Forum List  »  NDB clusters

Confusion about restore
Posted by: Sam Lalonde
Date: June 03, 2005 01:54PM

I am a bit confused about how to go about restoring a database.

Say I have a 2 node (+ 1 management server) cluster, and my database gets completely screwed. What are the steps to perform a restore. Let's the backup is <DATA DIRECTORY>/BACKUP/BACKUP-2, and nothing at all is running in the cluster.

- What parts of the cluster do I start (management server? NDB(s)?, API(s)?
- Should I manually delete any existing data before starting
- What exactly is the backup command I should use (options, etc)
- Do I need to run it on both servers? (One after another? In parallel?)
- Is it better to move all the files to one server before starting the restore?

Basically if I could see a step by step example it would be VERY helpful.

sam

Options: ReplyQuote


Subject
Views
Written By
Posted
Confusion about restore
2657
June 03, 2005 01:54PM
1787
June 04, 2005 10:53AM
1781
June 16, 2005 10:12AM


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.