On Jul 6, 2009 4:41am, Krzysztof Nosek <[email protected]> wrote:
I'm having a very hard time rsyncing efficiently a MySQL database which contains very large binary blobs.
<snip>
How to do it better? I thought that rsync would be magically able to extract changes from my data. However, it looks like it diffs the 17G file everyday again and again, even it stayed intact. The times/attributes of files do not change across the copies either, as mysqlhotcopy preserves them.
There was a recent thread on this list regarding rsync of MS SQL Server database backups. Most of those suggestions would apply to the mysql case as well. You would want to make sure you are telling rsync to use a block size that is the same as or an integral multiple of the mysql block size. You will also want to minimize unnecessary change in the source database (index rebuilds are a major culprit).
-- RPM
-- Please use reply-all for most replies to avoid omitting the mailing list. To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html
