MySQL Forums
Forum List  »  NDB clusters

Backup Procedure
Posted by: Adam D
Date: July 20, 2005 10:45PM

I restored backup id 1 like so;
In /var/lib/mysql-cluster/BACKUP/BACKUP-1/
c1s1# /usr/local/mysql/bin/ndb_restore -n 10 -b 1 -m
c1s1# /usr/local/mysql/bin/ndb_restore -n 10 -b 1 -r
c1s2# /usr/local/mysql/bin/ndb_restore -n 20 -b 1 -r
c1s3# /usr/local/mysql/bin/ndb_restore -n 30 -b 1 -r
c1s4# /usr/local/mysql/bin/ndb_restore -n 40 -b 1 -r

My Node IDs are ndb( 10, 20, 30, 40 ) mgt (100) to keep things clear.

I did that one at a time becuase my cluster config only allowed one extra api connection. Ive since changed this. However after carrying out this on all datanodes The cluster log mentioned

2005-07-15 11:04:28 [MgmSrvr] ALERT -- Node 10: Network partitioning - arbitration required
2005-07-15 11:04:28 [MgmSrvr] INFO -- Node 10: President restarts arbitration thread [state=7]
2005-07-15 11:04:28 [MgmSrvr] ALERT -- Node 10: Arbitration won - positive reply from node 1


Then all the datanodes disconnected. I have no explicit abrbitrators set in my config.
Apon starting them backup without --initial they came up, however stayed on Phase 4 for ages, and nodes '30' and '40' were cranking in Operations for quite some time;

2005-07-15 11:14:22 [MgmSrvr] INFO -- Node 40: Operations=1975
2005-07-15 11:14:22 [MgmSrvr] INFO -- Node 30: Operations=1975
2005-07-15 11:14:22 [MgmSrvr] INFO -- Node 10: Operations=0
2005-07-15 11:14:22 [MgmSrvr] INFO -- Node 20: Operations=0


So my questions are;

1. Is that normal restoration behaviour, and;

2. Does anyone have a list of the Phases and what they do/mean so I can be clearer in the clusters operation.

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup Procedure
2676
July 20, 2005 10:45PM
1596
July 25, 2005 07:36AM


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.