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 ?