MySQL Forums
Forum List  »  NDB clusters

Re: cluster restore failed! why?
Posted by: Stewart Smith
Date: November 15, 2006 06:59AM

single user mode should have nothing to do with it.

you need to restore the data from *each data node* that participated in the BACKUP.

This is because each node backs up the table fragments that it is the primary replica of.

For a table stored in a 2 node 2 replica cluster, there are 2 fragments per table. F1 is stored in both nodes and Node 1 is the primary replica of this fragment. F2 in both nodes, Node 2 is primary replica of this fragment.

This is so that some operations (notably locking and backup) are load balanced across the cluster.

Restoring only 1 node would restore only 1 fragment, so about 1/2 the data.

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Options: ReplyQuote


Subject
Views
Written By
Posted
1791
November 07, 2006 08:02PM
989
November 07, 2006 08:30PM
972
November 07, 2006 09:08PM
1094
November 08, 2006 01:58AM
1202
November 08, 2006 03:24AM
1131
November 08, 2006 10:48PM
1113
November 13, 2006 07:33PM
Re: cluster restore failed! why?
1063
November 15, 2006 06:59AM
1190
November 16, 2006 09:16PM
1014
November 26, 2006 11:06PM
1003
November 26, 2006 11:20PM


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.