[Box Backup] Using multiple servers

[Ben Summers]

On 13 Jan 2006, at 11:54, Martin Ebourne wrote:

> On Fri, 2006-01-13 at 11:57 +0100, boxbackup@xolphin.nl wrote:
>> For my MySQL database I use replication, and I make a daily export of
>> all data with mysqldump. This dump is then being tarred and stored  
>> as a
>> .tgz. Is this the recommended method or is it better to leave  
>> the .sql
>> as it is, so BoxBackup can transfer only the changes of the export?
>
> I leave my daily dump uncompressed. I've not tested it to see the
> difference but suspect that makes more sense.
>
> Box will compress it anyway before transmission. I can't remember  
> if it
> diffs before or after compression so it may or not make quite a bit of
> difference.

Obviously, the diffing works on the uncompressed data. After diffing,  
it's compressed and encrypted in blocks. You theoretically get less  
compression because of the continual restarts of compression, but in  
the real world it seems to make little difference.

Ben