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
1775
November 07, 2006 08:02PM
988
November 07, 2006 08:30PM
970
November 07, 2006 09:08PM
1093
November 08, 2006 01:58AM
1200
November 08, 2006 03:24AM
1128
November 08, 2006 10:48PM
1108
November 13, 2006 07:33PM
Re: cluster restore failed! why?
1059
November 15, 2006 06:59AM
1185
November 16, 2006 09:16PM
1012
November 26, 2006 11:06PM
1001
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.