We have some servers that runs a tomcat app with a MySQL database. These servers are in different cities and the web app is used locally by our customers.
On these servers a crontab job runs twice a day and make a full backup of databases and send (SCP) this dump to our central office's server. Then we take this dumps and apply to a local databases so if an emergency occurs our customers can continue using the app via internet.
The problem is every day the dumps are getting bigger and transfer this amount of data are not simple so we're looking for some incremental backups solution and a replication method with this incremental.
Can you give some ideas about how to do this? There is another solution better than what we want to do?
Thanks.
Best Answer
Keep the previous dump and use
rsyncor even better,rdiff-backup( http://www.nongnu.org/rdiff-backup/ ) through ssh instead of plain scp.