Re: revisioning mysql server

Hi Shimi and Erez,

On Wed, Mar 23, 2016 at 12:53 PM, shimi <[email protected]> wrote:

>
>
> On Wed, Mar 23, 2016 at 9:22 AM, Erez D <[email protected]> wrote:
>
>> hi
>>
>> i have a running mysql server, and want to be able to restore it to any
>> day, with as little backup space as needed
>>
>> i do mysqldump to the same file every day then commit the file with "svn
>> ci"
>> the idea is that if there are no changes, it takes no space
>>
>> it works well if i just append entries to a database, as svn will just
>> save the changes
>>
>> however, if i insert a record, and for instance the dump file has 5
>> record at every line
>> then the change is big and actually svn will save most of the file though
>> there is a very small change actually.
>>
>> another issue - if the records hold changing info like timestamps etc.
>>
>> any idea ?
>>
>>
> What about xdelta[1] and saving the .xdelta files ? (from last copy or
> original copy - your choice, but the cost of choosing the former to save
> space would be that you'll have to roll the opposite operation in sequence
> for any recovery)
>
>
Subversion already uses xdelta (or its alternative vdelta) internally for
keeping track of binary diffs, so this will likely not buy you much (and
add a lot of complexity to the process). I believe git and mercurial/hg can
handle binary diffs well in a similar manner. As a result, one cannot rely
on the textual "diff -u" output to accurately indicate the change size
(e.g: changing one byte in a line of thousands of bytes will yield a
thousands-bytes diff -u , but be a very small binary change).

Regards,

— Shlomi Fish


> -- Shimi
>
> [1] http://xdelta.org/
>
> _______________________________________________
> Linux-il mailing list
> [email protected]
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>
>


-- 
------------------------------------------
Shlomi Fish http://www.shlomifish.org/

Chuck Norris helps the gods that help themselves.

Please reply to list if it's a mailing list post - http://shlom.in/reply .

_______________________________________________
Linux-il mailing list
[email protected]
http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il