Re: [Firebird-devel] Firebird Transaction ID limit solution

[Kjell R. <kje...@da...>]

Den 2012-01-01 23:47 skrev Lester Caine såhär:
> Dimitry Sibiryakov wrote:
>> 01.01.2012 21:31, Kjell Rilbe wrote:
>>>>   So far, these are the suggestions I've seen
>>      Hey, how about my suggestion leave everything as is and perform backup-restore cycle on
>> demand?..
>>
>> Pros:
>> - No overhead.
>> - No additional disk space.
>> - No code change.
>> Cons:
>> - DBA with brain is required.
> ... Requires a downtime? Which can be substantial
> Unless the configuration can be set up to allow updates applied following the
> backup-restore cycle to be reapplied?

Interesting proposition in its own right. :-) I'm thinking that nbackup 
does something along those lines, but on the page level. Would it be 
very difficult to implement something similar but on the record level?

Avoiding downtime during backup/restore might be a more common 
requirement than the 64 bit txn id issue.

Kjell

-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@da...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64