MySQL Database Migration using Rsync

Comments

1 comment

  • Official comment
    Avatar
    Krzysztof Ksiazek

    Hi,

    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.

    Thanks,

    Krzysztof

Please sign in to leave a comment.

Powered by Zendesk