what is best option to take mysql backup ( incremental backup ) without any database locking for a database having size more than 500 GB and increasing continuously.
also how to keep backup on different geographical location.
The method I used:
mysqldump : lock the table, not suitable for big databases and for real time application.
ibbackup : good tool but i do not find any incremental backup option there.
using binary log for incremental backup is time consuming process.