From: Devananda
Date: July 16 2004 3:08am
Subject: Re: question about disk usage
List-Archive: http://lists.mysql.com/cluster/148
Message-Id: <40F7469A.5000901@neopets.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Thanks, that was it! I had misunderstood the -i option.

Devananda

jandersson@stripped wrote:

>Hi,
>Data is checkpointed to disk (asynchronously) and a redo log is periodically
>flushed to disk.
>
>It sounds you do an initial start every time you start the cluster, thus wiping
>out the data (or you have set DiskLess: 1 in config.ini)
>When you _restart_ the cluster, you must _not_ restart the db nodes with 'ndbd
>-i' or 'ndbd --initial' , just start all nodes with 'ndbd' . This will do a
>system recovery based on the checkpointed information and redo logs.
>
>Regarding the disk data feature, look at other mail threads. It has been
>discussed.
>
>
>good luck!
>johan andersson
>
>Quoting Devananda <devananda@stripped>:
>
>  
>
>>Hi all,
>>
>>Sorry if this is a basic question, but it's unclear to me at this point 
>>whether the cluster stores its data on the disk, or purely in memory, 
>>and what the plans are for this in the future. Basically, the problem 
>>I've got is this: I put my data in the cluster and stop/start the 
>>cluster, and all my data's gone. I understand that ideally, one would 
>>never have to stop the cluster, but realistically, what if there's a 
>>power failure or other disaster? I can't have all the data just *poof* 
>>away. And if I were able to run an ordinary backup server (say InnoDB) 
>>to replicate what is in the cluster, then I really wouldnt need a 
>>cluster at all. Now ... I notice that before I stop the DB nodes, the 
>>data directory is very large -- is the data stored there, and is it in a 
>>recoverable format, and if so, why doesn't my cluster restart with it's 
>>last known data?
>>
>>If there's a page on the website that talks about this (that I've 
>>mysteriously overlooked) please point me there :-)
>>
>>
>>Thanks,
>>
>>Devananda
>>Neopets, Inc.
>>
>>-- 
>>MySQL Cluster Mailing List
>>For list archives: http://lists.mysql.com/cluster
>>To unsubscribe:    http://lists.mysql.com/cluster?unsub=johan@stripped
>>
>>
>>    
>>
>
>
>
>
>----------------------------------------------------------------
>This message was sent using IMP, the Internet Messaging Program.
>
>  
>