[prev in list] [next in list] [prev in thread] [next in thread] 

List:       npaci-rocks-discussion
Subject:    Re: [Rocks-Discuss]Backing up the MAC address list and importing it in a new fronten d?
From:       Federico Sacerdoti <fds () sdsc ! edu>
Date:       2004-09-29 14:15:26
Message-ID: 02C32680-1222-11D9-8C66-000D9338C188 () sdsc ! edu
[Download RAW message or body]

Troy,
The /tmp/clusterold.sql is actually removed during the update. However,  
you can get it back with:

# mysqldump --opt -u apache clusterold > /tmp/clusterold.sql

i.e. the old database is actually present in mysql under the database  
name "clusterold" after a frontend upgrade. Then follow the rest of the  
steps to reinstate your true "cluster" database.

-Federico


On Sep 28, 2004, at 4:32 PM, Troy Peng-fei Chuang wrote:

> Hi,
> I did a frontend upgrade, but surprisingly, I didn't see  
> /tmp/clusterold.sql. (kinda freaked out at that time...)
> However, there is a directory named /var/lib/mysql/clusterold/, which  
> contains the old cluster database.
>
> When I tried to do
> # mysql -u root -p cluster < /var/lib/mysql/clusterold.sql
> I got
> -bash: /var/lib/mysql/clusternew.sql: No such file or directory
>
> Then I tried
> # mysql -u root -p cluster < /var/lib/mysql/clusterold
> It returned
> mysql: Error reading file 'UNOPENED' (Errcode: 21)
>
> Actually what I wanted to do was to keep the MAC address information,  
> I decided to only copy the 'networks' table and 'nodes' table over.  
> (By using MS Access + Connector/ODBC 3.51, so I could select rows at  
> once <connector/odbc/3.51.html>. Maybe there is an easier way to do it  
> by sql commands. If so, please enlighten me.).
> (Plus I actually changed the hostname of the frontend, I think I  
> shouldn't copy all old cluster info over anyways.)
>
> After I copied these two tables over, the following commands seems to  
> give correct results.
> #dbreport hosts
> #dbreport dhcpd
>
> ??? BUT I DO WANT TO KNOW IF COPYING THESE TWO TABLES IS GOOD ENOUGH,  
> OR IS THERE OTHER THINGS I SHOULD TAKE CARE OF ???
>
> I am now continuing to reinstall compute-nodes. Hopefully everything  
> will work fine.
>
> -Troy
>
>
> Federico Sacerdoti wrote:
>
>> Matt,
>> If you do a "frontend upgrade" the old database (containing the old  
>> MAC
>> addresses) will be stored in /tmp/clusterold.sql. You can view this  
>> file
>> after upgrading the frontend, or even reconstitute your current  
>> cluster
>> database with it:
>>
>> To do the last option:
>> 1. upgrade your frontend (see link below)
>> 2. Reinstate your old cluster database:
>>
>> # mysql -u root -p cluster < /tmp/clusterold.sql
>> (the password will be the root pass for the frontend)
>>
>> 3. Rebuild all config files:
>>
>> # insert-ethers --update
>>
>> 4. Done. Inspect the old database to make sure all nodes are present.
>>
>> (http://www.rocksclusters.org/rocks-documentation/3.2.0/upgrade- 
>> frontend.htm
>> l)
>>
>> -Federico
>>
>> ----- Original Message -----
>> From: <matt.wise@amd.com>
>> To: <npaci-rocks-discussion@sdsc.edu>
>> Sent: Wednesday, September 15, 2004 6:24 PM
>> Subject: [Rocks-Discuss]Backing up the MAC address list and importing  
>> it in
>> a new fronten d?
>>
>>
>>
>>> Next week we are going to be doing some major work on our 144 node  
>>> cluster
>>>
>> and are planning on just building a new head node rather than  
>> screwing up
>> our perfectly good one. Is there any way I can somehow back up the  
>> list of
>> MAC addresses and import them automatically into the new frontend  
>> node so
>> that I do not have to boot up 144 nodes in perfect order?
>>
>>> --Matt
>>>
>>>
>>
>>
>>
>
>
> -- 
> Troy P. Chuang
> Programmer/Analyst             UCSD/CSE-AP&M 3337C
> Department of Computer         9500 Gilman Dr, La Jolla, CA 92093-0114
> Science and Engineering        Phone: (858)822-1721
> Univ of California, San Diego  E-mail: tchuang@csag.ucsd.edu
>
Federico

Rocks Cluster Group, San Diego Supercomputer Center, CA


[prev in list] [next in list] [prev in thread] [next in thread]