Skip to main content
Tweeted twitter.com/StackDBAs/status/1266202891397861381
edited tags
Link
RolandoMySQLDBA
  • 184.4k
  • 33
  • 323
  • 531
Source Link
Luke Nguyen
  • 739
  • 2
  • 9
  • 22

Is possible to backup database online using rsync?

Some people tell me that the backup database on-the-fly using rsync is possible. I think it is possible but not safe because some log, buffer... is not flushed. Database is being recovered from the backup would not consistent.

Actually I am not sure why the backup using rsync is not safe. Could anyone explain me the underlying of mysql for the reason ?