MySQL Database Migration using Rsync


1 comment

  • Official comment
    Krzysztof Ksiazek


    Rsync will not impact consistency of your files on the source server. It won't maintain data consistency on the target server, though, unless you stop the source database first. Such test may be useful to test how long will take to copy the data but that's about it.

    It should not lock any of your data on the source host, you have to keep in mind though, it's always some additional load and your system may be eventually impacted. This is unavoidable as you use I/O (to read the data), network (to transfer the data) and CPU (to manage whole process) while doing any kind of backup, rsync included.



    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk