We have automated script to backup a 200 GB data files to a local disk. the script shutdown the database , tar and compress the entire directory locally on the disk, then start the database
tar -czvf data.tgz /some/folder
this process takes two hours which is too long downtime . we want to reduce this downtime.
consider the following: - the main target is to have identical copy of files in shortest available time while the database is down. later on, we can compress , transfer, or do any operation on the files.
I was thinking to use rsync to sync the files every week with the target backup, rsync will update only the changes which will take less time.
will that work, or there is better approach ?