List:General Discussion« Previous MessageNext Message »
From:Nils Valentin Date:November 13 2003 4:29pm
Subject:Re: CRASH AND ROLLBACK SIMULATION
View as plain text  
Hi there,

I am not sure I understood your question correctly. What exactly is it that 
you want to test ?

a) the recovery possibility in case of power down
b) the recovery possibility in case of client disconnection (network 
interruption, timeout etc.)
c) Recovery possibilities in general accessing the data files directly and 
indirectly using command line and/or GUI tools.

In case a) mysql would recover the data files itself in most cases next time 
when the server is started as long as the logfiles, datafiles, config files 
are all there in the original positions (talking about InnoDB).

b) If the network connection times out or client is diconnected than all 
executed commands since the last commit,begin gets rolled back (will not be 
applied)

c) If the Innodb files are damaged so that the mysql server does not startup 
than no client tool (command line or GUI) that uses the indirect access 
method can access any data.

I know that there are tools in the mysql package which access and repair 
(My)ISAM tables directly (server doesnt need to run), but that isnt true for 
the InnoDB tables I believe. I am not sure if InnoDB Hotbackup can directly 
access the InnoDB tables.

What I know is that there will be a book coming up in February from Paul 
Dubois (Certification Study Guide) which is already described on Amazon.

When it comes out I believe that it  will be the best book on the market so 
far, answering many of those and similar questions. I had the honour to 
review one of those preprints, all I can say so far is "Very impressive", you 
will see for yourself..   


On Friday 14 November 2003 00:58, nm wrote:
> Do you know how to test a crash and a rollback?

-- 
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/
Thread
CRASH AND ROLLBACK SIMULATIONnm13 Nov
  • Re: CRASH AND ROLLBACK SIMULATIONMartijn Tonies13 Nov
  • Re: CRASH AND ROLLBACK SIMULATIONNils Valentin13 Nov
    • Re: CRASH AND ROLLBACK SIMULATIONMikael Fridh14 Nov