Re: Rsync efficiency on SQL dump files

2008-10-01 Thread Paul Slootman
On Wed 01 Oct 2008, Callum Macdonald wrote: > > I'm backing up production MySQL database servers. The tables are almost > all MyISAM. > > My plan is to use MySQL binary logging and then rsync the binary logs > offsite hourly. The binary log files are only appended to, with new > queries logged at

Rsync efficiency on SQL dump files

2008-10-01 Thread Callum Macdonald
G'day, I'm backing up production MySQL database servers. The tables are almost all MyISAM. My plan is to use MySQL binary logging and then rsync the binary logs offsite hourly. The binary log files are only appended to, with new queries logged at the end of the file. So I'm assuming the rsync alg

Re: rsync efficiency

2008-09-22 Thread Benjamin Schweizer
Hi there, there are various challenges with this: rsync would typically use the mtime to check if a file has changed and if so, it would scan the source file and the target file and compage checksums. Thus, both files need to be read in whole - which affects performance. This is especially the cas

rsync efficiency

2008-09-19 Thread Marcelo Leal
Hello all, I have a doubt that i think you hackers of rsync has the answer. ;-) I have make this post on my blog: http://www.posix.brte.com.br/blog/?p=312 to start a serie about the copy-on-write semantics of ZFS. In my test "VI" did rewrite the whole file just for change 3 bytes, so the whole