- Joined
- Jan 1, 2001
- Messages
- 60,096
How reliable are website backups when databases and data/ directories are involved, when using rsync?
For files that changed, it might be easy, but I do not yet really feel comfortable when it comes to database files.
I have this problem with Minecraft, I notice too much corruption, because on an active server the data flip flops way too much. I can only imagine on a very busy site with a master/slave/slave/slave setup it might be even worse.
Right now I do 2-way backups, the files and the normal stuff, and that is done with rsyncs and restoring data is reliable enough. But database dumps I just dump into a tarball and zip it up, and push to a remote box over encrypted connection.
For files that changed, it might be easy, but I do not yet really feel comfortable when it comes to database files.
I have this problem with Minecraft, I notice too much corruption, because on an active server the data flip flops way too much. I can only imagine on a very busy site with a master/slave/slave/slave setup it might be even worse.
Right now I do 2-way backups, the files and the normal stuff, and that is done with rsyncs and restoring data is reliable enough. But database dumps I just dump into a tarball and zip it up, and push to a remote box over encrypted connection.