mysql,rsync backup while file (50GB) getting updated
we are currently performing mysql backups with 'slave stop' and then with rsync from the slave -> great.
one file is so huge though (50G+) that we can only have it on the master and then we again rsync it to an other server - while the file is still getting updated every couple seconds or so by mysqld.
Now I found out that rsync makes up to 3 runs... because it recognizes that the file was updated while it was transfered - is there something like a rsync --max-runs=1 or so? or any tips how do do the backup of the huge file any better?