search for: 552860

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 algorithm will be highly effective at reducing the bandwith required to transfer these