RE: How to make big MySQL database more diffable/rsyncable? (aka rsyncing big files)

2009-07-10 Thread Tony Abernethy
Silly question, but are you doing something like compacting, removing air, or "optimizing" the database in any form? If the blobs keep moving around, that makes finding common stuff much much harder. It will still have to read both sides even if almost everything is the same > -Original

Re: How to make big MySQL database more diffable/rsyncable? (aka rsyncing big files)

2009-07-10 Thread Krzysztof Nosek
Hello, So I do not think the basic data structure is the problem, unless mysql hotcopy does something really strange like inserting a timestamp or other changing data info every few KB in the output stream. No, really, mysqlhotcopy performs just a raw file system copy of /var/lib/mysql ta